Security, consistency, and quality checking.ModerationĮvery version of each package undergoes a rigorous moderation process before it goes live that typically includes: Internally, Amazon RDS uses the pg_upgrade utility to perform the upgrade.Welcome to the Chocolatey Community Package Repository! The packages found in this section of the site are provided, maintained, and moderated by the community. If you’re running PostgreSQL 9.6 on an Amazon RDS instance, use this method to upgrade to PostgreSQL 12. Upgrade an Amazon RDS instance to PostgreSQL 12
High Availability, Load Balancing, and Replication PostgreSQL 12 Documentation - Chapter 26. PostgreSQL 12 Documentation - 18.6.3 Upgrading Data via Replication This method does not require taking Jira or your current database server offline to perform the the upgrade, which minimizes downtime to just a few seconds needed to perform a switchover. If you’re currently running PostgreSQL in a high-availability cluster configuration, you can use the native PostgreSQL replication tools or an external replication system to replicate data from your primary server to a new standby server running PostgreSQL 12. Use logical replication to upgrade to PostgreSQL 12 with minimal downtime If you’re satisfied with the upgrade, delete the old PostgreSQL 9.6 database cluster. Verify the upgrade by checking the pg_upgrade.log file and ensuring that Jira is working correctly. Start the PostgreSQL 12 server and - if required - perform post-upgrade processing. Perform an ANALYZE operation on the new database to regenerate optimizer statistics.įor more information, see PostgreSQL 12 Documentation - ANALYZE. Run pg_upgrade (add the the -link option to run pg_upgrade in link mode). Install any custom shared object files that were used by the old cluster and adjust authentication. Install PostgreSQL 12 and initialize the new database cluster. For more detailed upgrade instructions, see PostgreSQL 12 Documentation - pg_upgrade. The following is a high-level outline of the upgrade process.
If you need to roll back to the old cluster, you will have to restore its data from backup. Running pg_upgrade in link mode renders the old database cluster inaccessible. Both Jira and the PostgreSQL database will be unavailable during the upgrade.
0 kommentar(er)
