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.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
