Re: Initdb error during silent install on windows 2000 - Mailing list pgsql-admin

One update on this problem.

 

I updated my install script to create a directory "md C:\pgdata" and update the command line for postgresql install to include "DATADIR=C:\pgdata" and everything works fine.

 

Maybe the space in "Program Files" is causing this problem?  But then again the installation worked fine for at least 15 other PCs where the data base data was in C:\Program Files.

 

Don't know what's going on here.

 

Thanks

 

Karim

 

----- Original Message -----

From: Karim Mardhani

To: pgsql-admin@postgresql.org

Sent: Monday, September 05, 2005 12:13 PM

Subject: [ADMIN] Initdb error during silent install on windows 2000

Hi All:

 

I am getting following error from initdb during silent installation of 8.0.1:

 

creating directory C:/Program Files/PostgreSQL/8.0/data/global ... initdb: could not create directory "C:/Program Files": File exists

 

I have searched about this issue and usually this happens due to a permission problem.  I have checked the permission they look fine to me.  Also I have used same install on at least 15 other PCs (Mix of win 2K and win xp) and it worked fine for each one except this one.  Any ideas what might be the problem?  Following are the permissions on this PC (BTW other PCs have exactly same permissions and install works without any problem):

 

C:\:  Everyone => Allow FullControl, No Deny

C:\Program Files: Group User => Allow Read &Execute, List Folder Content, Read.  No Deny

 

The user postgres is member of group Users.

 

Thanks in advance for your help.

 

Thanks

 

Karim