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