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

On 03/15/2011 10:37 AM, general_lee wrote:
> 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

Not sure that it makes a difference, but you only need to do one of either:
10.3.55.0/24
10.3.55.0 255.255.255.0

> # 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.
>


--
Adrian Klaver
adrian.klaver@gmail.com