Howto Backup PostgreSQL Databases Server With pg_dump comman
Posted: Wed Apr 09, 2008 10:05 pm
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
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