parsed.org
PostgreSQL Dump & Restore by xinu on Mar 25, 2008 11:46 PM

In 7.4 (and possibly 8.1), the routine to dump and restore the entire database cluster follows:

# su - postgres
$ pg_dumpall > postgresql.dmp

Transfer the postgresql.dmp file to the target system, and then do the import:

# su - postgres
$ psql template1 < postgresql.dmp
dumpmigratepg_dumpallpostgresqlpsqlrestore
RSS