Matt, * Matt Landry (lelnet.matt@xxxxxxxxx) 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
Attachment:
signature.asc
Description: Digital signature