Insufficient coffee:
My environment is a little strange (at least I never read about one
set up like this before I built it) and has some associated oddities
in the old segment cleanup process - All of my slaves mount an
archive partition on the master (read-only) and every log file is
"p
alf Of Michael
Graziano
Sent: Tuesday, October 13, 2009 12:45 PM
To: David F. Skoll
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Warm standby questions
On Oct 13, 2009, at 1:17 PM, David F. Skoll wrote:
Hi,
I'm running PostgreSQL 8.3. Suppose I have master server A shipping
logs
to back
On Tue, 2009-10-13 at 13:17 -0400, David F. Skoll wrote:
> Q2. If I stop and restart backup server B while master server A continues
> to run, will B continue eating WALs from where it left off? Or do we need
> another full backup? (We'll assume WAL shipping continues successfully during
> the
On Oct 13, 2009, at 1:17 PM, David F. Skoll wrote:
Hi,
I'm running PostgreSQL 8.3. Suppose I have master server A shipping
logs
to backup server B. At some time in the past, I did a full backup
from A
to B, and now B is running in recovery mode, happily consuming WALs.
I'm running 8.4,
Hi,
I'm running PostgreSQL 8.3. Suppose I have master server A shipping logs
to backup server B. At some time in the past, I did a full backup from A
to B, and now B is running in recovery mode, happily consuming WALs.
Q1. If I stop and restart master server A gracefully, do I need to do
anyth
