On Thu, 2010-05-13 at 09:15 -0700, Wang, Mary Y wrote: > By reading the documentation over here: > http://www.postgresql.org/docs/8.3/static/backup-dump.html#BACKUP-DUMP-ALL (I only found the documentation for 8.3.10), If you replace 8.3 with current, you will get the current docs. > and it looks like pg_dumpall > outfile is the best choice. Depends. Many people tend to dump each database individually, especially using -Fc parameters in order to restore them easily. If you choose this route, please note that you will also need to dump globals using pg_dumpall -g. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment:
signature.asc
Description: This is a digitally signed message part
