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.


26 views0 comments

Recent Posts

See All

PRCS-1007 : Server pool orcl already exists

This post is about fixing "PRCS-1007 : Server pool orcl already exists" While upgrading my RAC database, i have removed database from oracle restart. But I need to add that back. But, while registerin