Export a database
su - postgres
pg_dump <database_name> > database_name.pgdump
Import a database
cat database_name.pgdump | psql -d database_name
For all database
pg_dumpall -o > db_all.out
psql -e template1 < db_all.out
June 23, 2008
Export / Import PostgreSQL database
1 Comment »
RSS feed for comments on this post. TrackBack URI
IT Base of Knowledge's Weblog 
This post saved my day. Far superior than phppgadmin. 🙂
Just a note, you can skip “su – postgres” if you have a postgres user with the same username as your shell account. Then you’ll have your databases automatically owned by you also.
Comment by Lilleman — November 19, 2009 @ 3:14 pm |