Error reading file C:/PostgreSQL/9.0/data/postgresql.conf

Hi All,

I'm trying to install PostgreSQL with the postgresql-9.0.3-2-windows on my 32bit Windows7 environment.
But unfortunately, I get the following error message. (pls see the attached image).

It says and the data folder is empty.

Any idea as to why this occur..??
Appreciate any assistance regarding this.

Thanks in advance.
Asela.

Hi,

Looking to the snapshot , its clear that there is no cluster creation at the time of installation. Installation has failed to create the data directory (cluster). Please verify the installation logs.

Try creating the cluster with INITDB command from the bin directory and start the cluster.

or

Use the uninstall-postgresql from 'C:\Program Files\PostgreSQL\9.0' location and start the fresh installation.

I'm getting this same error on 64-bit Windows 7 with the 64-bit installer. To fix this, I did the following:

1. Create the database using:

2. Change the owner of the created data folder. You can right-click in Explorer, select Properties, go to the Security tab, click Advanced, then go to the Owner tab, and set postgres to be the owner. Make sure you check the box that says something about subcontainers and objects getting the owner.

3. Now start the service through the Services control panel.

4. Log in with pgAdmin. Make sure you edit the connection information to use user postgres, since the default user for this is your login name.

That's all I needed to do to make this work, but it took me quite a while to figure it out. It'd be nice if the installer did the right thing!

tnx man, your solution resolved my problem!
I followed the steps that you described above and everything worked correctly

Hi at all.

I have the same problem but with one addition: the installation does not create the Postgres user and I did not create the databse but launch the command as above.

May you help me?

Thanks a lot