Hi, On Fri, Dec 12, 2008 at 1:34 PM, Aidan Van Dyk <ai...@highrise.ca> wrote: > * Fujii Masao <masao.fu...@gmail.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers