Alan Deane wrote:
Hi Chris,
Thanks for your reply.
Maybe I should have reworded it slightly better or fuller. I assumed that
having ConfigDir/pg_hba.conf line in postgresql.conf would look for the hba
file in the directory relative to where postgres is installed. I.e. the data
directory and given that the service when it starts uses
g:/Program Files/PostgreSQL/8.3/bin/pg_ctl.exe runservice -N
"postgresql-8.3" -D "G:/Program Files/PostgreSQL/8.3/data" -w
Must be based off where the service name is, I'm not sure.
and from what I've read the -D switch is basically telling postgres where to
find the conf files and setting the relative path for ConfigDir, so I was
surprised that it looked for the hba conf in the system32 directory.
Yeh, I would have thought it would pick up from the data dir not
somewhere else.
As for the networking side of things. I have opened port 5432 on my firewall
and I also disabled the firewall (Kaspersky btw not Windows it is disabled
permanently).
My pg_hba.conf file reads.
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 192.168.2.0/16 trust
I have only set it to trust for testing purposes as soon as I get a connect
it will be going back to md5.
and the error when you try to connect is?
Did you restart postgres after changing the pg_hba.conf file?
Seems like it should work.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
