Re: Windows Streaming replication -- Windows 2008 servers - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Windows Streaming replication -- Windows 2008 servers
Date
Msg-id CA+TgmoaecLUQZtfmsGJ-CfYesX0fvJ9SSX8Ysgm2c_h5+tRdUQ@mail.gmail.com
Whole thread Raw
In response to Windows Streaming replication -- Windows 2008 servers  (chinnaobi <chinnaobi@gmail.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: WIP Patch: Use sortedness of CSV foreign tables for query planning
Next
From: Robert Haas
Date:
Subject: Re: spinlock->pthread_mutex : real world results