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

> 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