Edit Question - KnowledgeHub

Title Body

I started an amazon ec2 instance, and installed postgresql 9.1 over it. I then went to the Security Group: quicklaunch-1 (there was one more default` which i did not change) and opened the 5432 TCP Port, the table looks like this: (Service) Source Action 22 0.0.0.0/0 Delete 5432 0.0.0.0/32 Delete 5433 0.0.0.0/32 Delete 6432 0.0.0.0/32 Delete I have created a database and user . My /etc/postgresql/9.1/main/pg_hba.conf looks like this: # Database administrative login by Unix domain socket local all postgres peer # TYPE DATABASE USER ADDRESS METHOD host all all 0.0.0.0/0 md5 host db_name user_name 0.0.0.0/0 md5 # "local" is for Unix domain socket connections only local all all peer # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 # Allow replication connections from localhost, by a user with the # replication privilege. #local replication postgres peer host replication postgres 127.0.0.1/32 md5 host replication postgres ::1/128 md5 and /etc/postgresql/9.1/main/postgresql.conf looks like this: # - Connection Settings - listen_addresses = '*' #listen_addresses = 'localhost' # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to 'localhost', '*' = all # (change requires restart) port = 5432

Tags (comma-separated) Cancel