Amazon RDS - PostgreSQL Connecting to DBĪmazon RDS PostgreSQL provides easy ways of importing data into the DB and exporting data from the DB.Now we have upgraded to PostgreSQL 12 successfully. My application is hosted in Beanstalk (without a load balancer) was using SSL for connecting to PostgreSQL DB instance, so it raised the following issue SQLSTATE SSL SYSCALL error: Connection reset by peerĪfter some hours of debugging, I found that the issue raised is due to ssl_min_protocol_version which is added in PostgreSQL 12 parameter group, by default it is set to TLSv1.2, But the Apache HTTP Server used TLSv1 for connecting to PostgreSQL DB instance, so the connection was reset by peer due to mismatch on TLS protocol, To fix this I created a custom parameter group and updated ssl_min_protocol_version to TLSv1 After this is change, the connection issue was resolved! ALTER EXTENSION extension_name UPDATE TO ‘new_version’ Issues Use the below command to upgrade your extensions. As PostgreSQL engine upgrade doesn’t upgrade most of the PostgreSQL extensions. Once the ANALYZE is completed, Upgrade your extensions. ANALYZE -> This will be run on available tables in the current schema that the user has access to.ģ. This command will help the planner to choose the most appropriate query plan, and thereby improve the speed of query processing. Once REINDEX is completed, Run ANALYZE.ĪNALYZE gathers statistics for the query planner to create the most efficient query execution paths. Recreate all indices in the database -> REINDEX DATABASE database_nameĢ. Run REINDEX, The REINDEX command rebuilds one or more indices, replacing the previous version of the index.But the upgraded database is not ready to use!!!Īfter the Upgrade, if you connect the database to the app, you can see that some queries will take a long time and your app might become very very slow as compared to the previous performance, some API might fail due to query running for a long time! But we can fix these by doing the After upgrade steps. Once the upgrade is completed the status will be changed to Available in the RDS console. Select Apply immediately from Scheduling of modifications and click Modify DB instance.įrom here AWS will take care of the upgrade, based on DB size it will take some time to complete the upgrade.Click continue, you will see the Summary of modifications verify the modification you have made.Other details are auto-filled from the existing DB configuration.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |