SQL statements to list settings defined in postgresql.conf and overriden by postgresql.auto.conf.
PostgreSQL Terminate Active Connections
Sometimes we need to terminate active connections to a database forcefully. Doing such requires two things, determining which active connections to target and running the command to terminate them. This post shows how to terminate active connections using some SQL
PostgreSQL – Create superusers If You Don’t Have Them
During the initial phase of our application development, we need superusers for our database, especially when we are starting with greenfield projects and no prior databases exist. Most of the time, we use this type of user to run DDL