Hi, On Thu, Jul 9, 2009 at 11:13 PM, Kevin Grittner<kevin.gritt...@wicourts.gov> wrote: > Fujii Masao <masao.fu...@gmail.com> wrote: >> Kevin Grittner<kevin.gritt...@wicourts.gov> wrote: > >>> I think the interesting bit is when you're at this point and the >>> connection between the master and slave goes down for a couple >>> days. How do you handle that? >> >> In the current design of synch rep, you have only to restart the >> standby after repairing the network. > > How long does the interruption need to last to require manual > intervention?
It depends on when the files required for the standby's recovery have gone from the primary. If they exist in the primary's archive forever, there would be no chance to do manual copying of them. > Would an automated retry make sense? (I'd bet that > more days than not we lose connectivity to at least one of our remote > sites for at least a few minutes.) Yes, but I think that it's not postgres' but clusterware's job. 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
