Thread: Windows Streaming replication -- Windows 2008 servers

Windows Streaming replication -- Windows 2008 servers

From
chinnaobi
Date:
Hi All, It would be helpful if someone tell me, how to verify the streaming replication started in standby server
successfully,just after the service is started ?? Like knowing the exit code of the service started... I know we can do
itby verifying the below functions after the service is started .. select pg_last_xlog_replay_location() select
pg_last_xlog_current_location()select pg_last_xlog_receive_location() Regards, Reddy. <br /><hr align="left"
width="300"/> View this message in context: <a
href="http://postgresql.1045698.n5.nabble.com/Windows-Streaming-replication-Windows-2008-servers-tp5718921.html">Windows
Streamingreplication -- Windows 2008 servers</a><br /> Sent from the <a
href="http://postgresql.1045698.n5.nabble.com/PostgreSQL-hackers-f1928748.html">PostgreSQL- hackers mailing list
archive</a>at Nabble.com.<br /> 

Re: Windows Streaming replication -- Windows 2008 servers

From
Robert Haas
Date:
On Mon, Aug 6, 2012 at 1:41 AM, chinnaobi <chinnaobi@gmail.com> wrote:
> Hi All, It would be helpful if someone tell me, how to verify the streaming
> replication started in standby server successfully, just after the service
> is started ?? Like knowing the exit code of the service started...

It doesn't really work that way.  The service starts up and begins
recovery, and only when it finds that it needs more write-ahead log
records does it begin streaming (or restoring from the archive).  So
although it's normally quick, in theory there could be a very long
delay between the time the service is started and the time streaming
begins; so it's not something we can really report via an exit code at
startup time.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company