Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tuesday, March 15, 2011 8:50:34 am general_lee wrote:
> Hi Guys,
> 
> I'm trying to allow a remote host on our 10.3.55.X network remote access to
> a Postgres Database on the same network.
> 
> We're running Solaris 10 with Postgres 83
> 
> My postgresql.conf looks like this;
> 
> 
> listen_addresses = '*'                  # what IP address(es) to listen on;
>                                         # comma-separated list of
> addresses; # defaults to 'localhost', '*' = all 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.0          trust
> # IPv6 local connections:
> host    all         all         ::1/128               trust
> 
> 
> I restart Postgres with;
> 
> svcadm restart svc:/application/database/postgresql_83:default_64bit
> 
> But I get a "connection refused" if I try and telnet to port 5432 from a
> remote host.

Is this a "connection refused" from Postgres or telnet?


> 
> What am I missing?
> 
> Thanks,
> 

-- 
Adrian Klaver
adrian.klaver@xxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux