V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

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.