Обсуждение: unable to initdb under cygwin
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) ]
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)
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
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
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
* 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) ]
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