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
|