In response to Steeles <steeles@xxxxxxxxx>: > new to postgresql. need to backup postgresql DB, which way is better to > backup DB. > > from training, I learned that we can backup the whole PGdata and other > directories to achieve backup goal, originally I was planned to schedule > jobs to use pgdump to backup all DBs. > > so which way is better for backup or there is other way to backup PGDB. Use pg_dump or pg_dumpall. If you're at the level that you have to ask this question, then you'll have nothing but trouble getting reliable backups by backing up directories. Also, since you're new to PostgreSQL, I _HIGHLY_ recommend that you don't assume that you're getting backups until you can demonstrate that you can restore them. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
