On Tue, 2010-10-26 at 14:27 -0400, Steeles wrote: > new to postgresl. 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 > direcotries to acheive backup goal, originally I was plainned 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. Backup is explained in a detailed chapter in the new book: PostgreSQL Administration Cookbook, available from the link below. -- Simon Riggs http://www.2ndQuadrant.com/books/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general