Which version of PostgreSQL database engine is running ?
I have credentials to access PostgreSQL via pgAdmin 4. Amazon RDS is a managed relational database service for PostgreSQL in our corporate environment. We got AWS notification saying that Amazon RDS support for your current version of postgres database engine ends and asked us to upgrade. But I don’t have access to AWS console or SSH access to this database service. Let’s see how to find which version of PostgreSQL database engine is running in AWS.
Check which version of PostgreSQL
To check which version of PostgreSQL you need to run the following query “SELECT version()” from pgAdmin 4 tool as shown below.
From the above query result it is evident that the AWS RDS in corp environment is running PostgreSQL 11.19 version.
Why we need to check PostgreSQL version ?
In this case Amazon RDS provides newer versions of each supported database engine so that we need to keep your DB instance up-to-date. And Amazon RDS support for PostgreSQL 11.19 database engine is going to end soon.
Hence we need to check current version and upgrade to newer major version of PostgreSQL database engine which is backward-compatible with existing applications.
- Visualize database tables and relations in postgreSQL using PgAdmin ?
- How to Start Stop Restart MariaDB on Linux OS ?
- MariaDB – How to set max_connections permanently ?
- Find mongo documents where a field contains a string pattern
- How to set or change root password in Ubuntu Linux ?
- Putty Fatal Error No supported authentication methods available
- How to find which users belongs to a specific group in linux
- Give write permissions for specific user or group for specific folder in linux
- MongoDB equivalent command for SQL’s between numbers, text or dates
- Sort numeric strings as numbers in mongodb database
- How to search a specific string in JSON or JSONB array in PostgreSQL ?
- Sort numeric strings as numbers in mongodb database
- Is it possible to change Google Cloud Platform Project ID ?
- Create non-root SSH user account and provide access to specific folders
- What is the purpose of Git Stash command ?
- The pgAdmin 4 PostgreSQL server could not be contacted