Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> writes: > Assuming controlled shutdown and that the standby received all WAL from the > old master before it was promoted, I think you can simply create a > recovery.conf in the old master's data directory to turn it into a standby > server, and restart. Am I missing something?
Would that mean that a controlled restart of the old master so that the recovery stops before applying the logs that were not shipped to the slave would put it in the same situation? How easy is it to script that? It seems all we need is the current XID of the slave at the end of recovery. It should be in the log, maybe it's easy enough to expose it at the SQL level… Regards, -- dim -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
