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?
