top of page
  • Writer's pictureSudipta 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 --port=5432 --username=postgres --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.

36 views0 comments

Recent Posts

See All

How to Convert Physical Standby To Active DataGuard

Standby database SQL> select open_mode , protection_mode , database_role from v$database; OPEN_MODE      PROTECTION_MODE   DATABASE_ROLE -------------------- -------------------- ---------------- MOUN

ORA-00845: MEMORY_TARGET not supported on this system

srvctl start asm fails with the following error. [oracle@sbstandby ~]$ srvctl start asm PRCR-1079 : Failed to start resource ora.asm CRS-2674: Start of 'ora.LISTENER.lsnr' on 'sbstandby' failed CRS-50


Post: Blog2_Post
bottom of page