Re: BUG #2558: initDB failed to run - Mailing list pgsql-bugs

Please cc the list so others can learn.
=20
Yes, I think a patch for this was recently committed. I know it was at leas=
t discussed somewhere...

-----Original Message-----
From: dror [mailto:dror_b@hotmail.com]
Sent: Wednesday, August 09, 2006 2:17 AM
To: Jim Nasby
Subject: RE: [BUGS] BUG #2558: initDB failed to run


Hi Jim,
I have already solved the problem, as it is mentioned before, the problem w=
as that on some windows 2003 machine there is no access to the nul device f=
or non administrators users.
The initDB.c redirect the output to > DEVNUL which on windows defined has "=
nul".
I changed the initDB source by canceling the redirection.
I think this is the easiest way.
I could also solve it by open a file , give W permission to the user to thi=
s file and redirect the output to that file.
=20
=20
I think postgres must solve this issue, as more and more windows 2003 machi=
ne will be discovered with this limitation which prevent from the users to =
install the DB.
Attached you can find the fixed initDB.c file
Regards
Dror






  _____=20=20


> CC: pgsql-bugs@postgresql.org
> From: jnasby@pervasive.com
> Subject: Re: [BUGS] BUG #2558: initDB failed to run
> Date: Tue, 8 Aug 2006 12:30:56 -0500
> To: dror_b@hotmail.com
>=20
> Does V_MYUSER have access to the PGDATA directory? This might be an=20=20
> issue of it not having access to the directory you're running initdb=20=
=20
> from...
>=20
> 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=20=20
> > everything
> > work as expected), I failed to install postgress in service mode=20=20
> > using the
> > MSI package , after short investigation i found a failure in the=20=20
> > initDB
> > phase, so I install postgress without running the initDB and then=20=20
> > 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=20=20
> > 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 ...=20=20
> > VERSION=3D8.1.4
> > PGDATA=3DE:/Postgres\Data
> > share_path=3DE:/Program Files/postgres/Database/share
> > PGPATH=3DE:/Program Files/postgres/Database/bin
> > POSTGRES_SUPERUSERNAME=3DV_MYUSER
> > POSTGRES_BKI=3DE:/Program Files/postgres/Database/share/postgres.bki
> > POSTGRES_DESCR=3DE:/Program
> > Files/postgres/Database/share/postgres.description
> > POSTGRESQL_CONF_SAMPLE=3DE:/Program
> > Files/postgres/Database/share/postgresql.conf.sample
> > PG_HBA_SAMPLE=3DE:/Program Files/postgres/Database/share/=20
> > pg_hba.conf.sample
> > PG_IDENT_SAMPLE=3DE:/Program
> > Files/postgres/Database/share/pg_ident.conf.sample
> > DEBUG:  TZ "Asia/Jerusalem" matches Windows timezone "Jerusalem=20=20
> > Standard
> > Time"
> > DEBUG:  invoking IpcMemoryCreate(size=3D1327104)
> > 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=20=20
> > broadcast)---------------------------
> > TIP 4: Have you searched our list archives?
> >
> >                http://archives.postgresql.org
> >
>=20
> --
> 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
>=20
>=20



  _____=20=20

Express yourself instantly with Windows Live Messenger! Windows Live Messen=
ger! <http://imagine-msn.com/messenger/launch80/default.aspx?locale=3Den-us=
&source=3Djoinmsncom/messenger>=20=20