Re: [BUGS] BUG #2268: initdb fails to initialize database cluster with

#1

Strange. It isn't a typical error we see, and the fact you see it on
two machines is even stranger. My guess is that somehow the
configuration on those two machines is the same and is causing the
failure.

---------------------------------------------------------------------------

James Hughes wrote:

Quote:

The following bug has been logged online:

Bug reference: 2268
Logged by: James Hughes
Email address: james_hughes (AT) mcafee (DOT) com
PostgreSQL version: 8.1.3
Operating system: Windows 2003 (Server)
Description: initdb fails to initialize database cluster with error
"Access is denied"
Details:

When we try and initialize a database cluster using initdb.exe we are
getting the following output.

-- OUTPUT from dbinit.exe --
The files belonging to this database system will be owned by user "user1".
This user must also own the server process.

The database cluster will be initialized with locale English_United
Kingdom.1252.

creating directory c:/dataa ... ok
creating directory c:/dataa/global ... ok
creating directory c:/dataa/pg_xlog ... ok
creating directory c:/dataa/pg_xlog/archive_status ... ok
creating directory c:/dataa/pg_clog ... ok
creating directory c:/dataa/pg_subtrans ... ok
creating directory c:/dataa/pg_twophase ... ok
creating directory c:/dataa/pg_multixact/members ... ok
creating directory c:/dataa/pg_multixact/offsets ... ok
creating directory c:/dataa/base ... ok
creating directory c:/dataa/base/1 ... ok
creating directory c:/dataa/pg_tblspc ... ok
selecting default max_connections ... Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
10
selecting default shared_buffers ... Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
Access is denied.
50
creating configuration files ... ok
creating template1 database in c:/dataa/base/1 ... ok
initializing pg_authid ... Access is denied.
child process was terminated by signal 1
initdb: removing data directory "c:/dataa"

-- end: OUTPUT from dbinit.exe --

user1 is a user without administrative rights. I have checked all the
directories and the user has permissons to write to the data directory, and
read other files it requires.

I also tried the Windows installer (MSI) from pgFoundry. This too is having
the same problem.

We have two machines which this problem occurs on, one of which originally
the initialization would work on. I have checked all the user rights
asssignments, and even given the postgres user (user1 in the above output
from dbinit.exe) all user rights.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #2268: initdb fails to initialize database cluster with

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #2268: initdb fails to initialize database cluster with - 02-24-2006 , 12:55 PM