Search
  • Sudipta Bhaskar

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.


30 views0 comments

Recent Posts

See All

1Z0-083 Few Important Links

Following are few important links to prepare for the certification. Oracle® Multitenant Administrator’s Guide https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/index.html Backup and

Certification Overview

This has been downloaded from oracle website. It contains syllabus and other sample questions for both 082 and 083. Please concentrate on 083.