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