Matt, * Matt Landry (lelnet.m...@gmail.com) wrote: > postgres=# select datname, datallowconn from pg_database ; > datname | datallowconn > -----------+-------------- > template1 | t > template0 | t > postgres | t > reporting | t > (4 rows)
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 the pg_upgrade.
Thanks!
Stephen
signature.asc
Description: Digital signature
