Re: How to add hosts to pg_hba.conf and postgresql.conf?

To confirm, 10.3.55.182 is the Postgres Server

$ telnet 10.3.55.182 5432
Trying ...
telnet: Unable to connect to remote host: Connection refused

$ telnet localhost 5432
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.


$ psql -h 10.3.55.182 -U post_owner -d post_db
psql: could not connect to server: Connection refused
        Is the server running on host "" and accepting
        TCP/IP connections on port 5432?




My pg_hba.conf looks like this;


# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
host    all         all         10.3.55.0/24 255.255.255.255         trust
# IPv6 local connections:
host    all         all         ::1/128               trust



My postgresql.conf looks like this;

# - Connection Settings -

listen_addresses = '*'                  # what IP address(es) to listen on;
                                        # comma-separated list of addresses;
                                        # defaults to 'localhost', '*' = all
#port = 5432
max_connections = 100




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-add-hosts-to-pg-hba-conf-and-postgresql-conf-tp3708421p3711674.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.