Thread: PB: Initdb failure
Hi, when I'm trying to init my database (with initdb), it says me: <shell> creating template1 database in /usr/share/postgresql/data//base/1... FATAL: semctl(17, 16, SETVAL,536) failed: Invalid argument initdb: failed </shell> I've this system configuration: Windows XP Pro service Pack 1 Cygwin Package Information Package Version Status cygipc 2.02-1 OK cygwin 1.5.6-1 OK and postgresql 7.4.1 can someone explain me what I've to do to fix this ? Les noms de domaine les moins chers du march� : 6,49 euros HT sur http://www.lycos.fr/pro .
ipc-daemon2.exe --install-as-service net start "cygwin ipc daemon 2" try again regards, --Tim -----Original Message----- From: pgsql-cygwin-owner@postgresql.org [mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of jean-philippe jacoupy Sent: donderdag 22 januari 2004 10:27 To: pgsql-cygwin@postgresql.org Subject: [CYGWIN] PB: Initdb failure Hi, when I'm trying to init my database (with initdb), it says me: <shell> creating template1 database in /usr/share/postgresql/data//base/1... FATAL: semctl(17, 16, SETVAL,536) failed: Invalid argument initdb: failed </shell> I've this system configuration: Windows XP Pro service Pack 1 Cygwin Package Information Package Version Status cygipc 2.02-1 OK cygwin 1.5.6-1 OK and postgresql 7.4.1 can someone explain me what I've to do to fix this ? Les noms de domaine les moins chers du marché : 6,49 euros HT sur http://www.lycos.fr/pro . ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
My ipc-daemon2 already worked as a service I have followed this guide to install postgresql with cygwin: http://www.tishler.net/jason/software/postgresql/postgresql-7.4.1.README And try everything there is in it ... cray@lavieenrose ~ net start | grep IPC Cygwin IPC Daemon 2 ------- Message d'origine ------- De: Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com> Date: Thu, 22 Jan 2004 09:05:55 -0600 Sujet: Re: [CYGWIN] PB: Initdb failure ipc-daemon2.exe --install-as-service net start "cygwin ipc daemon 2" try again regards, --Tim -----Original Message----- From: pgsql-cygwin-owner@postgresql.org [mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of jean-philippe jacoupy Sent: donderdag 22 januari 2004 10:27 To: pgsql-cygwin@postgresql.org Subject: [CYGWIN] PB: Initdb failure Hi, when I'm trying to init my database (with initdb), it says me: creating template1 database in /usr/share/postgresql/data//base/1... FATAL: semctl(17, 16, SETVAL,536) failed: Invalid argument initdb: failed I've this system configuration: Windows XP Pro service Pack 1 Cygwin Package Information Package Version Status cygipc 2.02-1 OK cygwin 1.5.6-1 OK and postgresql 7.4.1 can someone explain me what I've to do to fix this ? Les noms de domaine les moins chers du march� : 6,49 euros HT sur http://www.lycos.fr/pro ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend -- GEEK CODE Version: 3.1 GCSd+s+:+a--C++(++++)UBCSP+>+++L-E-W++N-o?K?wOM+V-PS+PE+Y+PGP+t+5?X+R++tvb++DID+Ge++hr++ ? E-mail, Dialogue en direct et SMS gratuits sur minitel : 3615 CARAMAIL
Hey jean-phillipe!
Actually, it looks like the issue might be much simpler than you
realize. First, is the output you're getting a cut/paste? If so, don't
put an ending forward slash in the command to create the database.
Follow the instructions to the letter:
$ initdb -D /var/postgresql/data
NO ENDING SLASH.
Second, you obviously are NOT following the instructions as written in
the URL you provided, as the path you show is to the older
/usr/share/postgresql/data, NOT the new /var/postgresql/data (which is
clearly stated in step #2).
If this was not the issue, try shutting down CygIPC, deleting all of its
related files in /tmp, then fire it back up and try again.
From the path you've used and issues you're seeing, I was curious.
Have you installed/used PostgreSQL under Cygwin in the past? If so, be
sure to re-read the installation steps, as with CygIPC becoming a proper
Cygwin package, and PostgreSQL moving up to v7.4, there have been some
basic changes in the way the install/setup are done. Minor, but can
throw you if you're used to the older way.
Hope this helps.
jean-philippe jacoupy wrote:
> My ipc-daemon2
> already worked as a
> service
>
> I have followed this
> guide to install
> postgresql with
> cygwin:
>
> http://www.tishler.net/jason/software/postgresql/postgresql-7.4.1.README
>
> And try everything
> there is in it ...
>
> cray@lavieenrose ~
> net start | grep IPC
> Cygwin IPC Daemon
> 2
>
>
> ------- Message
> d'origine -------
> De: Leeuw van der,
> Tim
> <tim.leeuwvander@nl.unisys.com>
> Date: Thu, 22 Jan
> 2004 09:05:55 -0600
> Sujet: Re: [CYGWIN]
> PB: Initdb failure
>
> ipc-daemon2.exe
> --install-as-service
>
> net start "cygwin
> ipc daemon 2"
>
> try again
>
> regards,
>
> --Tim
>
> -----Original
> Message-----
> From:
> pgsql-cygwin-owner@postgresql.org
> [mailto:pgsql-cygwin-owner@postgresql.org]On
> Behalf Of
> jean-philippe
> jacoupy
> Sent: donderdag 22
> januari 2004 10:27
> To:
> pgsql-cygwin@postgresql.org
> Subject: [CYGWIN]
> PB: Initdb failure
>
>
> Hi,
>
> when I'm trying to
> init my database
> (with initdb), it
> says me:
>
>
> creating template1
> database in
> /usr/share/postgresql/data//base/1...
> FATAL: semctl(17,
> 16,
> SETVAL,536) failed:
> Invalid argument
>
> initdb: failed
>
>
> I've this system
> configuration:
> Windows XP Pro
> service Pack 1
>
> Cygwin Package
> Information
> Package
> Version
> Status
> cygipc
> 2.02-1 OK
> cygwin
> 1.5.6-1 OK
>
> and postgresql 7.4.1
>
> can someone explain
> me what I've to do
> to fix this ?
>
> Les noms de domaine
> les moins chers du
> marché : 6,49 euros
> HT sur
> http://www.lycos.fr/pro
>
>
>
> ---------------------------(end
> of
> broadcast)---------------------------
> TIP 4: Don't 'kill
> -9' the postmaster
>
> ---------------------------(end
> of
> broadcast)---------------------------
> TIP 8: explain
> analyze is your
> friend
>
> --
> GEEK CODE
> Version: 3.1
> GCSd+s+:+a--C++(++++)UBCSP+>+++L-E-W++N-o?K?wOM+V-PS+PE+Y+PGP+t+5?X+R++tvb++DID+Ge++hr++ ?
>
>
> E-mail, Dialogue en direct et SMS gratuits sur minitel : 3615 CARAMAIL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
Hi:
I am experiencing the same problem with initdb
(i.e. semctl(35, 16, SETVAL, 536) failed: Invalid argument)
and have tried the recommended solutions to no avail sofar.
My system info is:
Windows XP Professional, SP1
Cygwin 1.5.7-1
net start "cygwin ipc daemon 2" starts the service with no errors, and I tried cleaning up
the related files in /tmp and restarting as suggested.
Can anyone explain what the problem is, i.e. which argument is invalid and why?
Oh, and what I need to do to fix it would also be appreciated, thanks!
Greg B. Hill
jean-philippe jacoupy wrote:
I am experiencing the same problem with initdb
(i.e. semctl(35, 16, SETVAL, 536) failed: Invalid argument)
and have tried the recommended solutions to no avail sofar.
My system info is:
Windows XP Professional, SP1
Cygwin 1.5.7-1
net start "cygwin ipc daemon 2" starts the service with no errors, and I tried cleaning up
the related files in /tmp and restarting as suggested.
Can anyone explain what the problem is, i.e. which argument is invalid and why?
Oh, and what I need to do to fix it would also be appreciated, thanks!
Greg B. Hill
jean-philippe jacoupy wrote:
My ipc-daemon2 already worked as a serviceI have followed this guide to install postgresql with cygwin:
http://www.tishler.net/jason/software/postgresql/postgresql-7.4.1.READMEAnd try everything there is in it ...cray ( at ) lavieenrose ~ net start | grep IPC Cygwin IPC Daemon 2
------- Message
d'origine ------- De: Leeuw van der,
Tim <tim ( dot ) leeuwvander ( at ) nl ( dot ) unisys ( dot ) com> Date: Thu, 22 Jan
2004 09:05:55 -0600 Sujet: Re: [CYGWIN]
PB: Initdb failureipc-daemon2.exe --install-as-servicenet start "cygwin ipc daemon 2"
try again
regards,
--Tim
-----Original
Message-----
From:
pgsql-cygwin-owner ( at ) postgresql ( dot ) org
[mailto:pgsql-cygwin-owner ( at ) postgresql ( dot ) org]On
Behalf Of
jean-philippe
jacoupy Sent: donderdag 22
januari 2004 10:27
To:
pgsql-cygwin ( at ) postgresql ( dot ) org
Subject: [CYGWIN]
PB: Initdb failure
Hi,when I'm trying to init my database (with initdb), it says me:
creating template1
database in
/usr/share/postgresql/data//base/1...
FATAL: semctl(17,
16, SETVAL,536) failed:
Invalid argument
initdb: failed
I've this system
configuration: Windows XP Pro
service Pack 1
Cygwin Package
Information
Package Version Status
cygipc 2.02-1 OK
cygwin 1.5.6-1 OK
and postgresql 7.4.1can someone explain me what I've to do to fix this ?
Les noms de domaine
les moins chers du
marché : 6,49 euros
HT sur
http://www.lycos.fr/pro---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend-- GEEK CODE Version: 3.1 GCSd+s+:+a--C++(++++)UBCSP+>+++L-E-W++N-o?K?wOM+V-PS+PE+Y+PGP+t+5?X+R++tvb++DID+Ge++hr++ ?
E-mail, Dialogue en direct et SMS gratuits sur minitel : 3615 CARAMAIL---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo ( at ) postgresql ( dot ) org)
- Follow-Ups:
- Re: PB: Initdb failure
- From: jean-philippe jacoupy
- Re: PB: Initdb failure
- Prev by Date: ipc-daemon2 not working!!!!
- Next by Date: Re: ipc-daemon2
- Previous by thread: Re: PB: Initdb failure
- Next by thread: initdb -> not found cygcrypt-0.dll
- Index(es):
I just want to say that both myself and my coworker are seeing this same error: FATAL: semctl(17, 16, SETVAL,536) failed: Invalid argument We are following the Tishler readme, and I've gotten it to work with 7.4.1 (and still can--it's only 7.4.2 that gives me this failure; though my coworker still gets this error after downgrading to 7.4.1), and we are NOT adding a trailing slash to the data dir para to initdb. My coworker is using /var/postgresql/data --I'm follow the instruction with a modification to /user/local/pgsql/data (which I get to work in 7.4.1--I really don't think it matters). We're using the latest cygipc available through the cygwin setup, though my coworker has tried reverting to the previous version--again, no dice. Does anyone have any idea what the interaction could be here where a call to semctl should fail with a bad argument? Any help would be appreciated... Eric Schwarzenbach > Hey jean-phillipe! > > Actually, it looks like the issue might be much simpler than you > realize. First, is the output you're getting a cut/paste? If so, don't > put an ending forward slash in the command to create the database. > Follow the instructions to the letter: > > $ initdb -D /var/postgresql/data > > NO ENDING SLASH. > > Second, you obviously are NOT following the instructions as written in > the URL you provided, as the path you show is to the older > /usr/share/postgresql/data, NOT the new /var/postgresql/data (which is > clearly stated in step #2). > > If this was not the issue, try shutting down CygIPC, deleting all of > its related files in /tmp, then fire it back up and try again. > > From the path you've used and issues you're seeing, I was curious. > Have you installed/used PostgreSQL under Cygwin in the past? If so, be > sure to re-read the installation steps, as with CygIPC becoming a > proper Cygwin package, and PostgreSQL moving up to v7.4, there have > been some basic changes in the way the install/setup are done. Minor, > but can throw you if you're used to the older way. > > Hope this helps.