-----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 user of that .
No connections or no activity is happening in the database.pg_stat_activity just shows my connections with the status
as'IDLE'.
For more information on this,
When the standy server is stopped, then the pg_xlog's in the master server are stagnant.
As soon as I start the standby server in recovery mode and as soon as that server starts reading the data from Master
server, the pg_xlog files in Master server are getting created. And this looping of standy server reading the files &
Masterserver creating new log's is continuing for hours. SO I doubt somewhere in the set up the process is looping and
hereI need the help.
Thanks
Jahnavi
-----Original Message-----
From: Ray Stell [mailto:stellr@cns.vt.edu]
Sent: Wednesday, July 06, 2011 9:55 PM
To: Jahnavi Chintakunta
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Need help in Postgres log shipping replication
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 queried pg_stat_activity during this xlog generation?
DISCLAIMER:
This email may contain confidential information and is intended only for the use of the specific individual(s) to which
itis addressed. If you are not the intended recipient of this email, you are hereby notified that any unauthorized use,
disseminationor copying of this email or the information contained in it or attached to it is strictly prohibited. If
youreceived this message in error, please immediately notify the sender at Infotech or
Mail.Admin@infotech-enterprises.comand delete the original message.