I am facing an issue with AWS RDS Postgres connectivity from PGAdmin/psql command/web application
Background:
Created an AWS RDS PostgresSQL database
Made it public
Created inbound rules to allow all the traffic
Able to connect with DBeaver application and able to perform all the DB operations (create database, schema and tables)
But not able to connect with any of the following:
- PGAdmin
- psql command
- SpringBoot JPA
- Python script
Getting the following exception:
port 5432 failed: could not initiate GSSAPI security context: Unspecified GSS failure. Minor code may provide more information: Matching credential not found
port 5432 failed: FATAL: no pg_hba.conf entry for host
2