Обсуждение: Troubles in Initializing Postgres Database 8.2
Hi, =20 I=92m having trouble initialzing the PostGres Database 8.2 on Windows Xp Em= bedded. Installation using the windows installer is going fine until the in= itialization process is started. See below for the log. Installing postgres= without initializing the database cluster is also working fine. =20 It seems it cannot find a file=85but which one?? And is this related to the= failing initialization=85? Maybe there are some missing =93locales=94 ? =20 I hope someone can shed some light on this problem. =20 Thank you in advance, =20 Best regards, Maarten v.d. Heijden The Netherlands =20 =20 <Begin log> (Note: Het systeem kan het opgegeven bestand niet vinden =3D Can=92t find f= ile) =20 The files belonging to this database system will be owned by user "PostGres= ". This user must also own the server process. =20 The database cluster will be initialized with locale C. =20 fixing permissions on existing directory C:/Program Files/PostgreSQL/8.2/da= ta ... ok creating subdirectories ... ok selecting default max_connections ... Het systeem kan het opgegeven bestand= niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. 10 selecting default shared_buffers/max_fsm_pages ... Het systeem kan het opge= geven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. Het systeem kan het opgegeven bestand niet vinden. 400kB/20000 creating configuration files ... ok creating template1 database in C:/Program Files/PostgreSQL/8.2/data/base/1 = ... WARNING: could not find a match for Windows timezone "West-Europa (sta= ndaardtijd)" ok initializing pg_authid ... Het systeem kan het opgegeven bestand niet vinde= n. child process exited with exit code 1 initdb: removing contents of data directory "C:/Program Files/PostgreSQL/8.= 2/data" =20 <End log> =20 --=20 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.16.13/632 - Release Date: 16-1-2007 = 16:36 =20 ______________________________________________________________________ *******************************DISCLAIMER******************************De i= nformatie verzonden met dit e-mail bericht is uitsluitend voor de geadresse= erde(n). Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekkin= g aan derden is niet toegestaan. Indien U deze e-mail abusievelijk heeft on= tvangen, verzoeken wij U het e-mail bericht te verwijderen en de afzender h= iervan op de hoogte te stellen. VDG Security Systems bv sluit iedere aanspr= akelijkheid uit, die voortvloeit uit elektronische verzending.=20 The information contained in this communication is intended solely for use = of the individual or entity to whom it is addressed and others authorized t= o receive it. If you are not the intended recipient you are hereby notified= that any disclosure, copying,distribution or taking any action in reliance= on the contents of this information is strictly prohibited. If you are not= the intended recipient, please delete this message and any attachments and= advise the sender by return e-mail. VDG Security Systems bv rules out any = and every liability resulting from any electronic transmission.=20 *********************************************************************** This email has been scanned by the MessageLabs Email Security System. On behalf of VDG Security Systems bv=
Maarten van der Heijden wrote: > Im having trouble initialzing the PostGres Database 8.2 on Windows Xp > Embedded. Installation using the windows installer is going fine until > the initialization process is started. See below for the log. Installing > postgres without initializing the database cluster is also working fine. Not sure anybody has ever managed to install/run pg on XP Embedded. Does it work if you run initdb manually after the install, or do you get the same problem? > It seems it cannot find a file but which one?? And is this related to > the failing initialization ? Maybe there are some missing locales ? Hmm. That one looks like it's coming from the shared memory stuff. We do a mapping of the pagefile for that - any chance your XP embedded system simple does not have a pagefile or something? That would make it reasonable to return file not found for that I guess. //Magnus
Thanks for your answer. Manually starting InitDb causes the same error. I'll try starting InitDb with the pagefile enabled, let's see what happens. regards, maarten -----Oorspronkelijk bericht----- Van: Magnus Hagander [mailto:magnus@hagander.net] Verzonden: zo 21-1-2007 18:23 Aan: Maarten van der Heijden CC: pgsql-bugs@postgresql.org Onderwerp: Re: [BUGS] Troubles in Initializing Postgres Database 8.2 =20 Maarten van der Heijden wrote: > I'm having trouble initialzing the PostGres Database 8.2 on Windows Xp > Embedded. Installation using the windows installer is going fine until > the initialization process is started. See below for the log. Installing > postgres without initializing the database cluster is also working fine. Not sure anybody has ever managed to install/run pg on XP Embedded. Does it work if you run initdb manually after the install, or do you get the same problem? > It seems it cannot find a file.but which one?? And is this related to > the failing initialization.? Maybe there are some missing "locales" ? Hmm. That one looks like it's coming from the shared memory stuff. We do a mapping of the pagefile for that - any chance your XP embedded system simple does not have a pagefile or something? That would make it reasonable to return file not found for that I guess. //Magnus ______________________________________________________________________ *******************************DISCLAIMER******************************De i= nformatie verzonden met dit e-mail bericht is uitsluitend voor de geadresse= erde(n). Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekkin= g aan derden is niet toegestaan. Indien U deze e-mail abusievelijk heeft on= tvangen, verzoeken wij U het e-mail bericht te verwijderen en de afzender h= iervan op de hoogte te stellen. VDG Security Systems bv sluit iedere aanspr= akelijkheid uit, die voortvloeit uit elektronische verzending.=20 The information contained in this communication is intended solely for use = of the individual or entity to whom it is addressed and others authorized t= o receive it. If you are not the intended recipient you are hereby notified= that any disclosure, copying,distribution or taking any action in reliance= on the contents of this information is strictly prohibited. If you are not= the intended recipient, please delete this message and any attachments and= advise the sender by return e-mail. VDG Security Systems bv rules out any = and every liability resulting from any electronic transmission.=20 *********************************************************************** This email has been scanned by the MessageLabs Email Security System. On behalf of VDG Security Systems bv=
On Thu, Jan 25, 2007 at 12:15:59PM +0100, Maarten van der Heijden wrote: > Hi, > > Still no luck initializing the Database Cluster. I'm wondering which commands/files InitDb uses...it says something ismissing, I would like to know what, is there a way or does someone know which programs\commands InitDb uses? I *think* what is missing is the shared memory. Though I'm not sure. In this case, initdb calls postgres.exe and that's where the error comes from, from what I can tell. (Note that it does *not* say that it's a file that's missing) Did some googling, and it looks like at least Windows CE does not have support for the kind of shared memory that we do. Don't know about XP Embedded. //Magnus
Hi, Still no luck initializing the Database Cluster. I'm wondering which comman= ds/files InitDb uses...it says something is missing, I would like to know w= hat, is there a way or does someone know which programs\commands InitDb use= s? Regards, Maarten -----Oorspronkelijk bericht----- Van: Magnus Hagander [mailto:magnus@hagander.net]=20 Verzonden: zondag 21 januari 2007 18:24 Aan: Maarten van der Heijden CC: pgsql-bugs@postgresql.org Onderwerp: Re: [BUGS] Troubles in Initializing Postgres Database 8.2 Maarten van der Heijden wrote: > I=92m having trouble initialzing the PostGres Database 8.2 on Windows Xp > Embedded. Installation using the windows installer is going fine until > the initialization process is started. See below for the log. Installing > postgres without initializing the database cluster is also working fine. Not sure anybody has ever managed to install/run pg on XP Embedded. Does it work if you run initdb manually after the install, or do you get the same problem? > It seems it cannot find a file=85but which one?? And is this related to > the failing initialization=85? Maybe there are some missing =93locales=94= ? Hmm. That one looks like it's coming from the shared memory stuff. We do a mapping of the pagefile for that - any chance your XP embedded system simple does not have a pagefile or something? That would make it reasonable to return file not found for that I guess. //Magnus --=20 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.10/651 - Release Date: 24-1-2007 = 18:48 =20 --=20 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.10/651 - Release Date: 24-1-2007 = 18:48 =20 ______________________________________________________________________ *******************************DISCLAIMER******************************De i= nformatie verzonden met dit e-mail bericht is uitsluitend voor de geadresse= erde(n). Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekkin= g aan derden is niet toegestaan. Indien U deze e-mail abusievelijk heeft on= tvangen, verzoeken wij U het e-mail bericht te verwijderen en de afzender h= iervan op de hoogte te stellen. VDG Security Systems bv sluit iedere aanspr= akelijkheid uit, die voortvloeit uit elektronische verzending.=20 The information contained in this communication is intended solely for use = of the individual or entity to whom it is addressed and others authorized t= o receive it. If you are not the intended recipient you are hereby notified= that any disclosure, copying,distribution or taking any action in reliance= on the contents of this information is strictly prohibited. If you are not= the intended recipient, please delete this message and any attachments and= advise the sender by return e-mail. VDG Security Systems bv rules out any = and every liability resulting from any electronic transmission.=20 *********************************************************************** This email has been scanned by the MessageLabs Email Security System. On behalf of VDG Security Systems bv
Hi, Good news! We've succesfully installed Postgres on Windows Embedded. The trick was to include a Null Device Driver to the image. Thanks for your help! Regards, Maarten -----Oorspronkelijk bericht----- Van: Magnus Hagander [mailto:magnus@hagander.net]=20 Verzonden: maandag 29 januari 2007 13:00 Aan: Maarten van der Heijden Onderwerp: Re: [BUGS] Troubles in Initializing Postgres Database 8.2 It shouldn't be, but it has been my experience that windows can give the weirdest errorcodes sometimes :D On Mon, Jan 29, 2007 at 12:47:44PM +0100, Maarten van der Heijden wrote: > Using my test program with different user accounts (admin and lower accou= nt) indeed failed with an "access denied" error message (getlasterror code = 5). Not sure if this is related to "file not found" (getlasterror code 2). >=20 >=20 > -----Oorspronkelijk bericht----- > Van: Magnus Hagander [mailto:magnus@hagander.net]=20 > Verzonden: maandag 29 januari 2007 12:32 > Aan: Maarten van der Heijden > Onderwerp: Re: [BUGS] Troubles in Initializing Postgres Database 8.2 >=20 > On Mon, Jan 29, 2007 at 11:55:02AM +0100, Maarten van der Heijden wrote: > > Hi, > >=20 > > After reviewing the shmem.c code I constructed a test program to see if= Xp embedded supports shared memory. I've used the same functions as used i= n shmem.c. There seems to be no problem in creating/opening and accessing/r= eading shared memory in Xp embedded.=20 > >=20 > > Using process explorer I could also see InitDb creating the shared memo= ry segment (PostgreSQL.1).=20 > >=20 > > If I understand correctly, InitDb should create a shared memory segment= which Postgres can use to initialize the database cluster? And it looks li= ke initdb fails there right? >=20 > Eh, I have to say I'm not 100% on which order these things are done. ;) >=20 > But - inteesting to notice that it worked when you ran it. Question: Did > you use the same permissions/account? Remember that if you used an admin > account, you did not use the same one, because initdb will re-exec > itself with lower permissions. So be sure to try it with a non-admin > service account. It could be permissions related. >=20 >=20 > > Is there a way to have more debug output from the process? (initdb with= debug option doesn't have enough debug info regarding the error) >=20 > I think you may need to locate the line that emits it in the source and > add more info around there yourself :-( this is definitly not something > we've seen before. >=20 > //Magnus >=20 > --=20 > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.17.12/655 - Release Date: 28-1-200= 7 13:12 >=20=20 >=20 > --=20 > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.17.12/655 - Release Date: 28-1-200= 7 13:12 >=20=20 >=20 > ______________________________________________________________________ > *******************************DISCLAIMER******************************De= informatie verzonden met dit e-mail bericht is uitsluitend voor de geadres= seerde(n). Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekk= ing aan derden is niet toegestaan. Indien U deze e-mail abusievelijk heeft = ontvangen, verzoeken wij U het e-mail bericht te verwijderen en de afzender= hiervan op de hoogte te stellen. VDG Security Systems bv sluit iedere aans= prakelijkheid uit, die voortvloeit uit elektronische verzending.=20 > The information contained in this communication is intended solely for us= e of the individual or entity to whom it is addressed and others authorized= to receive it. If you are not the intended recipient you are hereby notifi= ed that any disclosure, copying,distribution or taking any action in relian= ce on the contents of this information is strictly prohibited. If you are n= ot the intended recipient, please delete this message and any attachments a= nd advise the sender by return e-mail. VDG Security Systems bv rules out an= y and every liability resulting from any electronic transmission.=20 > *********************************************************************** > This email has been scanned by the MessageLabs Email Security System. > On behalf of VDG Security Systems bv --=20 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.12/655 - Release Date: 28-1-2007 = 13:12 =20 --=20 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.17/661 - Release Date: 30-1-2007 = 23:30 =20 ______________________________________________________________________ *******************************DISCLAIMER******************************De i= nformatie verzonden met dit e-mail bericht is uitsluitend voor de geadresse= erde(n). Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekkin= g aan derden is niet toegestaan. Indien U deze e-mail abusievelijk heeft on= tvangen, verzoeken wij U het e-mail bericht te verwijderen en de afzender h= iervan op de hoogte te stellen. VDG Security Systems bv sluit iedere aanspr= akelijkheid uit, die voortvloeit uit elektronische verzending.=20 The information contained in this communication is intended solely for use = of the individual or entity to whom it is addressed and others authorized t= o receive it. If you are not the intended recipient you are hereby notified= that any disclosure, copying,distribution or taking any action in reliance= on the contents of this information is strictly prohibited. If you are not= the intended recipient, please delete this message and any attachments and= advise the sender by return e-mail. VDG Security Systems bv rules out any = and every liability resulting from any electronic transmission.=20 *********************************************************************** This email has been scanned by the MessageLabs Email Security System. On behalf of VDG Security Systems bv