Re: Sync Rep: First Thoughts on Code

Hi,

On Fri, Dec 12, 2008 at 1:34 PM, Aidan Van Dyk <aidan(at)highrise(dot)ca> wrote:
> * Fujii Masao <masao(dot)fujii(at)gmail(dot)com> [081211 23:00]:
>> Hi,
>
>> Or, should I
>> create the feature for the user to confirm whether it's in "synch rep" via SQL?
>
> I don't need a way to check via SQL, but I'ld love a postgresql.conf
> option that when set would make sure that all connections pretty much
> just hang until a slave has connected and everything is setup for "sync
> rep". I think I saw that youre using "normal" connection setup to start
> the wal streaming to the slave, so you have to allow connections, but
> I'ld really not want any of my pg-clients able to do anything if
> sync-rep isn't happenning...

How about stopping the request / connection from a client in front of
postgres (e.g. connection pooling software)? Or, we should develop
the feature like OFFLINE of Oracle apart from Synch Rep at first.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center