Troubles in Initializing Postgres Database 8.2
Hi,
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.
It seems it cannot find a file…but which one?? And is this related to the failing initialization…? Maybe there are some missing “locales” ?
I hope someone can shed some light on this problem.
Thank you in advance,
Best regards,
Maarten v.d. Heijden
The Netherlands
<Begin log>
(Note: Het systeem kan het opgegeven bestand niet vinden = Can’t find file)
The files belonging to this database system will be owned by user "PostGres".
This user must also own the server process.
The database cluster will be initialized with locale C.
fixing permissions on existing directory C:/Program Files/PostgreSQL/8.2/data ... 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 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.
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 (standaardtijd)"
ok
initializing pg_authid ... Het systeem kan het opgegeven bestand niet vinden.
child process exited with exit code 1
initdb: removing contents of data directory "C:/Program Files/PostgreSQL/8.2/data"
<End log>
--
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
______________________________________________________________________
*******************************DISCLAIMER******************************De informatie verzonden met dit e-mail bericht is uitsluitend voor de geadresseerde(n). Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking 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 aansprakelijkheid uit, die voortvloeit uit elektronische verzending.
The information contained in this communication is intended solely for use 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 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.
***********************************************************************
This email has been scanned by the MessageLabs Email Security System.
On behalf of VDG Security Systems bv
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
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
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 informatie verzonden met dit e-mail bericht is uitsluitend voor de geadresseerde(n). Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking 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 aansprakelijkheid uit, die voortvloeit uit elektronische verzending.
The information contained in this communication is intended solely for use 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 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.
***********************************************************************
This email has been scanned by the MessageLabs Email Security System.
On behalf of VDG Security Systems bv
Hi,
Still no luck initializing the Database Cluster. I'm wondering which commands/files InitDb uses...it says something is missing, I would like to know what, is there a way or does someone know which programs\commands InitDb uses?
Regards,
Maarten
-----Oorspronkelijk bericht-----
Van: Magnus Hagander [mailto:magnus@hagander.net]
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’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
--
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
--
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
______________________________________________________________________
*******************************DISCLAIMER******************************De informatie verzonden met dit e-mail bericht is uitsluitend voor de geadresseerde(n). Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking 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 aansprakelijkheid uit, die voortvloeit uit elektronische verzending.
The information contained in this communication is intended solely for use 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 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.
***********************************************************************
This email has been scanned by the MessageLabs Email Security System.
On behalf of VDG Security Systems bv
Import Notes
Resolved by subject fallback
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 is missing, 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,
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]
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 account) indeed failed with an "access denied" error message (getlasterror code 5). Not sure if this is related to "file not found" (getlasterror code 2).
-----Oorspronkelijk bericht-----
Van: Magnus Hagander [mailto:magnus@hagander.net]
Verzonden: maandag 29 januari 2007 12:32
Aan: Maarten van der Heijden
Onderwerp: Re: [BUGS] Troubles in Initializing Postgres Database 8.2On Mon, Jan 29, 2007 at 11:55:02AM +0100, Maarten van der Heijden wrote:
Hi,
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 in shmem.c. There seems to be no problem in creating/opening and accessing/reading shared memory in Xp embedded.
Using process explorer I could also see InitDb creating the shared memory segment (PostgreSQL.1).
If I understand correctly, InitDb should create a shared memory segment which Postgres can use to initialize the database cluster? And it looks like initdb fails there right?
Eh, I have to say I'm not 100% on which order these things are done. ;)
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.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)
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.//Magnus
--
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--
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-2007 13:12______________________________________________________________________
*******************************DISCLAIMER******************************De informatie verzonden met dit e-mail bericht is uitsluitend voor de geadresseerde(n). Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking 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 aansprakelijkheid uit, die voortvloeit uit elektronische verzending.
The information contained in this communication is intended solely for use 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 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.
***********************************************************************
This email has been scanned by the MessageLabs Email Security System.
On behalf of VDG Security Systems bv
--
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
--
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
______________________________________________________________________
*******************************DISCLAIMER******************************De informatie verzonden met dit e-mail bericht is uitsluitend voor de geadresseerde(n). Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking 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 aansprakelijkheid uit, die voortvloeit uit elektronische verzending.
The information contained in this communication is intended solely for use 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 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.
***********************************************************************
This email has been scanned by the MessageLabs Email Security System.
On behalf of VDG Security Systems bv
Import Notes
Resolved by subject fallback