> 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. I'll give you pretty good odds your postmaster is not listening on '*' like you want it to. What does 'netstat -a | grep LISTEN' tell you? Benny -- "Hairy ape nads." -- Colleen, playing Neverwinter Nights -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
