Connect pgadmin to RDS AWS Elastic beanstalk

Question

I'm trying to connect my RDS postgres SQL databade to my pgAdmin III to see the BBDD and add data but the connection launches the following one error: pgAdmin message

My pg_hba.config have the following one configuration:

# TYPE  DATABASE        USER            ADDRESS                 METHOD
# IPv4 local connections: host    all             all           127.0.0.1/32            md5    
host    all             all             0.0.0.0/0               md5
# IPv6 local connections:
host    all             all             ::1/128                 md5    
#host    replication     postgres        127.0.0.1/32           md5
#host    replication     postgres        ::1/128                md5

and my postgresql.conf:

listen_addresses = '*'      
port = 5432             
max_connections = 100

I have configured the firewall rules in my windows desktop, for the pgadmin be able to communicate through TCP for the 5432 port.

I also Attach the variables of the connection:pgadmin connection

Thanks, If you can help me, I'll it grateful.

Yeshodhan Kulkarni Yeshodhan Kulkarni · Accepted Answer · 2017-05-23T22:04:43

0

votes

Check if your security group has an entry for port 5432 on TCP.

Connect pgadmin to RDS AWS Elastic beanstalk

2 Answers