On Thu, Apr 11, 2013 at 10:25 PM, Hannu Krosing <ha...@2ndquadrant.com> wrote: > > You just shut down the old master and let the standby catch > up (takas a few microseconds ;) ) before you promote it. > > After this you can start up the former master with recovery.conf > and it will follow nicely.
No. When you shut down the old master, it might not have been able to send all the WAL records to the standby. I have observed this situation several times. So in your approach, new standby might fail to catch up with the master nicely. Regards, -- Fujii Masao -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
