From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Kazuaki Fujikura <fujya(at)fujya(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: four template0 databases after vacuum |
Date: | 2016-02-10 19:41:08 |
Message-ID: | 56BB9254.7030707@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | drum.lucas@gmail.com | 2016-02-10 19:56:43 | Input data for column is not compatible with data type |
Previous Message | Karsten Hilbert | 2016-02-10 19:19:28 | Re: PostgreSQL vs Firebird SQL |