From: | Kazuaki Fujikura <fujya(at)fujya(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Subject: | Re: four template0 databases after vacuum |
Date: | 2016-02-15 05:22:05 |
Message-ID: | CA+7QymCdUtujMc-1MmCx=AE=+mgg7qtk+53X8vxzCyMXe2tFaA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Firstly, I apologise for the delay in replying to you.
>On which of the database clusters are you seeing the 4 template0
databases?
template0 looks the same on both the master and slave,
=======================================================
$ psql -U user -l -h master | grep template0
template0 | postgres | UTF8 | C
| C | =c/postgres +
template0 | postgres | UTF8 | C
| C | =c/postgres +
template0 | postgres | UTF8 | C
| C | =c/postgres +
template0 | postgres | UTF8 | C
| C | =c/postgres +
$ psql -U user -l -h slave1 | grep template0
template0 | postgres | UTF8 | C
| C | =c/postgres +
template0 | postgres | UTF8 | C
| C | =c/postgres +
template0 | postgres | UTF8 | C
| C | =c/postgres +
template0 | postgres | UTF8 | C
| C | =c/postgres +
$ psql -U user -l -h slave2 | grep template0
template0 | postgres | UTF8 | C
| C | =c/postgres +
template0 | postgres | UTF8 | C
| C | =c/postgres +
template0 | postgres | UTF8 | C
| C | =c/postgres +
template0 | postgres | UTF8 | C
| C | =c/postgres +
=======================================================
>How are the databases created?
We create database at createdb command.
ex) createdb -O user -E UTF8 --lc-ctype ja_JP.UTF8 -T template0 <dbname>
Best regards,
Kazuaki Fujikura
2016-02-11 4:41 GMT+09:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:
> 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 | David G. Johnston | 2016-02-15 06:10:33 | Re: four template0 databases after vacuum |
Previous Message | John R Pierce | 2016-02-15 04:21:54 | Re: Trouble installing PostGIS on Amazon Linux server |