RDS PostgreSQL Lifecycle

psql (11.16, server 12.11)WARNING: psql major version 11, server major version 12. Some psql features might not work.SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)Type "help" for help.

To resolve this issue... remove postgresql11 and install postgresql12

psql -h mypostgresqldb.eu-west-2.rds.amazonaws.com -U postgres -W -d postgres

psql (12.11)SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)psql: relocation error: psql: symbol PQgssEncInUse, version RHPG_10 not defined in file libpq.so.5 with link time reference

To resolve this issue...yum remove libpq.x86_64Then reinstall your target postgreSQL version

Patch

Minor updates are applied to RDS PostgreSQL automatically.

Upgrade

For example steps to upgrade RDS PostgreSQL between major versions in a CloudFormation Stack see the Jira Service Desk on AWS Stack Migration documentation.

JSD AWS Stack Migration

Bibliography

https://stackoverflow.com/questions/56980996/updating-rds-engine-version-minor-via-cloudformation-immediate-or-during-nexhttps://repost.aws/knowledge-center/ec2-install-extras-library-softwarehttps://stackoverflow.com/questions/72307187/how-to-install-postgresql-client-to-amazon-ec2-linux-machinehttps://stackoverflow.com/questions/76082320/alternative-of-amazon-linux-extras-in-amazon-linux-2023
PostgreSQL 10https://evol-monkey.blogspot.com/2018/02/postgres10-in-rds-first-impressions.html

Page updated

Google Sites

Report abuse