Howto Backup PostgreSQL Databases Server With pg_dump comman

Howto Backup PostgreSQL Databases Server With pg_dump comman

Postby stephen » 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
stephen
 
Posts: 507
Joined: Thu Feb 09, 2006 9:37 am
Location: Brisbane

Return to Postgresql

Who is online

Users browsing this forum: No registered users and 0 guests

cron