Re: BUG #2558: initDB failed to run
От | Jim Nasby |
---|---|
Тема | Re: BUG #2558: initDB failed to run |
Дата | |
Msg-id | 4D27CB1096EF1C408F4BFAB0046EC7B6099FF7@ausmailid.aus.pervasive.com обсуждение исходный текст |
Ответ на | BUG #2558: initDB failed to run ("Dror" <dror_b@hotmail.com>) |
Список | 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
В списке pgsql-bugs по дате отправления: