Search Postgresql Archives

Re: four template0 databases after vacuum

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.klaver@xxxxxxxxxxx>:
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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux