Extracting a single database from a pg_dumpall PostgreSQL dump

Some data got deleted from one of our databases, and we had to restore it from our backups.

To make sure we get everything from our PostgreSQL cluster’s, we use pg_dumpall to make a SQL dump. It’s in no way the most efficient way to do a backup of a PostgreSQL database cluster, but it is by far the most flexible.

Update 16-12-2013: Rune Kaagaard updated the script and added an installer. Thanks Rune!

Continue reading Extracting a single database from a pg_dumpall PostgreSQL dump