Обсуждение: 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)
>

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 ( 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 failure

ipc-daemon2.exe
--install-as-service

net 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.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 ( at ) postgresql ( dot ) org)

• Follow-Ups:
  • Re: PB: Initdb failure
    • From: jean-philippe jacoupy

• 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):
  • Main
  • Thread

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.