Postres db Error : connection failed: FATAL: password authentication failed for user -AWS Aurora Postgres/RDS

Postgres Connection error : pgAdmin

connection failed: FATAL: password authentication failed for user "amd" connection to server at "dev-app-instance-1.gbhfthy.us-east-1.rds.amazonaws.com" (10.8767.11.10), port 5432 failed: FATAL: password authentication failed for user "amd"

Solution: 

create database abcd;

create user amd password 'amd';

grant connect on database abcd to rds_superuser;

grant  rds_superuser to amd;

Postgres db connection Error - Status : Failure -Test failed: FATAL: database "db_admin" does not exist

 

Status : Failure -Test failed: FATAL: database "db_admin" does not exist

Workaround: 

while connect using oracle sqlpdeveper to aurora postgres database/postgrs  database and you have a different user and db name. 

username: db_admin

password: password

Host: dev-app.cluster-abcsdedfff1afs.ue-east-1.rds.amazonaws.com/india?

Port: 5432

Solution - workaround

How to connect with PostgreSQL database using oracle SQLDeveloper ?

 

• Check the current sqldeveloper tool version 

• Download reqired postgres driver using below link 

https://jdbc.postgresql.org/download/

• Configure & add driver in the sqldevloper tool as below  

• After setup restart the sqldevloper tool  you will see the postgreSQL in option as below 

• Use postgres db login details and make connection 

You did it

 !!!!! Congarutaions !!!!!

Oracle Database Release and Technical Support Roadmap

 

Oracle Database Release and support Timelines