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

On Tuesday, March 15, 2011 1:33:48 pm general_lee wrote:
> Guys,
>
> Thanks for your help.
>
> When I saw that netstat was not listening as *.5432 I decided to;
>
> svcadm disable svc:/application/database/postgresql_83:default_64bit
>
> Then;
>
> pg_ctl -D /var/lib/pgsql/data -l postmaster.log start
>
> This fixed the problem.
>
> You guys were right on the money, looks like restarting via smf was not
> picking up the config changes. So I guess they need to be made elsewhere in
> Solaris.

What it probably means is that this:

svc:/application/database/postgresql_83:default_64bit

is pointing at a different instance of Postgres than this:

pg_ctl -D /var/lib/pgsql/data -l postmaster.log start

My guess is if you search for postgresql.conf and pg_hba.conf you will find more
than one copy of each and that the copies that are not in /var/lib/pgsql/data
are the ones being used for the svc start.

>
> I can now talk to my PG DB via a remote host.
>
> Big thanks the help.
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com