Postgres Pro
Downloads
Home   >   mailing lists

Thread: unable to initdb under cygwin

unable to initdb under cygwin

From
nasr.laili@tin.it
Date:
Hi all!
I'm having the same kind of trouble I read about a few posts in this
list, i.e. :... FATAL:  shmat(id=3538944) failed: Invalid argument
with all that follows.
I cygchecked the system and got only one error (see below), which I
don't deem responsible for that. I tried cygrunsrv with worst results.
Started both cygserver and ipc-daemon2 with more or less the same error.
Here follows some information which might help the more knoledgeable
among you to understand better what is going on:

Cygwin Configuration Diagnostics
Current System Time: Mon Jul 12 01:16:38 2004

Windows 98 SE Ver 4.10 Build 2222

Path:    C:\cygwin\usr\local\bin
    C:\cygwin\bin
    C:\cygwin\bin
    C:\cygwin\usr\X11R6\bin
    c:\WINDOWS
    c:\WINDOWS\COMMAND
    C:\cygwin\bin
    C:\cygwin\usr\sbin
    C:\cygwin\bin
    C:\cygwin\sbin

Output from C:\cygwin\bin\id.exe (nontsec)
UID: 500(admin) GID: 544(all)
544(all)

Output from C:\cygwin\bin\id.exe (ntsec)
UID: 500(admin) GID: 544(all)
544(all)

SysDir: C:\WINDOWS\SYSTEM
WinDir: C:\WINDOWS

CYGWIN = `server'
HOME = `C:\cygwin\home\admin'
LD_LIBRARY_PATH = `C:\cygwin\lib\postgresql\:\lib\postgresql'
MAKE_MODE = `unix'
PWD = `/home/admin'
USER = `admin'
[ ... ]
Found: C:\cygwin\bin\awk.exe
[ ... ]
Not Found: cpp (good!)
Not Found: gcc
Not Found: gdb
Not Found: ld
Not Found: make
[ ... ]
  330k 2004/02/09 C:\cygwin\bin\cyghttpd.dll
[ ... ]

cygcheck: dump_sysinfo: GetVolumeInformation() failed: 5
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
# This is the 'ps' result, after starting cygserver:

      PID    PPID    PGID     WINPID  TTY  UID    STIME COMMAND
   353937       1  353937 4294613359  con  500 00:47:34 /usr/bin/BASH
   349821  353937  349821 4294615323  con  500 00:54:22 /USR/SBIN/CYGSERVER
   282789  353937  282789 4291042255  con  500 01:06:35 /usr/bin/PS

# and the output of 'initdb -D $PGDATA -W -E LATIN1:

The files belonging to this database system will be owned by user "admin".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/share/postgresql/data... ok
creating directory /usr/share/postgresql/data/base... ok
creating directory /usr/share/postgresql/data/global... ok
creating directory /usr/share/postgresql/data/pg_xlog... ok
creating directory /usr/share/postgresql/data/pg_clog... ok
selecting default max_connections... 10
selecting default shared_buffers... 50
creating configuration files... ok
creating template1 database in /usr/share/postgresql/data/base/1... FATAL:  shmat(id=3538944) failed: Invalid argument

initdb: failed
initdb: removing data directory "/usr/share/postgresql/data"

# And again ...
[ ... cut ... ]
creating template1 database in /usr/share/postgresql/data/base/1... FATAL:  shmat(id=1179648) failed: Invalid argument

initdb: failed
initdb: removing data directory "/usr/share/postgresql/data"

-------------
Thank you for tour attention,
    Ennio


--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.     \\?//
 Fa' qualche cosa di cui non sei capace!"   (diceva Henry Miller) ]     (°|°)
