Page 1 of 1

Howto Backup PostgreSQL Databases Server With pg_dump comman

PostPosted: Wed Apr 09, 2008 10:05 pm
by stephen
Howto Backup PostgreSQL Databases Server With pg_dump command
http://www.cyberciti.biz/tips/howto-backup-postgresql-databases.html

from above site
Task: dump a payroll database

Type the following command
$ pg_dump payroll > payroll.dump.out

To restore a payroll database:
$ psql -d payroll -f payroll.dump.out