Skip site navigation (1) Skip section navigation (2)

warm standby question

From: "Lee, Mija" <mija(at)scharp(dot)org>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: warm standby question
Date: 2010-01-09 00:26:38
Message-ID: 5D1219ADBE9E6C4CA6F0F89C811C102F0430A481@ISIS.fhcrc.org (view raw or flat)
Thread:
Lists: pgsql-admin
Hello -
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
pg_xlog/RECOVERYXLOG 000000010000000000000020
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!
Mija


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 KDate: 2010-01-12 08:33:56
Subject: Very simple password for DB administrator
Previous:From: Gurjeet SinghDate: 2010-01-07 08:12:43
Subject: Re: How can i change the Postgres Database password?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group