BUG #2558: initDB failed to run

From: "Dror" <dror_b(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2558: initDB failed to run
Date: 2006-08-01 12:57:17
Message-ID: 200608011257.k71CvHGl012124@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message flash.xu 2006-08-01 16:44:19 BUG #2559: why jdbc-driver AbstractJdbc2ResultSetMetaData. getTableName(int column) return ""
Previous Message Tom Lane 2006-08-01 12:40:12 Re: BUG #2557: field`s default value not restored in big sql script