Re: postgresql-cygwin-windowsXP

Postgres stopped working on 98 around 7.4.2.  I don't know if NT was affected by the changes.  7.4.5 needs to use
cygserverfor memory instead of ipc-daemon2.  That was put in place around 7.4.2.  Try the postgresql readme and
cygserverreadme. 

MIke

On Sun, Dec 05, 2004 at 11:13:12AM +0100, Kasimir Müller wrote:
> Hi Jason,
>
> My cygwin-postgresql enviroment worked perfectly for years until now.
> Some weeks before I  installed Servicepack  2 .
> Now I  can't start postgresql  anymore.
> I get the "Bad system call"  Error  after  invoking
> IpcMemoryCreate(size=10461184).
> I know, there was a lot  of similar questions on this list, but I can't
> get a solution.
> I'm starting postgresql with:
> ipc-daemon2  &
> postmaster  -D /usr/local/pgsql/data -i -d 5
>
> I also tried installing ipc-daemon as a service with the same results.
> I attached the output of cygcheck.
>
> Can You please help me ?
>
> Yours,
>
> Kasimir

> Error: could not find v
>
> Cygwin Configuration Diagnostics
> Current System Time: Sun Dec 05 11:02:18 2004
>
> Windows NT Ver 4.0 Build 1381 Service Pack 5
>
> Path:    D:\cygwin\usr\local\bin
>     D:\cygwin\bin
>     D:\cygwin\bin
>     d:\progs\imagemagick-6.1.2-q16
>     d:\Perl\bin\
>     c:\WINDOWS\system32
>     c:\WINDOWS
>     c:\WINDOWS\system32\WBEM
>     d:\Borland\Delphi5\Bpl
>     d:\Borland\vbroker\jre\Bin
>     d:\Borland\vbroker\Bin
>     d:\Borland\Delphi5\Bin
>     d:\palm
>     d:\MICROS~1\Office
>     c:\Programme\Network Associates\pgp658b9b3
>     c:\sqlany
>     d:\wsql40\win
>     c:\Programme\Support Tools\
>     c:\sqlany
>     .\
>     d:\wsql40\win
>
> Output from D:\cygwin\bin\id.exe (nontsec)
> UID: 1008(kjmz) GID: 513(Kein)
> 513(Kein)
>
> Output from D:\cygwin\bin\id.exe (ntsec)
> UID: 1008(kjmz)      GID: 513(Kein)
> 0(root)              513(Kein)            544(Administratoren)
> 545(Benutzer)
>
> SysDir: C:\WINDOWS\system32
> WinDir: C:\WINDOWS
>
> HOME = `D:\cygwin\home\kjmz'
> MAKE_MODE = `unix'
> PWD = `/usr/local/pgsql/data'
> USER = `kjmz'
>
> HKEY_CURRENT_USER\Software\Cygnus Solutions
> HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin
> HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin\Program Options
> HKEY_CURRENT_USER\Software\Cygnus Solutions\Cygwin\mounts v2
> HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions
> HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin
> HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\Program Options
> HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2
>   (default) = `/cygdrive'
>   cygdrive flags = 0x00000022
> HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/lib
>   (default) = `D:\cygwin/lib'
>   flags = 0x0000000a
> HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/bin
>   (default) = `D:\cygwin/bin'
>   flags = 0x0000000a
> HKEY_LOCAL_MACHINE\SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/
>   (default) = `D:\cygwin'
>   flags = 0x0000000a
>
> c:  hd  NTFS      6000Mb  58% CP CS UN PA FC     Disk_C
> d:  hd  NTFS      6000Mb  65% CP CS UN PA FC     Progs
> e:  hd  NTFS     12158Mb  39% CP CS UN PA FC     DATA
> g:  cd             N/A    N/A
>
> D:\cygwin/lib  /usr/lib   system  binmode
> D:\cygwin/bin  /usr/bin   system  binmode
> D:\cygwin      /          system  binmode
> .              /cygdrive  system  binmode,cygdrive
>
> Found: D:\cygwin\bin\awk.exe
> Found: D:\cygwin\bin\bash.exe
> Found: D:\cygwin\bin\cat.exe
> Found: D:\cygwin\bin\cp.exe
> Found: D:\cygwin\bin\cpp.exe
> Found: D:\cygwin\bin\find.exe
> Found: D:\cygwin\bin\gcc.exe
> Not Found: gdb
> Found: D:\cygwin\bin\grep.exe
> Found: d:\Borland\Delphi5\Bin\grep.exe
> Found: D:\cygwin\bin\ld.exe
> Found: D:\cygwin\bin\ls.exe
> Found: D:\cygwin\bin\make.exe
> Found: d:\Borland\Delphi5\Bin\make.exe
> Found: D:\cygwin\bin\mv.exe
> Found: D:\cygwin\bin\rm.exe
> Found: D:\cygwin\bin\sed.exe
> Found: D:\cygwin\bin\sh.exe
> Found: D:\cygwin\bin\tar.exe
> Found: d:\Perl\bin\tar.exe
>
>    55k 2004/09/14 D:\cygwin\bin\cygbz2-1.dll
>    18k 2004/07/06 D:\cygwin\bin\cygcharset-1.dll
>     7k 2003/10/19 D:\cygwin\bin\cygcrypt-0.dll
>   839k 2004/09/27 D:\cygwin\bin\cygcrypto-0.9.7.dll
>   645k 2003/04/11 D:\cygwin\bin\cygcrypto.dll
>    22k 2004/02/10 D:\cygwin\bin\cygcygipc-2.dll
>   380k 2002/07/24 D:\cygwin\bin\cygdb-3.1.dll
>   831k 2003/09/20 D:\cygwin\bin\cygdb-4.1.dll
>   895k 2004/04/28 D:\cygwin\bin\cygdb-4.2.dll
>   487k 2002/07/24 D:\cygwin\bin\cygdb_cxx-3.1.dll
>  1080k 2003/09/20 D:\cygwin\bin\cygdb_cxx-4.1.dll
>  1156k 2004/04/28 D:\cygwin\bin\cygdb_cxx-4.2.dll
>   174k 2004/10/14 D:\cygwin\bin\cygexpat-0.dll
>    40k 2004/10/10 D:\cygwin\bin\cygform-8.dll
>    45k 2001/04/25 D:\cygwin\bin\cygform5.dll
>    35k 2002/01/09 D:\cygwin\bin\cygform6.dll
>    48k 2003/08/09 D:\cygwin\bin\cygform7.dll
>    28k 2003/07/20 D:\cygwin\bin\cyggdbm-3.dll
>    30k 2003/08/11 D:\cygwin\bin\cyggdbm-4.dll
>    19k 2003/03/22 D:\cygwin\bin\cyggdbm.dll
>    15k 2003/07/20 D:\cygwin\bin\cyggdbm_compat-3.dll
>    15k 2003/08/11 D:\cygwin\bin\cyggdbm_compat-4.dll
>   107k 2004/07/06 D:\cygwin\bin\cyggettextlib-0-14-1.dll
>    17k 2004/07/06 D:\cygwin\bin\cyggettextpo-0.dll
>   190k 2004/07/06 D:\cygwin\bin\cyggettextsrc-0-14-1.dll
>    17k 2001/06/28 D:\cygwin\bin\cyghistory4.dll
>    29k 2003/08/10 D:\cygwin\bin\cyghistory5.dll
>    25k 2004/10/12 D:\cygwin\bin\cyghistory6.dll
>   991k 2004/07/06 D:\cygwin\bin\cygiconv-2.dll
>    22k 2001/12/13 D:\cygwin\bin\cygintl-1.dll
>    37k 2003/08/10 D:\cygwin\bin\cygintl-2.dll
>    54k 2004/07/06 D:\cygwin\bin\cygintl-3.dll
>   144k 2004/08/29 D:\cygwin\bin\cygmagic-1.dll
>    22k 2004/10/10 D:\cygwin\bin\cygmenu-8.dll
>    26k 2001/04/25 D:\cygwin\bin\cygmenu5.dll
>    20k 2002/01/09 D:\cygwin\bin\cygmenu6.dll
>    29k 2003/08/09 D:\cygwin\bin\cygmenu7.dll
>    21k 2004/10/22 D:\cygwin\bin\cygminires.dll
>    74k 2004/10/10 D:\cygwin\bin\cygncurses++-8.dll
>   156k 2001/04/25 D:\cygwin\bin\cygncurses++5.dll
>   175k 2002/01/09 D:\cygwin\bin\cygncurses++6.dll
>   216k 2004/10/10 D:\cygwin\bin\cygncurses-8.dll
>   226k 2001/04/25 D:\cygwin\bin\cygncurses5.dll
>   202k 2002/01/09 D:\cygwin\bin\cygncurses6.dll
>   224k 2003/08/09 D:\cygwin\bin\cygncurses7.dll
>    13k 2004/10/10 D:\cygwin\bin\cygpanel-8.dll
>    15k 2001/04/25 D:\cygwin\bin\cygpanel5.dll
>    12k 2002/01/09 D:\cygwin\bin\cygpanel6.dll
>    19k 2003/08/09 D:\cygwin\bin\cygpanel7.dll
>    62k 2003/12/11 D:\cygwin\bin\cygpcre-0.dll
>    63k 2003/04/11 D:\cygwin\bin\cygpcre.dll
>     9k 2003/12/11 D:\cygwin\bin\cygpcreposix-0.dll
>    61k 2003/04/11 D:\cygwin\bin\cygpcreposix.dll
>  1061k 2004/08/19 D:\cygwin\bin\cygperl5_8_5.dll
>    22k 2002/06/09 D:\cygwin\bin\cygpopt-0.dll
>   108k 2001/06/28 D:\cygwin\bin\cygreadline4.dll
>   148k 2003/08/10 D:\cygwin\bin\cygreadline5.dll
>   144k 2004/10/12 D:\cygwin\bin\cygreadline6.dll
>   170k 2004/09/27 D:\cygwin\bin\cygssl-0.9.7.dll
>   165k 2003/04/11 D:\cygwin\bin\cygssl.dll
>    62k 2004/10/10 D:\cygwin\bin\cygz.dll
>  1114k 2004/11/10 D:\cygwin\bin\cygwin1.dll
>     Cygwin DLL version info:
>         DLL version: 1.5.12
>         DLL epoch: 19
>         DLL bad signal mask: 19005
>         DLL old termios: 5
>         DLL malloc env: 28
>         API major: 0
>         API minor: 116
>         Shared data: 4
>         DLL identifier: cygwin1
>         Mount registry: 2
>         Cygnus registry name: Cygnus Solutions
>         Cygwin registry name: Cygwin
>         Program options name: Program Options
>         Cygwin mount registry name: mounts v2
>         Cygdrive flags: cygdrive flags
>         Cygdrive prefix: cygdrive prefix
>         Cygdrive default prefix:
>         Build date: Wed Nov 10 08:34:47 EST 2004
>         Shared id: cygwin1S4
>
>
> Cygwin Package Information
> Package              Version
> _update-info-dir     00230-1
> ash                  20040127-1
> autoconf             2.59-1
> autoconf-devel       2.59-1
> autoconf-stable      2.13-5
> automake             1.7.9-1
> automake-devel       1.9.2-1
> automake-stable      1.4p6-2
> base-files           3.1-4
> base-passwd          2.1-1
> bash                 2.05b-16
> binutils             20040725-2
> bison                20030307-1
> byacc                1.9-1
> bzip2                1.0.2-6
> clear                1.0-1
> crypt                1.1-1
> cvs                  1.11.17-1
> cygipc               2.03-2
> cygrunsrv            1.0-1
> cygutils             1.2.5-1
> cygwin               1.5.12-1
> cygwin-doc           1.3-7
> diff                 1.0-1
> diffutils            2.8.7-1
> dpkg                 1.10.4-2
> editrights           1.01-1
> expat                1.95.8-1
> file                 4.10-1
> fileutils            4.1-2
> findutils            4.1.7-4
> gawk                 3.1.4-3
> gcc                  3.3.3-3
> gcc-core             3.3.3-3
> gcc-g++              3.3.3-3
> gcc-mingw            20040810-1
> gcc-mingw-core       20040810-1
> gcc-mingw-g++        20040810-1
> gdbm                 1.8.3-7
> gettext              0.14.1-1
> grep                 2.5-1
> groff                1.18.1-2
> gzip                 1.3.5-1
> less                 381-1
> libbz2_1             1.0.2-6
> libcharset1          1.9.2-1
> libdb3.1             3.1.17-2
> libdb4.1             4.1.25-1
> libdb4.2             4.2.52-1
> libgdbm              1.8.0-5
> libgdbm-devel        1.8.3-7
> libgdbm3             1.8.3-3
> libgdbm4             1.8.3-7
> libgettextpo0        0.14.1-1
> libiconv             1.9.2-1
> libiconv2            1.9.2-1
> libintl1             0.10.40-1
> libintl2             0.12.1-3
> libintl3             0.14.1-1
> libncurses5          5.2-1
> libncurses6          5.2-8
> libncurses7          5.3-4
> libncurses8          5.4-1
> libpcre              4.1-1
> libpcre0             4.5-1
> libpopt0             1.6.4-4
> libreadline4         4.1-2
> libreadline5         4.3-5
> libreadline6         5.0-1
> login                1.9-7
> lynx                 2.8.4-8
> m4                   1.4.2-1
> make                 3.80-1
> man                  1.5o-1
> mc                   4.6.0-4
> mingw-runtime        3.5-1
> minires              1.00-1
> mktemp               1.5-3
> nano                 1.2.2-1
> ncftp                3.1.7-1
> ncurses              5.4-1
> openssh              3.9p1-2
> openssl              0.9.7d-2
> openssl096           0.9.6j-1
> patch                2.5.8-8
> pcre                 4.5-1
> pcre-doc             4.5-1
> perl                 5.8.5-3
> postgresql           7.4.5-1
> readline             5.0-1
> rsync                2.6.3-1
> sed                  4.1.2-1
> sh-utils             2.0.15-4
> tar                  1.13.25-5
> termcap              20021106-2
> terminfo             5.4_20041009-1
> texinfo              4.2-4
> textutils            2.0.21-1
> unzip                5.50-5
> w32api               3.1-1
> wget                 1.9.1-1
> which                1.5-2
> zip                  2.3-6
> zlib                 1.2.2-1
> zsh                  4.2.0-2
> Use -h to see help about each section

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org