Information Systems



How do I get a backup of an entire postgresql server

Use pg_dumpall. Depending on how you set up your access permissions it would be something like:

pg_dumpall -h localhost -U postgres > db.out

To restore:

psql -f db.out -h localhost -U postgres postgres