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
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
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
> 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
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
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