[Pkg-postgresql-public] Bug#844053: Acknowledgement (postgresql-common: pg_upgradecluster fails with NOT VALID constraints)
Liam Morland
Liam at Morland.ca
Sat Nov 26 18:00:04 UTC 2016
For the reference of others having this problem:
I was able to upgrade by using pg_upgrade instead of pg_upgradecluster,
following the instructions here:
https://wiki.postgresql.org/wiki/Using_pg_upgrade_on_Ubuntu/Debian
The upgrade maintained the NOT VALID constraints.
I could also have used pg_dump; it included the NOT VALID constraints in
the dump file. The contraints are added at the end so that the import
works.
More information about the Pkg-postgresql-public
mailing list