(TIL) PSQL: Terminating A Connection
Consider the scenario where you are trying to drop a database, but there are existing connections.
Recent Posts
(TIL) PSQL: List Connections To A Database
The pg_stat_activity table can be used to determine what connections there currently are to the PostgreSQL server and to a particular database. To see the pr...
(TIL) PSQL: Sleeping
Generally you want your SQL statements to run against your database as quickly as possible. For those times when you are doing some sort of debugging or just...
(TIL) PSQL: Get The Size Of An Index
Want to get an idea of how much disk space that additional index is taking up?
(TIL) PSQL: Restore a database
To restore the dump, create a fresh database and then use pg_restore: