Upgrade Considerations v10
The following limitations apply to upgrading EDB Postgres Advanced Server:
pg_upgradeutility cannot upgrade a partitioned table if a foreign key refers to the partitioned table.
- If you are upgrading from the version 9.4 server or a lower version of Advanced Server, and you use partitioned tables that include a
SUBPARTITION BYclause, you must use
pg_restoreto upgrade an existing Advanced Server installation to a later version of Advanced Server. To upgrade, you must:
pg_dumpto preserve the content of the subpartitioned table.
- Drop the table from the Advanced Server 9.4 database or a lower version of Advanced Server database.
pg_upgradeto upgrade the rest of the Advanced Server database to a more recent version.
pg_restoreto restore the subpartitioned table to the latest upgraded Advanced Server database.