On 02/10/2016 07:19 AM, Kazuaki Fujikura wrote:
Thank you for your comments. >Can you explain what your replication set up is? Streaming Replication. => master----slave1 (async) master----slave2 (async) >So are you doing the below on the master, the slaves or all? =>master Our current plan at this moment is - Upgrade 9.1.19 from 9.1.6 at the end of March at our scheduled maintenance - Export and import pg_dump files ( to eliminate the effect of template0 and xid, which are all reset at import) We are still afraid that it is too late (as we still have 4 strange template0 files). So, if you have any ideas/suggestions which we can try before scheduled maintenance, that is much appreciated.
On which of the database clusters are you seeing the 4 template0 databases? From a previous post: "We have more than 1100 databases and create new database every day whenever new customer comes. .." How are the databases created?
Best regards, Kazuaki Fujikura
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
