Thread: Windows Streaming replication -- Windows 2008 servers
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 />
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