On 03/06/2015 02:43 PM, Stephen Frost wrote:
Right, as I mentioned, template0 shouldn't have datallowconn as 'true'.
That's why it's being included in the pg_dumpall.
On your test setup, run (as superuser):
update pg_database set datallowconn = false where datname = 'template0';
Then re-run th
On 03/06/2015 01:55 PM, Adrian Klaver wrote:
So on the original cluster, log in using psql and do \l and post the
results here. Thanks.
[...]
Meant to add to previous post, to check with issue that Stephen
mentioned do:
select datname, datallowconn from pg_database ;
postgres=# \l
On 03/06/2015 12:37 PM, Adrian Klaver wrote:
Agreed, I am just trying to figure out how you get:
CREATE DATABASE "template0" WITH TEMPLATE = template0 ..
Seems to be a snake eating its tail:)
Yes. It does. And it's pretty obvious why having this would be a
problem...not quite so obvious how
Attempting to upgrade a large (>3TB) postgressql database from 9.3 to
9.4 on Ubuntu 14.04 LTS, but the process fails fairly early on. The
error message instructs me to look at the last few lines of
pg_upgrade_utility.log for more info, and the last two lines there (the
only ones that don't succ
