Create Amazon RDS PostgreSQL and Connect using psql and pgadmin
Login to Amazon AWS Console and Open Amazon RDS Section
Follow the following steps to create a RDS PostgreSQL Database
Click on Create Database
Note: Version 13 doesn't have Free Tier Option. So, this will be chargeable.
Use the smallest configuration.
For this post, we are using Public Access as Yes. In real life scenario it should be always No.
Click on Create Database, It will create the Database. Make sure to delete the database after doing your learning as this will incur cost.
Now the RDS is ready.
Following are my RDS Database Details. I am showing the connection details here because I am going to delete the instance as soon as I am done creating this post.
Connect the RDS Database from my local VM using psql
[root@basevm ~]# psql --host=mypostgres.cvemhwjuocr5.us-east-2.rds.amazonaws.com --port=5432 --username=postgres --password Password: psql (13.2) SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off) Type "help" for help.
Connect from pgadmin4 GUI Tool
Click on Save to Connect.
After successful connection, following page will appear.
Thanks for Reading my post. Hope it helps.