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.
