Re: BUG #2558: initDB failed to run

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@hotmail.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@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461