Re: PB: Initdb failure - Mailing list pgsql-cygwin

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)
>