Re: [ADMIN] WAL files during a backup

2008-08-28 Thread steve
D]" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: pgsql-admin@postgresql.org > Sent: Wednesday, August 27, 2008 5:31:30 PM > Subject: Re: [ADMIN] WAL files during a backup > > This WAL wont get copied to the archive directory until it reaches 16MB > worth of trans

Re: [ADMIN] WAL files during a backup

2008-08-28 Thread windsurferdrew-pg
directory. Drew - Original Message From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: pgsql-admin@postgresql.org Sent: Wednesday, August 27, 2008 5:31:30 PM Subject: Re: [ADMIN] WAL files during a backup This WAL wont get copied to the archive directory

Re: [ADMIN] WAL files during a backup

2008-08-28 Thread windsurferdrew-pg
o the pg_xlog directory in the last 6 hours since the last backup was performed. Drew - Original Message From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: pgsql-admin@postgresql.org Sent: Wednesday, August 27, 2008 4:36:24 PM Subject: Re: [ADMI

Re: [ADMIN] WAL files during a backup

2008-08-27 Thread steve
> From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: pgsql-admin@postgresql.org > Sent: Wednesday, August 27, 2008 4:36:24 PM > Subject: Re: [ADMIN] WAL files during a backup > > 0001223387 would usually be the ne

Re: [ADMIN] WAL files during a backup

2008-08-27 Thread steve
0001223387 would usually be the next WAL to be written. How often are you WALs written out? On Wed, 27 Aug 2008 07:07:17 -0700 (PDT), [EMAIL PROTECTED] wrote: > I have a question regarding the WAL files that are moved during a backup to > the "archive directory". > > I have setup

[ADMIN] WAL files during a backup

2008-08-27 Thread windsurferdrew-pg
I have a question regarding the WAL files that are moved during a backup to the "archive directory". I have setup the postgresql.conf file to have the following archive command: archive_command = 'cp -i %p /var/lib/pgsql/backups/%f .tar.gz, and 2. a WAL file ".backup" file, (for example 000