Skip site navigation (1) Skip section navigation (2)

Re: BUG #2558: initDB failed to run

From: Jim Nasby <jnasby(at)pervasive(dot)com>
To: Dror <dror_b(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2558: initDB failed to run
Date: 2006-08-08 17:30:56
Message-ID: C7FF2888-3FA6-499D-88B0-F84B81B0FDDF@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Does V_MYUSER have access to the PGDATA directory? This might be an  
issue of it not having access to the directory you're running initdb  
from...

On Aug 1, 2006, at 12:57 PM, Dror wrote:
> The following bug has been logged online:
>
> Bug reference:      2558
> Logged by:          Dror
> Email address:      dror_b(at)hotmail(dot)com
> PostgreSQL version: 8.1.4
> Operating system:   win 2003
> Description:        initDB failed to run
> Details:
>
> On one of mine win 2003 machine ( on any other win2003 machine  
> everything
> work as expected), I failed to install postgress in service mode  
> using the
> MSI package , after short investigation i found a failure in the  
> initDB
> phase, so I install postgress without running the initDB and then  
> ran the
> initDB manually with the debug option set, (The user is not an
> Administrator).
> The strange thing is that EnterpriseDB which is based on postgres  
> works
> fine.
> The problem seems to be in the initDB.c source file in the
> test_connections(void) and test_buffers(void) functions.
> Here is the procedures and the output of the initDB.
>
> After the installation I did:
>
> - Runas /user:V_MYUSER CMD
>
> - initDB -D "E:\Postgres\Data" -d -U V_MYUSER
>
> Running in debug mode.
> The files belonging to this database system will be owned by user
> "V_MYUSER".
> This user must also own the server process.
>
> The database cluster will be initialized with locale English_United
> States.1252.
>
> fixing permissions on existing directory E:/Postgres\Data ... ok
> creating directory E:/Postgres\Data/global ... ok
> creating directory E:/Postgres\Data/pg_xlog ... ok
> creating directory E:/Postgres\Data/pg_xlog/archive_status ... ok
> creating directory E:/Postgres\Data/pg_clog ... ok
> creating directory E:/Postgres\Data/pg_subtrans ... ok
> creating directory E:/Postgres\Data/pg_twophase ... ok
> creating directory E:/Postgres\Data/pg_multixact/members ... ok
> creating directory E:/Postgres\Data/pg_multixact/offsets ... ok
> creating directory E:/Postgres\Data/base ... ok
> creating directory E:/Postgres\Data/base/1 ... ok
> creating directory E:/Postgres\Data/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 E:/Postgres\Data/base/1 ...  
> VERSION=8.1.4
> PGDATA=E:/Postgres\Data
> share_path=E:/Program Files/postgres/Database/share
> PGPATH=E:/Program Files/postgres/Database/bin
> POSTGRES_SUPERUSERNAME=V_MYUSER
> POSTGRES_BKI=E:/Program Files/postgres/Database/share/postgres.bki
> POSTGRES_DESCR=E:/Program
> Files/postgres/Database/share/postgres.description
> POSTGRESQL_CONF_SAMPLE=E:/Program
> Files/postgres/Database/share/postgresql.conf.sample
> PG_HBA_SAMPLE=E:/Program Files/postgres/Database/share/ 
> pg_hba.conf.sample
> PG_IDENT_SAMPLE=E:/Program
> Files/postgres/Database/share/pg_ident.conf.sample
> DEBUG:  TZ "Asia/Jerusalem" matches Windows timezone "Jerusalem  
> Standard
> Time"
> DEBUG:  invoking IpcMemoryCreate(size=1327104)
> LOG:  database system was shut down at 2006-08-01 14:36:37 Jerusalem
> Standard Time
> LOG:  checkpoint record is at 0/20
> LOG:  redo record is at 0/20; undo record is at 0/20; shutdown TRUE
> LOG:  next transaction ID: 3; next OID: 10000
> LOG:  next MultiXactId: 1; next MultiXactOffset: 0
> LOG:  database system is ready
> DEBUG:  StartTransaction
> DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,
> xid/subid/cid: 1/1/0, nestlvl: 1, children: <>
> DEBUG:  start transaction
> DEBUG:  creating bootstrap relation pg_proc 1255
> DEBUG:  column proname name
>
>
>
> Regards
> DROR
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



In response to

pgsql-bugs by date

Next:From: Jim NasbyDate: 2006-08-08 17:33:20
Subject: Re: [BUGS] BUG #2560: Web page documentation hard to use
Previous:From: Jim NasbyDate: 2006-08-08 17:27:51
Subject: Re: pg_restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group