Re: [GENERAL] pg_dumpall for Postgres Database Daily Backup

2010-05-16 Thread Raymond O'Donnell
On 16/05/2010 16:59, Adrian von Bidder wrote: > * pint in time recovery This is what happens *after* work - this side of the pond, anyway :-) Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] pg_dumpall for Postgres Database Daily Backup

2010-05-16 Thread Adrian von Bidder
On Thursday 13 May 2010 17.50:31 Wang, Mary Y wrote: > http://www.postgresql.org/docs/8.3/static/backup-dump.html#BACKUP-DUMP-A > LL (I only found the documentation for 8.3.10), and it looks like > pg_dumpall > outfile is the best choice. pg_dumpall or by-database pg_dump ha the advantage that it

Re: [GENERAL] pg_dumpall for Postgres Database Daily Backup

2010-05-14 Thread Scott Mead
On Thu, May 13, 2010 at 8:16 PM, Scott Marlowe wrote: > On Thu, May 13, 2010 at 9:50 AM, Wang, Mary Y > wrote: > > Hi, > > > > I'm running on Postgres 8.3.8. My system admin is ready to set up a cron > job for a daily database backup. > > By reading the documentation over here: > http://www.post

Re: [GENERAL] pg_dumpall for Postgres Database Daily Backup?

2010-05-14 Thread Devrim GÜNDÜZ
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 l

Re: [GENERAL] pg_dumpall for Postgres Database Daily Backup

2010-05-13 Thread Scott Marlowe
On Thu, May 13, 2010 at 9:50 AM, Wang, Mary Y wrote: > Hi, > > I'm running on Postgres 8.3.8.  My system admin is ready to set up a cron job > for a daily database backup. > By reading the documentation over here: > http://www.postgresql.org/docs/8.3/static/backup-dump.html#BACKUP-DUMP-ALL (I >

Re: [GENERAL] pg_dumpall for Postgres Database Daily Backup

2010-05-13 Thread Vick Khera
On Thu, May 13, 2010 at 11:50 AM, Wang, Mary Y wrote: > it looks like pg_dumpall > outfile is the best choice.  I'd like to ask the > community to reconfirm. We do an individual pg_dump on each DB separately, using the '-Fc' format. The only thing we miss from pg_dumpall we get via "pg_dumpall

Re: [GENERAL] pg_dumpall for Postgres Database Daily Backup?

2010-05-13 Thread Joshua D. Drake
On Thu, 2010-05-13 at 09:15 -0700, Wang, Mary Y wrote: > Hi, > > I'm running on Postgres 8.3.8. My system admin is ready to set up a cron job > for a daily database backup. > By reading the documentation over here: > http://www.postgresql.org/docs/8.3/static/backup-dump.html#BACKUP-DUMP-ALL (I

[GENERAL] pg_dumpall for Postgres Database Daily Backup?

2010-05-13 Thread Wang, Mary Y
Hi, I'm running on Postgres 8.3.8. My system admin is ready to set up a cron job for a daily database backup. 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), and it looks like pg_dum

[GENERAL] pg_dumpall for Postgres Database Daily Backup

2010-05-13 Thread Wang, Mary Y
Hi, I'm running on Postgres 8.3.8. My system admin is ready to set up a cron job for a daily database backup. 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), and it looks like pg_dum