PostgreSQL Backup Tips for n00bz

This post has been moved to


Published by

Trevor Turk

A chess-playing machine of the late 18th century, promoted as an automaton but later proved a hoax.

2 thoughts on “PostgreSQL Backup Tips for n00bz”

  1. A way to get a list of databases in a useful format for scripting can be done with this command:

    psql –username=USERNAME -P format=Unaligned -tqc 'SELECT datname FROM pg_database;'

Comments are closed.