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?
I then created a ConfigDir in the system32 dir and copied the pg_hba.conf into there. Now the server starts. However, It doesn't ring true to my mind that the file should be located there.
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.
This is a brand new install and it has been installed in the default directories, however, on a different drive rather than c:
BTW, the properties of the service read:-
g:/Program Files/PostgreSQL/8.3/bin/pg_ctl.exe runservice -N "postgresql-8.3" -D "G:/Program Files/PostgreSQL/8.3/data" -w
Any help appreciated,
Thanks Alan.