[Why to use Win$ozz (I say) if ... "even a fool can do that.             )=(
 Do something you aren't good at!" (used to say Henry Miller) ]

Re: unable to initdb under cygwin

From
mike g
Date:
I still have not been able to overcome this problem(haven't spent much
time on it either to be truthful) but according to the new readmes it
might be helpful to change a value in cygserver.conf file.

I get that error while trying to start up postgres when I compile from
source code on XP.  Using the postgresql binaries from cygwin don't give
me that error.

So if you tried to compile on your own try the pre-compiled packages.

Mike
On Sun, 2004-07-11 at 19:16, nasr.laili@tin.it wrote:
> Hi all!
> I'm having the same kind of trouble I read about a few posts in this
> list, i.e. :... FATAL:  shmat(id=3538944) failed: Invalid argument
> with all that follows.
> I cygchecked the system and got only one error (see below), which I
> don't deem responsible for that. I tried cygrunsrv with worst results.
> Started both cygserver and ipc-daemon2 with more or less the same error.
> Here follows some information which might help the more knoledgeable
> among you to understand better what is going on:
>
> Cygwin Configuration Diagnostics
> Current System Time: Mon Jul 12 01:16:38 2004
>
> Windows 98 SE Ver 4.10 Build 2222
>
> Path:    C:\cygwin\usr\local\bin
>     C:\cygwin\bin
>     C:\cygwin\bin
>     C:\cygwin\usr\X11R6\bin
>     c:\WINDOWS
>     c:\WINDOWS\COMMAND
>     C:\cygwin\bin
>     C:\cygwin\usr\sbin
>     C:\cygwin\bin
>     C:\cygwin\sbin
>
> Output from C:\cygwin\bin\id.exe (nontsec)
> UID: 500(admin) GID: 544(all)
> 544(all)
>
> Output from C:\cygwin\bin\id.exe (ntsec)
> UID: 500(admin) GID: 544(all)
> 544(all)
>
> SysDir: C:\WINDOWS\SYSTEM
> WinDir: C:\WINDOWS
>
> CYGWIN = `server'
> HOME = `C:\cygwin\home\admin'
> LD_LIBRARY_PATH = `C:\cygwin\lib\postgresql\:\lib\postgresql'
> MAKE_MODE = `unix'
> PWD = `/home/admin'
> USER = `admin'
> [ ... ]
> Found: C:\cygwin\bin\awk.exe
> [ ... ]
> Not Found: cpp (good!)
> Not Found: gcc
> Not Found: gdb
> Not Found: ld
> Not Found: make
> [ ... ]
>   330k 2004/02/09 C:\cygwin\bin\cyghttpd.dll
> [ ... ]
>
> cygcheck: dump_sysinfo: GetVolumeInformation() failed: 5
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> # This is the 'ps' result, after starting cygserver:
>
>       PID    PPID    PGID     WINPID  TTY  UID    STIME COMMAND
>    353937       1  353937 4294613359  con  500 00:47:34 /usr/bin/BASH
>    349821  353937  349821 4294615323  con  500 00:54:22 /USR/SBIN/CYGSERVER
>    282789  353937  282789 4291042255  con  500 01:06:35 /usr/bin/PS
>
> # and the output of 'initdb -D $PGDATA -W -E LATIN1:
>
> The files belonging to this database system will be owned by user "admin".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> creating directory /usr/share/postgresql/data... ok
> creating directory /usr/share/postgresql/data/base... ok
> creating directory /usr/share/postgresql/data/global... ok
> creating directory /usr/share/postgresql/data/pg_xlog... ok
> creating directory /usr/share/postgresql/data/pg_clog... ok
> selecting default max_connections... 10
> selecting default shared_buffers... 50
> creating configuration files... ok
> creating template1 database in /usr/share/postgresql/data/base/1... FATAL:  shmat(id=3538944) failed: Invalid
argument
>
> initdb: failed
> initdb: removing data directory "/usr/share/postgresql/data"
>
> # And again ...
> [ ... cut ... ]
> creating template1 database in /usr/share/postgresql/data/base/1... FATAL:  shmat(id=1179648) failed: Invalid
argument
>
> initdb: failed
> initdb: removing data directory "/usr/share/postgresql/data"
>
> -------------
> Thank you for tour attention,
>     Ennio
>
>
> --
> [Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.     \\?//
>  Fa' qualche cosa di cui non sei capace!"   (diceva Henry Miller) ]     (°|°)
> [Why to use Win$ozz (I say) if ... "even a fool can do that.             )=(
>  Do something you aren't good at!" (used to say Henry Miller) ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: unable to initdb under cygwin

From
Kevin Marth
Date:
To which README files are you referring? Which cygserver.conf value(s) are believed relevant to the "shmat" problem?

-----Original Message-----
From: mike g <mike@thegodshalls.com>
Sent: Jul 16, 2004 11:23 PM
To: nasr.laili@tin.it
Cc: pgsql-cygwin@postgresql.org
Subject: Re: [CYGWIN] unable to initdb under cygwin

I still have not been able to overcome this problem(haven't spent much
time on it either to be truthful) but according to the new readmes it
might be helpful to change a value in cygserver.conf file.



________________________________________
PeoplePC Online
A better way to Internet
http://www.peoplepc.com

Re: unable to initdb under cygwin

From
Mike G
Date:
Looks like it is only included with the source code under directory CYGWIN-PATCHES

4. It may be necessary to increase cygserver's system wide max # of semaphores(SEMMNS).  This change is affected by
editing/etc/cygserver.conf setting the following parameter:  kern.ipc.semmns 100 and restarting cygserver. 

HTH
On Tue, Jul 20, 2004 at 08:33:34AM -0500, Kevin Marth wrote:
> To which README files are you referring? Which cygserver.conf value(s) are believed relevant to the "shmat" problem?
>
> -----Original Message-----
> From: mike g <mike@thegodshalls.com>
> Sent: Jul 16, 2004 11:23 PM
> To: nasr.laili@tin.it
> Cc: pgsql-cygwin@postgresql.org
> Subject: Re: [CYGWIN] unable to initdb under cygwin
>
> I still have not been able to overcome this problem(haven't spent much
> time on it either to be truthful) but according to the new readmes it
> might be helpful to change a value in cygserver.conf file.
>
>
>
> ________________________________________
> PeoplePC Online
> A better way to Internet
> http://www.peoplepc.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: unable to initdb under cygwin

From
Jason Tishler
Date:
Mike,

On Wed, Jul 21, 2004 at 12:56:05AM -0500, Mike G wrote:
> Looks like it is only included with the source code under directory
> CYGWIN-PATCHES
>
> 4. It may be necessary to increase cygserver's system wide max # of
> semaphores(SEMMNS).  This change is affected by editing
> /etc/cygserver.conf setting the following parameter:  kern.ipc.semmns
> 100 and restarting cygserver.

Huh?  The Cygwin PostgreSQL README is included in the binary package and
installed in:

    /usr/share/doc/Cygwin/postgresql-$version.README

where $version is the PostgreSQL version (e.g., 7.4.3).

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: unable to initdb under cygwin

From
Ennio-Sr
Date:
* Mike G <mike@thegodshalls.com> [210704, 00:56]:
> Looks like it is only included with the source code under directory CYGWIN-PATCHES
>
> 4. It may be necessary to increase cygserver's system wide max # of semaphores(SEMMNS).  This change is affected by
editing/etc/cygserver.conf setting the following parameter:  kern.ipc.semmns 100 and restarting cygserver. 
>

I tried that but the result didn't change! Grrrrr.......:-(((
Regards,
    Ennio.

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.     \\?//
 Fa' qualche cosa di cui non sei capace!"   (diceva Henry Miller) ]     (°|°)
[Why to use Win$ozz (I say) if ... "even a fool can do that.             )=(
 Do something you aren't good at!" (used to say Henry Miller) ]

Re: unable to initdb under cygwin

From
mike g
Date:
You are correct.  I was looking at the wrong readme version at the
time.  Sorry about that.

Mike

On Wed, 2004-07-21 at 06:43, Jason Tishler wrote:
> Mike,
>
> On Wed, Jul 21, 2004 at 12:56:05AM -0500, Mike G wrote:
> > Looks like it is only included with the source code under directory
> > CYGWIN-PATCHES
> >
> > 4. It may be necessary to increase cygserver's system wide max # of
> > semaphores(SEMMNS).  This change is affected by editing
> > /etc/cygserver.conf setting the following parameter:  kern.ipc.semmns
> > 100 and restarting cygserver.
>
> Huh?  The Cygwin PostgreSQL README is included in the binary package and
> installed in:
>
>     /usr/share/doc/Cygwin/postgresql-$version.README
>
> where $version is the PostgreSQL version (e.g., 7.4.3).
>
> Jason