On Wed, Jul 06, 2011 at 07:34:11PM +0530, Jahnavi Chintakunta wrote:
>
>
> When the standy server is stopped, then the pg_xlog's in the master server
> are stagnant.
Sorry, I've never seen this before.
What is archive_timeout set to?
template1=# show archive_timeout;
archive_timeout
-Original Message-
From: Jahnavi Chintakunta
Sent: Wednesday, July 06, 2011 10:03 PM
To: 'Ray Stell'
Subject: RE: [ADMIN] Need help in Postgres log shipping replication
Thanks Ray for the reply.
Actually I am testing replication in a test Database & I'm the sole
On Wed, Jul 06, 2011 at 03:02:22PM +0530, Jahnavi Chintakunta wrote:
>
> But these files are getting copied continuously and they are not stopping.
>
> Master is generating pg_xlog files even when there is no activity on the
> database.
How did you determine there was no activity? Have you que
