Limitations

The following limitations apply to EDB Postgres Advanced Server:

• The `data` directory of a production database should not be stored on an NFS file system.
  

• The `pg_upgrade` utility 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 BY` clause, you must use `pg_dump` and `pg_restore` to upgrade an existing Advanced Server installation to a later version of Advanced Server. To upgrade, you must:
  

  • 1. Use pg_dump to preserve the content of the subpartitioned table.

  • 2. Drop the table from the Advanced Server 9.4 database or a lower version of Advanced Server database.

  • 3. Use pg_upgrade to upgrade the rest of the Advanced Server database to a more recent version.

  • 4. Use pg_restore to restore the subpartitioned table to the latest upgraded Advanced Server database.

• If you perform an upgrade of the Advanced Server installation, you must rebuild any hash-partitioned table on the upgraded server.