Re: initdb failure

From: "Pankaj Mandal (pmandal)" <pmandal(at)cisco(dot)com>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: initdb failure
Date: 2010-04-10 01:42:21
Message-ID: 2873D0DE40695D48B76CDF7C6620A1540A2D5799@xmb-sjc-226.amer.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Kevin,

I have checked this several times. The installer is executed by user
Administrator (which apparently has all Administrator privileges)
The user postgres is also being created and the data directory is owned
by this user, which does have read, write, execute, modify, list folder
contents and they are all inheritable. Here I am copying few more lines
from the logs, upto when initdb failed.

"
Ensuring we can write to the data directory (using cacls):
processed dir:
C:\PROGRA~1\CISCOS~1\CSCONccm\objects\PostgreSQL\8.4\data

The files belonging to this database system will be owned by
user "Administrator".
This user must also own the server process.

The database cluster will be initialized with locale
English_United States.1252.
The default text search configuration will be set to "english".

fixing permissions on existing directory
C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
creating configuration files ... ok
creating template1 database in
C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data/base/1 ...
initdb: could not execute command
""C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/bin/postgres.exe"
--boot -x1 -F ": No error
initdb: removing contents of data directory
"C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data"

"

Thank you
Pankaj

-----Original Message-----
From: Kevin Grittner [mailto:Kevin(dot)Grittner(at)wicourts(dot)gov]
Sent: Friday, April 09, 2010 7:27 AM
To: Pankaj Mandal (pmandal); pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] initdb failure

"Pankaj Mandal (pmandal)" <pmandal(at)cisco(dot)com> wrote:

> initdb: could not execute command
> ""C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/bin/
> postgres.exe" --boot -x1 -F ": No error

I would check permissions related to the user and that postgres.exe
file.

-Kevin

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Khangelani Gama 2010-04-10 05:37:25 Re: Re: database restoration problem- data became incorrect caused by incorrect date in the server
Previous Message Kevin Grittner 2010-04-09 20:57:52 Re: Handling of images via Postgressql