I am working on setting up warm standby for one of my servers and I am a
little confused about the documentation. I am using pg_standby on
postgres 8.4.1 running on linux.
My recovery.conf is very basic:
restore_command = 'pg_standby /shared_pitr %f %p %r'
On the secondary, I can see two processes:
postgres: startup process waiting for 000000010000000000000037
/services/8.4/bin/pg_standby /shared_pitr 000000010000000000000037
which does in fact refer to what would be the next WAL file.
Based on the documentation, it looks like the wal files that have
already been replayed should be automatically removed from the archive
directory by using the %r macro. This does not appear to be happening.
Do I have to write a script to remove archived wal files prior to
000000010000000000000037, or do I have the system set up incorrectly?
Thanking you in advance for any help!
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential, proprietary, and/or privileged information protected by
law. If you are not the intended recipient, you may not use, copy, or
distribute this e-mail message or its attachments. If you believe you
have received this e-mail message in error, please contact the sender by
reply e-mail and destroy all copies of the original message.
pgsql-admin by date
|Next:||From: N K||Date: 2010-01-12 08:33:56|
|Subject: Very simple password for DB administrator|
|Previous:||From: Gurjeet Singh||Date: 2010-01-07 08:12:43|
|Subject: Re: How can i change the Postgres Database password?|