Alan Deane wrote:
Hi All,
I was wondering if anyone has had this problem and knows an answer. This
is the first time I have used postgres so I am at a loss after trying
many things as to how to solve the problem.
I've unremmed the line hba_file = 'ConfigDir/pg_hba.conf' in the
postgresql.conf file as I want to be able to connect to the data base
from another machine on my LAN.
I have also added the IP range into the pg_hba.conf file.
Now I get a Windows Services error saying the server started and stopped
and no access on the local machine, unsurprisingly.
Having a look at the event viewer showed the following error.
%t FATAL: could not open configuration file
"C:/WINDOWS/system32/ConfigDir/pg_hba.conf": No such file or directory
Hmm, that's interesting, why would it be looking there and not in the
data folder where pg_hba.conf resides?
Because you've supplied a relative path.
You can supply a full path:
G:/Program Files/PostgreSQL/8.3/data/pg_hba.conf
or leave it commented out for it to look in the data/ folder you specify
already.
Also despite enabling the network IP addresses in pg_hba.conf I still
can’t connect to the database from a remote machine. Although I’d like
to solve the system32 problem first before I start worrying about
network connections.
Can you post the uncommented parts of pg_hba.conf and what ip you are
trying to connect from?
Also what's the error?
and lastly - have you opened port 5432 in your firewall?
--
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
