Re: Postgresql under cygwin just stopped working.

Hello List,

I have been using PostgreSQL under CygWin for some time now and have been
very glad, but this day it just stopped working. I can't see what the
problem is, but 3 things has happend since yesterday where is ran fine:
1. I installed CygWin/X
2. My my laptop did'nt wake up after hypernate so I had to turn it off
3. I have just installed the Windows XP service upgrade

I was using the IPC daemon2 as an NT service, but I have also tryed using
the cygserver.

When I try to start this happens:

$postmaster -D /var/postgres/data/
Bad system call

and with debug level 5:

$ postmaster -d 5 -D /var/postgres/data/
[4004] DEBUG: postmaster: PostmasterMain: initial environ dump:
[4004] DEBUG: -----------------------------------------
[4004] DEBUG: !::=::\
[4004] DEBUG: !C:=C:\cygwin\bin
[4004] DEBUG: ALLUSERSPROFILE=C:\Documents and Settings\All Users
[4004] DEBUG: ANT_HOME=C:\java\apache-ant-1.6.1
[4004] DEBUG: APPDATA=C:\Documents and Settings\mh\Application Data
[4004] DEBUG: CLIENTNAME=Console
[4004] DEBUG: COMMONPROGRAMFILES=C:\Program Files\Common Files
[4004] DEBUG: COMPUTERNAME=MH2
[4004] DEBUG: COMSPEC=C:\WINDOWS\system32\cmd.exe
[4004] DEBUG: CVS_RSH=/bin/ssh
[4004] DEBUG: CYGSERVER=server
[4004] DEBUG: CYGWIN=tty
[4004] DEBUG: HOME=/home/mh
[4004] DEBUG: HOMEDRIVE=C:
[4004] DEBUG: HOMEPATH=\Documents and Settings\mh
[4004] DEBUG: HOSTNAME=MH2
[4004] DEBUG:
INFOPATH=/usr/local/info:/usr/info:/usr/share/info:/usr/autotool
/devel/info:/usr/autotool/stable/info:
[4004] DEBUG: JAVA_HOME=C:\j2sdk1.4.2
[4004] DEBUG: LOGONSERVER=\\MH2
[4004] DEBUG: MAKE_MODE=unix
[4004] DEBUG:
MANPATH=/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/dev
el/man::/usr/ssl/man:/usr/X11R6/man
[4004] DEBUG: NUMBER_OF_PROCESSORS=1
[4004] DEBUG: OLDPWD=/usr/bin
[4004] DEBUG: OS=Windows_NT
[4004] DEBUG:
PATH=/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/cygdrive/c/WIN
DOWS/system32:/cygdrive/c/WINDOWS:/cygdrive/c/WINDOWS/System32/Wbem:/cygdrive/c/
Program Files/Common Files/Adaptec
Shared/System:/cygdrive/c/PROGRA~1/ULTRAE~1:/
cygdrive/c/Program Files/nasm:/cygdrive/c/Program
Files/cdrecord:/cygdrive/c/j2s
dk1.4.2/bin:/cygdrive/c/java/apache-ant-1.6.1/bin:/usr/bin
[4004] DEBUG: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
[4004] DEBUG: PKG_CONFIG_PATH=/usr/X11R6/lib/pkgconfig
[4004] DEBUG: PROCESSOR_ARCHITECTURE=x86
[4004] DEBUG: PROCESSOR_IDENTIFIER=x86 Family 6 Model 9 Stepping 5,
GenuineInt
el
[4004] DEBUG: PROCESSOR_LEVEL=6
[4004] DEBUG: PROCESSOR_REVISION=0905
[4004] DEBUG: PROGRAMFILES=C:\Program Files
[4004] DEBUG: PROMPT=$P$G
[4004] DEBUG: PS1=\[\033]0;\w\007
\033[32m\]\u(at)\h \[\033[33m\w\033[0m\]
$
[4004] DEBUG: PWD=/home/mh
[4004] DEBUG: SESSIONNAME=Console
[4004] DEBUG: SHLVL=1
[4004] DEBUG: SYSTEMDRIVE=C:
[4004] DEBUG: SYSTEMROOT=C:\WINDOWS
[4004] DEBUG: TEMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
[4004] DEBUG: TERM=cygwin
[4004] DEBUG: TMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
[4004] DEBUG: USER=mh
[4004] DEBUG: USERDOMAIN=MH2
[4004] DEBUG: USERNAME=mh
[4004] DEBUG: USERPROFILE=C:\Documents and Settings\mh
[4004] DEBUG: WINDIR=C:\WINDOWS
[4004] DEBUG: _=/usr/bin/postmaster
[4004] DEBUG: TZ=RST-1RST-2,M3.5.0/2,M10.5.0/3
[4004] DEBUG: -----------------------------------------
[4004] DEBUG: searching PATH for executable
[4004] DEBUG: could not stat "/usr/local/bin/postgres": No such file or
directo
ry
[4004] DEBUG: found "/usr/bin/postgres" using PATH
[4004] DEBUG: invoking IpcMemoryCreate(size=10461184)
Bad system call

I tryed reinstalling the postgresql packages (7.3.1) from cygwin, but I
have not ran a initdb yet. Any idea's?
I would be very glad for any reply that could help solving this. Thanks.

Regards,
Martin

With 7.3.1 you really should be using cygserver instead of the
ipc-daemon. Was the cygserver config script run, installed as a
service, and running?

Perhaps double check the directory permissions in case the X
installation changed any.

Bad system call to me would indicate postgres is not able to request a
program or file it needs. It is the dam$ shmat error that no one seems
to be able to solve.

Reinstall cygwin as a last resort.

HTH

On Wed, 2004-07-14 at 07:20, Martin Husted Hartvig wrote:
> Hello List,
>
> I have been using PostgreSQL under CygWin for some time now and have been
> very glad, but this day it just stopped working. I can't see what the
> problem is, but 3 things has happend since yesterday where is ran fine:
> 1. I installed CygWin/X
> 2. My my laptop did'nt wake up after hypernate so I had to turn it off
> 3. I have just installed the Windows XP service upgrade
>
>
> I was using the IPC daemon2 as an NT service, but I have also tryed using
> the cygserver.
>
> When I try to start this happens:
>
> $postmaster -D /var/postgres/data/
> Bad system call
>
>
> and with debug level 5:
>
> $ postmaster -d 5 -D /var/postgres/data/
> [4004] DEBUG: postmaster: PostmasterMain: initial environ dump:
> [4004] DEBUG: -----------------------------------------
> [4004] DEBUG: !::=::\
> [4004] DEBUG: !C:=C:\cygwin\bin
> [4004] DEBUG: ALLUSERSPROFILE=C:\Documents and Settings\All Users
> [4004] DEBUG: ANT_HOME=C:\java\apache-ant-1.6.1
> [4004] DEBUG: APPDATA=C:\Documents and Settings\mh\Application Data
> [4004] DEBUG: CLIENTNAME=Console
> [4004] DEBUG: COMMONPROGRAMFILES=C:\Program Files\Common Files
> [4004] DEBUG: COMPUTERNAME=MH2
> [4004] DEBUG: COMSPEC=C:\WINDOWS\system32\cmd.exe
> [4004] DEBUG: CVS_RSH=/bin/ssh
> [4004] DEBUG: CYGSERVER=server
> [4004] DEBUG: CYGWIN=tty
> [4004] DEBUG: HOME=/home/mh
> [4004] DEBUG: HOMEDRIVE=C:
> [4004] DEBUG: HOMEPATH=\Documents and Settings\mh
> [4004] DEBUG: HOSTNAME=MH2
> [4004] DEBUG:
> INFOPATH=/usr/local/info:/usr/info:/usr/share/info:/usr/autotool
> /devel/info:/usr/autotool/stable/info:
> [4004] DEBUG: JAVA_HOME=C:\j2sdk1.4.2
> [4004] DEBUG: LOGONSERVER=\\MH2
> [4004] DEBUG: MAKE_MODE=unix
> [4004] DEBUG:
> MANPATH=/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/dev
> el/man::/usr/ssl/man:/usr/X11R6/man
> [4004] DEBUG: NUMBER_OF_PROCESSORS=1
> [4004] DEBUG: OLDPWD=/usr/bin
> [4004] DEBUG: OS=Windows_NT
> [4004] DEBUG:
> PATH=/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/cygdrive/c/WIN
> DOWS/system32:/cygdrive/c/WINDOWS:/cygdrive/c/WINDOWS/System32/Wbem:/cygdrive/c/
> Program Files/Common Files/Adaptec
> Shared/System:/cygdrive/c/PROGRA~1/ULTRAE~1:/
> cygdrive/c/Program Files/nasm:/cygdrive/c/Program
> Files/cdrecord:/cygdrive/c/j2s
> dk1.4.2/bin:/cygdrive/c/java/apache-ant-1.6.1/bin:/usr/bin
> [4004] DEBUG: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
> [4004] DEBUG: PKG_CONFIG_PATH=/usr/X11R6/lib/pkgconfig
> [4004] DEBUG: PROCESSOR_ARCHITECTURE=x86
> [4004] DEBUG: PROCESSOR_IDENTIFIER=x86 Family 6 Model 9 Stepping 5,
> GenuineInt
> el
> [4004] DEBUG: PROCESSOR_LEVEL=6
> [4004] DEBUG: PROCESSOR_REVISION=0905
> [4004] DEBUG: PROGRAMFILES=C:\Program Files
> [4004] DEBUG: PROMPT=$P$G
> [4004] DEBUG: PS1=\[\033]0;\w\007
> \033[32m\]\u(at)\h \[\033[33m\w\033[0m\]
> $
> [4004] DEBUG: PWD=/home/mh
> [4004] DEBUG: SESSIONNAME=Console
> [4004] DEBUG: SHLVL=1
> [4004] DEBUG: SYSTEMDRIVE=C:
> [4004] DEBUG: SYSTEMROOT=C:\WINDOWS
> [4004] DEBUG: TEMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
> [4004] DEBUG: TERM=cygwin
> [4004] DEBUG: TMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
> [4004] DEBUG: USER=mh
> [4004] DEBUG: USERDOMAIN=MH2
> [4004] DEBUG: USERNAME=mh
> [4004] DEBUG: USERPROFILE=C:\Documents and Settings\mh
> [4004] DEBUG: WINDIR=C:\WINDOWS
> [4004] DEBUG: _=/usr/bin/postmaster
> [4004] DEBUG: TZ=RST-1RST-2,M3.5.0/2,M10.5.0/3
> [4004] DEBUG: -----------------------------------------
> [4004] DEBUG: searching PATH for executable
> [4004] DEBUG: could not stat "/usr/local/bin/postgres": No such file or
> directo
> ry
> [4004] DEBUG: found "/usr/bin/postgres" using PATH
> [4004] DEBUG: invoking IpcMemoryCreate(size=10461184)
> Bad system call
>
> I tryed reinstalling the postgresql packages (7.3.1) from cygwin, but I
> have not ran a initdb yet. Any idea's?
> I would be very glad for any reply that could help solving this. Thanks.
>
> Regards,
> Martin
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match

Ok, as for the whole ipc-daemon vs. ipc-daemon2 vs. cygserver thing,
note I'm always using the binary version of PostgreSQL as installed by
the Cygwin setup utility. This means reading the appropriate README and
using the IPC service that a given version of PostgreSQL was built
against. For example, v7.4.1 was built against ipc-daemon2 and v7.4.3-1
is built against cygserver.

Assuming you're using the right version of IPC, here's what I'd look at
if PostgreSQL died on me:

1. Check if the PID file is still laying around from the last run.

This will definitely prevent PostgreSQL from starting up, unless
you're starting PostgreSQL via a script which checks for and removes
any leftover PID file. Typically you'll find this where your data
is located (/var/postgresql/data/postmaster.pid for v7.4.3 if you
used the README suggested location)

2. Remove any temp files related to PostgreSQL and/or IPC.

Basically, 'cd /tmp' and make sure there are no leftover files
from PostgreSQL, like the lock files

.s.PGSQL.5432
.s.PGSQL.5432.lock

and be sure to delete and files related to IPC. I can't recall the
filenames offhand, but they should stand out. Note if you fire up
different versions of IPC (ipc-daemon2, cygserver), you really want
to be sure to 'clean house' before you fire up a different one.
And of course never run two simultaneously. Bad idea. But if you
remove the files they use, should help a good bit.

3. Make sure your general binary file permissions are set right. I
find this to get mangled when I update features of Cygwin via its
setup.exe program. My usual steps once I do an update are

# check that all packages installed are "ok"; if not, run
# setup again and repeat
cygcheck -c > packages.lst
less packages.lst

#set file permissions on binaries so they can execute
chmod a+x /usr/bin /usr/bin/*

This may or may not help in your case.

4. Make sure your PostgreSQL config hasn't changed.

Be sure to check your PostgreSQL config files

pg_hba.conf == access to PostgreSQL
postgresql.conf == general config

found in /var/postgresql/data (default location for v7.4.3) and
verify your setup.

5. Possibly remove and reinstall the necessary services (assuming you
are running PostgreSQL as an NT Service). This means doing things
like

ipc-daemon2 --remove-as-service
ipc-daemon2 --install-as-service

or

cygrunsrv --remove cygserver
/bin/cygserver-config

and

cygrunsrv --remove postmaster
# see PostgreSQL Cygwin README for install step

If none of these help put you on the right path, not sure what else
might have happened, unless somehow the Windows update mangled the file
permissions somewhere down the path to your PostgreSQL data, in which
case you may want to login as your postgres user (the Windows user you
run PostgreSQL under if it's an NT service), then work your way down and
make sure you can actually access the files that make up the PostgreSQL
database.

Not sure what else to tell you. Best of luck.

Martin Husted Hartvig wrote:

> Hello List,
>
> I have been using PostgreSQL under CygWin for some time now and have
> been very glad, but this day it just stopped working. I can't see what
> the problem is, but 3 things has happend since yesterday where is ran
> fine:
> 1. I installed CygWin/X
> 2. My my laptop did'nt wake up after hypernate so I had to turn it off
> 3. I have just installed the Windows XP service upgrade
>
>
> I was using the IPC daemon2 as an NT service, but I have also tryed
> using the cygserver.
>
> When I try to start this happens:
>
> $postmaster -D /var/postgres/data/
> Bad system call
>
>
> and with debug level 5:
>
> $ postmaster -d 5 -D /var/postgres/data/
> [4004] DEBUG: postmaster: PostmasterMain: initial environ dump:
> [4004] DEBUG: -----------------------------------------
> [4004] DEBUG: !::=::\
> [4004] DEBUG: !C:=C:\cygwin\bin
> [4004] DEBUG: ALLUSERSPROFILE=C:\Documents and Settings\All Users
> [4004] DEBUG: ANT_HOME=C:\java\apache-ant-1.6.1
> [4004] DEBUG: APPDATA=C:\Documents and Settings\mh\Application Data
> [4004] DEBUG: CLIENTNAME=Console
> [4004] DEBUG: COMMONPROGRAMFILES=C:\Program Files\Common Files
> [4004] DEBUG: COMPUTERNAME=MH2
> [4004] DEBUG: COMSPEC=C:\WINDOWS\system32\cmd.exe
> [4004] DEBUG: CVS_RSH=/bin/ssh
> [4004] DEBUG: CYGSERVER=server
> [4004] DEBUG: CYGWIN=tty
> [4004] DEBUG: HOME=/home/mh
> [4004] DEBUG: HOMEDRIVE=C:
> [4004] DEBUG: HOMEPATH=\Documents and Settings\mh
> [4004] DEBUG: HOSTNAME=MH2
> [4004] DEBUG:
> INFOPATH=/usr/local/info:/usr/info:/usr/share/info:/usr/autotool
> /devel/info:/usr/autotool/stable/info:
> [4004] DEBUG: JAVA_HOME=C:\j2sdk1.4.2
> [4004] DEBUG: LOGONSERVER=\\MH2
> [4004] DEBUG: MAKE_MODE=unix
> [4004] DEBUG:
> MANPATH=/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/dev
> el/man::/usr/ssl/man:/usr/X11R6/man
> [4004] DEBUG: NUMBER_OF_PROCESSORS=1
> [4004] DEBUG: OLDPWD=/usr/bin
> [4004] DEBUG: OS=Windows_NT
> [4004] DEBUG:
> PATH=/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/cygdrive/c/WIN
> DOWS/system32:/cygdrive/c/WINDOWS:/cygdrive/c/WINDOWS/System32/Wbem:/cygdrive/c/
>
> Program Files/Common Files/Adaptec
> Shared/System:/cygdrive/c/PROGRA~1/ULTRAE~1:/
> cygdrive/c/Program Files/nasm:/cygdrive/c/Program
> Files/cdrecord:/cygdrive/c/j2s
> dk1.4.2/bin:/cygdrive/c/java/apache-ant-1.6.1/bin:/usr/bin
> [4004] DEBUG: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
> [4004] DEBUG: PKG_CONFIG_PATH=/usr/X11R6/lib/pkgconfig
> [4004] DEBUG: PROCESSOR_ARCHITECTURE=x86
> [4004] DEBUG: PROCESSOR_IDENTIFIER=x86 Family 6 Model 9 Stepping 5,
> GenuineInt
> el
> [4004] DEBUG: PROCESSOR_LEVEL=6
> [4004] DEBUG: PROCESSOR_REVISION=0905
> [4004] DEBUG: PROGRAMFILES=C:\Program Files
> [4004] DEBUG: PROMPT=$P$G
> [4004] DEBUG: PS1=\[\033]0;\w\007
> \033[32m\]\u(at)\h \[\033[33m\w\033[0m\]
> $
> [4004] DEBUG: PWD=/home/mh
> [4004] DEBUG: SESSIONNAME=Console
> [4004] DEBUG: SHLVL=1
> [4004] DEBUG: SYSTEMDRIVE=C:
> [4004] DEBUG: SYSTEMROOT=C:\WINDOWS
> [4004] DEBUG: TEMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
> [4004] DEBUG: TERM=cygwin
> [4004] DEBUG: TMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
> [4004] DEBUG: USER=mh
> [4004] DEBUG: USERDOMAIN=MH2
> [4004] DEBUG: USERNAME=mh
> [4004] DEBUG: USERPROFILE=C:\Documents and Settings\mh
> [4004] DEBUG: WINDIR=C:\WINDOWS
> [4004] DEBUG: _=/usr/bin/postmaster
> [4004] DEBUG: TZ=RST-1RST-2,M3.5.0/2,M10.5.0/3
> [4004] DEBUG: -----------------------------------------
> [4004] DEBUG: searching PATH for executable
> [4004] DEBUG: could not stat "/usr/local/bin/postgres": No such file
> or directo
> ry
> [4004] DEBUG: found "/usr/bin/postgres" using PATH
> [4004] DEBUG: invoking IpcMemoryCreate(size=10461184)
> Bad system call
>
> I tryed reinstalling the postgresql packages (7.3.1) from cygwin, but I
> have not ran a initdb yet. Any idea's?
> I would be very glad for any reply that could help solving this. Thanks.
>
> Regards,
> Martin
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>

As I had a backup of the databases I dropped the data folder and made a
initdb, trying with both ipc-daemon and cygserver. When starting
postgresql with ipc-daemon I got the same error, but starting with
cygserver got me a little on the move with semmns and semmni error
indications. When I changed the max_connections from 100 to 45 I was able
to start postgresql and restore my databases from my backups. Could this
have something to do with the Windows "secure" update from Microsoft?

Regards,
Martin

On Wed, 14 Jul 2004 23:38:44 -0500, mike g <mike(at)thegodshalls(dot)com> wrote:

> With 7.3.1 you really should be using cygserver instead of the
> ipc-daemon. Was the cygserver config script run, installed as a
> service, and running?
>
> Perhaps double check the directory permissions in case the X
> installation changed any.
>
> Bad system call to me would indicate postgres is not able to request a
> program or file it needs. It is the dam$ shmat error that no one seems
> to be able to solve.
>
> Reinstall cygwin as a last resort.
>
> HTH
>
> On Wed, 2004-07-14 at 07:20, Martin Husted Hartvig wrote:
>> Hello List,
>>
>> I have been using PostgreSQL under CygWin for some time now and have
>> been
>> very glad, but this day it just stopped working. I can't see what the
>> problem is, but 3 things has happend since yesterday where is ran fine:
>> 1. I installed CygWin/X
>> 2. My my laptop did'nt wake up after hypernate so I had to turn it off
>> 3. I have just installed the Windows XP service upgrade
>>
>>
>> I was using the IPC daemon2 as an NT service, but I have also tryed
>> using
>> the cygserver.
>>
>> When I try to start this happens:
>>
>> $postmaster -D /var/postgres/data/
>> Bad system call
>>
>>
>> and with debug level 5:
>>
>> $ postmaster -d 5 -D /var/postgres/data/
>> [4004] DEBUG: postmaster: PostmasterMain: initial environ dump:
>> [4004] DEBUG: -----------------------------------------
>> [4004] DEBUG: !::=::\
>> [4004] DEBUG: !C:=C:\cygwin\bin
>> [4004] DEBUG: ALLUSERSPROFILE=C:\Documents and Settings\All Users
>> [4004] DEBUG: ANT_HOME=C:\java\apache-ant-1.6.1
>> [4004] DEBUG: APPDATA=C:\Documents and Settings\mh\Application Data
>> [4004] DEBUG: CLIENTNAME=Console
>> [4004] DEBUG: COMMONPROGRAMFILES=C:\Program Files\Common Files
>> [4004] DEBUG: COMPUTERNAME=MH2
>> [4004] DEBUG: COMSPEC=C:\WINDOWS\system32\cmd.exe
>> [4004] DEBUG: CVS_RSH=/bin/ssh
>> [4004] DEBUG: CYGSERVER=server
>> [4004] DEBUG: CYGWIN=tty
>> [4004] DEBUG: HOME=/home/mh
>> [4004] DEBUG: HOMEDRIVE=C:
>> [4004] DEBUG: HOMEPATH=\Documents and Settings\mh
>> [4004] DEBUG: HOSTNAME=MH2
>> [4004] DEBUG:
>> INFOPATH=/usr/local/info:/usr/info:/usr/share/info:/usr/autotool
>> /devel/info:/usr/autotool/stable/info:
>> [4004] DEBUG: JAVA_HOME=C:\j2sdk1.4.2
>> [4004] DEBUG: LOGONSERVER=\\MH2
>> [4004] DEBUG: MAKE_MODE=unix
>> [4004] DEBUG:
>> MANPATH=/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/dev
>> el/man::/usr/ssl/man:/usr/X11R6/man
>> [4004] DEBUG: NUMBER_OF_PROCESSORS=1
>> [4004] DEBUG: OLDPWD=/usr/bin
>> [4004] DEBUG: OS=Windows_NT
>> [4004] DEBUG:
>> PATH=/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/cygdrive/c/WIN
>> DOWS/system32:/cygdrive/c/WINDOWS:/cygdrive/c/WINDOWS/System32/Wbem:/cygdrive/c/
>> Program Files/Common Files/Adaptec
>> Shared/System:/cygdrive/c/PROGRA~1/ULTRAE~1:/
>> cygdrive/c/Program Files/nasm:/cygdrive/c/Program
>> Files/cdrecord:/cygdrive/c/j2s
>> dk1.4.2/bin:/cygdrive/c/java/apache-ant-1.6.1/bin:/usr/bin
>> [4004] DEBUG: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
>> [4004] DEBUG: PKG_CONFIG_PATH=/usr/X11R6/lib/pkgconfig
>> [4004] DEBUG: PROCESSOR_ARCHITECTURE=x86
>> [4004] DEBUG: PROCESSOR_IDENTIFIER=x86 Family 6 Model 9 Stepping 5,
>> GenuineInt
>> el
>> [4004] DEBUG: PROCESSOR_LEVEL=6
>> [4004] DEBUG: PROCESSOR_REVISION=0905
>> [4004] DEBUG: PROGRAMFILES=C:\Program Files
>> [4004] DEBUG: PROMPT=$P$G
>> [4004] DEBUG: PS1=\[\033]0;\w\007
>> \033[32m\]\u(at)\h \[\033[33m\w\033[0m\]
>> $
>> [4004] DEBUG: PWD=/home/mh
>> [4004] DEBUG: SESSIONNAME=Console
>> [4004] DEBUG: SHLVL=1
>> [4004] DEBUG: SYSTEMDRIVE=C:
>> [4004] DEBUG: SYSTEMROOT=C:\WINDOWS
>> [4004] DEBUG: TEMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
>> [4004] DEBUG: TERM=cygwin
>> [4004] DEBUG: TMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
>> [4004] DEBUG: USER=mh
>> [4004] DEBUG: USERDOMAIN=MH2
>> [4004] DEBUG: USERNAME=mh
>> [4004] DEBUG: USERPROFILE=C:\Documents and Settings\mh
>> [4004] DEBUG: WINDIR=C:\WINDOWS
>> [4004] DEBUG: _=/usr/bin/postmaster
>> [4004] DEBUG: TZ=RST-1RST-2,M3.5.0/2,M10.5.0/3
>> [4004] DEBUG: -----------------------------------------
>> [4004] DEBUG: searching PATH for executable
>> [4004] DEBUG: could not stat "/usr/local/bin/postgres": No such file or
>> directo
>> ry
>> [4004] DEBUG: found "/usr/bin/postgres" using PATH
>> [4004] DEBUG: invoking IpcMemoryCreate(size=10461184)
>> Bad system call
>>
>> I tryed reinstalling the postgresql packages (7.3.1) from cygwin, but I
>> have not ran a initdb yet. Any idea's?
>> I would be very glad for any reply that could help solving this. Thanks.
>>
>> Regards,
>> Martin
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 9: the planner will ignore your desire to choose an index scan if
>> your
>> joining column's datatypes do not match

--
Martin

Not sure to tell you the truth but cygwin postgres 7.4.1 sets the max
connections at 10 by default if I remember correctly.

On Thu, 2004-07-15 at 02:57, Martin Husted Hartvig wrote:
> As I had a backup of the databases I dropped the data folder and made a
> initdb, trying with both ipc-daemon and cygserver. When starting
> postgresql with ipc-daemon I got the same error, but starting with
> cygserver got me a little on the move with semmns and semmni error
> indications. When I changed the max_connections from 100 to 45 I was able
> to start postgresql and restore my databases from my backups. Could this
> have something to do with the Windows "secure" update from Microsoft?
>
>
> Regards,
> Martin
>
>
> On Wed, 14 Jul 2004 23:38:44 -0500, mike g <mike(at)thegodshalls(dot)com> wrote:
>
> > With 7.3.1 you really should be using cygserver instead of the
> > ipc-daemon. Was the cygserver config script run, installed as a
> > service, and running?
> >
> > Perhaps double check the directory permissions in case the X
> > installation changed any.
> >
> > Bad system call to me would indicate postgres is not able to request a
> > program or file it needs. It is the dam$ shmat error that no one seems
> > to be able to solve.
> >
> > Reinstall cygwin as a last resort.
> >
> > HTH
> >
> > On Wed, 2004-07-14 at 07:20, Martin Husted Hartvig wrote:
> >> Hello List,
> >>
> >> I have been using PostgreSQL under CygWin for some time now and have
> >> been
> >> very glad, but this day it just stopped working. I can't see what the
> >> problem is, but 3 things has happend since yesterday where is ran fine:
> >> 1. I installed CygWin/X
> >> 2. My my laptop did'nt wake up after hypernate so I had to turn it off
> >> 3. I have just installed the Windows XP service upgrade
> >>
> >>
> >> I was using the IPC daemon2 as an NT service, but I have also tryed
> >> using
> >> the cygserver.
> >>
> >> When I try to start this happens:
> >>
> >> $postmaster -D /var/postgres/data/
> >> Bad system call
> >>
> >>
> >> and with debug level 5:
> >>
> >> $ postmaster -d 5 -D /var/postgres/data/
> >> [4004] DEBUG: postmaster: PostmasterMain: initial environ dump:
> >> [4004] DEBUG: -----------------------------------------
> >> [4004] DEBUG: !::=::\
> >> [4004] DEBUG: !C:=C:\cygwin\bin
> >> [4004] DEBUG: ALLUSERSPROFILE=C:\Documents and Settings\All Users
> >> [4004] DEBUG: ANT_HOME=C:\java\apache-ant-1.6.1
> >> [4004] DEBUG: APPDATA=C:\Documents and Settings\mh\Application Data
> >> [4004] DEBUG: CLIENTNAME=Console
> >> [4004] DEBUG: COMMONPROGRAMFILES=C:\Program Files\Common Files
> >> [4004] DEBUG: COMPUTERNAME=MH2
> >> [4004] DEBUG: COMSPEC=C:\WINDOWS\system32\cmd.exe
> >> [4004] DEBUG: CVS_RSH=/bin/ssh
> >> [4004] DEBUG: CYGSERVER=server
> >> [4004] DEBUG: CYGWIN=tty
> >> [4004] DEBUG: HOME=/home/mh
> >> [4004] DEBUG: HOMEDRIVE=C:
> >> [4004] DEBUG: HOMEPATH=\Documents and Settings\mh
> >> [4004] DEBUG: HOSTNAME=MH2
> >> [4004] DEBUG:
> >> INFOPATH=/usr/local/info:/usr/info:/usr/share/info:/usr/autotool
> >> /devel/info:/usr/autotool/stable/info:
> >> [4004] DEBUG: JAVA_HOME=C:\j2sdk1.4.2
> >> [4004] DEBUG: LOGONSERVER=\\MH2
> >> [4004] DEBUG: MAKE_MODE=unix
> >> [4004] DEBUG:
> >> MANPATH=/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/dev
> >> el/man::/usr/ssl/man:/usr/X11R6/man
> >> [4004] DEBUG: NUMBER_OF_PROCESSORS=1
> >> [4004] DEBUG: OLDPWD=/usr/bin
> >> [4004] DEBUG: OS=Windows_NT
> >> [4004] DEBUG:
> >> PATH=/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/cygdrive/c/WIN
> >> DOWS/system32:/cygdrive/c/WINDOWS:/cygdrive/c/WINDOWS/System32/Wbem:/cygdrive/c/
> >> Program Files/Common Files/Adaptec
> >> Shared/System:/cygdrive/c/PROGRA~1/ULTRAE~1:/
> >> cygdrive/c/Program Files/nasm:/cygdrive/c/Program
> >> Files/cdrecord:/cygdrive/c/j2s
> >> dk1.4.2/bin:/cygdrive/c/java/apache-ant-1.6.1/bin:/usr/bin
> >> [4004] DEBUG: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
> >> [4004] DEBUG: PKG_CONFIG_PATH=/usr/X11R6/lib/pkgconfig
> >> [4004] DEBUG: PROCESSOR_ARCHITECTURE=x86
> >> [4004] DEBUG: PROCESSOR_IDENTIFIER=x86 Family 6 Model 9 Stepping 5,
> >> GenuineInt
> >> el
> >> [4004] DEBUG: PROCESSOR_LEVEL=6
> >> [4004] DEBUG: PROCESSOR_REVISION=0905
> >> [4004] DEBUG: PROGRAMFILES=C:\Program Files
> >> [4004] DEBUG: PROMPT=$P$G
> >> [4004] DEBUG: PS1=\[\033]0;\w\007
> >> \033[32m\]\u(at)\h \[\033[33m\w\033[0m\]
> >> $
> >> [4004] DEBUG: PWD=/home/mh
> >> [4004] DEBUG: SESSIONNAME=Console
> >> [4004] DEBUG: SHLVL=1
> >> [4004] DEBUG: SYSTEMDRIVE=C:
> >> [4004] DEBUG: SYSTEMROOT=C:\WINDOWS
> >> [4004] DEBUG: TEMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
> >> [4004] DEBUG: TERM=cygwin
> >> [4004] DEBUG: TMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
> >> [4004] DEBUG: USER=mh
> >> [4004] DEBUG: USERDOMAIN=MH2
> >> [4004] DEBUG: USERNAME=mh
> >> [4004] DEBUG: USERPROFILE=C:\Documents and Settings\mh
> >> [4004] DEBUG: WINDIR=C:\WINDOWS
> >> [4004] DEBUG: _=/usr/bin/postmaster
> >> [4004] DEBUG: TZ=RST-1RST-2,M3.5.0/2,M10.5.0/3
> >> [4004] DEBUG: -----------------------------------------
> >> [4004] DEBUG: searching PATH for executable
> >> [4004] DEBUG: could not stat "/usr/local/bin/postgres": No such file or
> >> directo
> >> ry
> >> [4004] DEBUG: found "/usr/bin/postgres" using PATH
> >> [4004] DEBUG: invoking IpcMemoryCreate(size=10461184)
> >> Bad system call
> >>
> >> I tryed reinstalling the postgresql packages (7.3.1) from cygwin, but I
> >> have not ran a initdb yet. Any idea's?
> >> I would be very glad for any reply that could help solving this. Thanks.
> >>
> >> Regards,
> >> Martin
> >>
> >>
> >> ---------------------------(end of broadcast)---------------------------
> >> TIP 9: the planner will ignore your desire to choose an index scan if
> >> your
> >> joining column's datatypes do not match
>
>

I just installed postgres 7.4.3 on a win2000, here the default max
connections was set to 40, thanks anyway.

Installing on the win2000 gave me a problem and I found one of your
mail/replies from the 1/7/2004
(http://article.gmane.org/gmane.comp.db.postgresql.cygwin/2502), I have
the precise same error and the only thing I can see that might course it
is that I was forced to install cygwin in e:\cygwin and not in c:\cygwin.
Is there anywhere I can set the -l parameter to postmaster like with
pq_ctl or is there a other way around this problem?

Regards,
Martin

On Thu, 15 Jul 2004 23:42:38 -0500, mike g <mike(at)thegodshalls(dot)com> wrote:

> Not sure to tell you the truth but cygwin postgres 7.4.1 sets the max
> connections at 10 by default if I remember correctly.
>
>
> On Thu, 2004-07-15 at 02:57, Martin Husted Hartvig wrote:
>> As I had a backup of the databases I dropped the data folder and made a
>> initdb, trying with both ipc-daemon and cygserver. When starting
>> postgresql with ipc-daemon I got the same error, but starting with
>> cygserver got me a little on the move with semmns and semmni error
>> indications. When I changed the max_connections from 100 to 45 I was
>> able
>> to start postgresql and restore my databases from my backups. Could this
>> have something to do with the Windows "secure" update from Microsoft?
>>
>>
>> Regards,
>> Martin
>>
>>
>> On Wed, 14 Jul 2004 23:38:44 -0500, mike g <mike(at)thegodshalls(dot)com>
>> wrote:
>>
>> > With 7.3.1 you really should be using cygserver instead of the
>> > ipc-daemon. Was the cygserver config script run, installed as a
>> > service, and running?
>> >
>> > Perhaps double check the directory permissions in case the X
>> > installation changed any.
>> >
>> > Bad system call to me would indicate postgres is not able to request a
>> > program or file it needs. It is the dam$ shmat error that no one
>> seems
>> > to be able to solve.
>> >
>> > Reinstall cygwin as a last resort.
>> >
>> > HTH
>> >
>> > On Wed, 2004-07-14 at 07:20, Martin Husted Hartvig wrote:
>> >> Hello List,
>> >>
>> >> I have been using PostgreSQL under CygWin for some time now and have
>> >> been
>> >> very glad, but this day it just stopped working. I can't see what the
>> >> problem is, but 3 things has happend since yesterday where is ran
>> fine:
>> >> 1. I installed CygWin/X
>> >> 2. My my laptop did'nt wake up after hypernate so I had to turn it
>> off
>> >> 3. I have just installed the Windows XP service upgrade
>> >>
>> >>
>> >> I was using the IPC daemon2 as an NT service, but I have also tryed
>> >> using
>> >> the cygserver.
>> >>
>> >> When I try to start this happens:
>> >>
>> >> $postmaster -D /var/postgres/data/
>> >> Bad system call
>> >>
>> >>
>> >> and with debug level 5:
>> >>
>> >> $ postmaster -d 5 -D /var/postgres/data/
>> >> [4004] DEBUG: postmaster: PostmasterMain: initial environ dump:
>> >> [4004] DEBUG: -----------------------------------------
>> >> [4004] DEBUG: !::=::\
>> >> [4004] DEBUG: !C:=C:\cygwin\bin
>> >> [4004] DEBUG: ALLUSERSPROFILE=C:\Documents and Settings\All Users
>> >> [4004] DEBUG: ANT_HOME=C:\java\apache-ant-1.6.1
>> >> [4004] DEBUG: APPDATA=C:\Documents and Settings\mh\Application Data
>> >> [4004] DEBUG: CLIENTNAME=Console
>> >> [4004] DEBUG: COMMONPROGRAMFILES=C:\Program Files\Common Files
>> >> [4004] DEBUG: COMPUTERNAME=MH2
>> >> [4004] DEBUG: COMSPEC=C:\WINDOWS\system32\cmd.exe
>> >> [4004] DEBUG: CVS_RSH=/bin/ssh
>> >> [4004] DEBUG: CYGSERVER=server
>> >> [4004] DEBUG: CYGWIN=tty
>> >> [4004] DEBUG: HOME=/home/mh
>> >> [4004] DEBUG: HOMEDRIVE=C:
>> >> [4004] DEBUG: HOMEPATH=\Documents and Settings\mh
>> >> [4004] DEBUG: HOSTNAME=MH2
>> >> [4004] DEBUG:
>> >> INFOPATH=/usr/local/info:/usr/info:/usr/share/info:/usr/autotool
>> >> /devel/info:/usr/autotool/stable/info:
>> >> [4004] DEBUG: JAVA_HOME=C:\j2sdk1.4.2
>> >> [4004] DEBUG: LOGONSERVER=\\MH2
>> >> [4004] DEBUG: MAKE_MODE=unix
>> >> [4004] DEBUG:
>> >> MANPATH=/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/dev
>> >> el/man::/usr/ssl/man:/usr/X11R6/man
>> >> [4004] DEBUG: NUMBER_OF_PROCESSORS=1
>> >> [4004] DEBUG: OLDPWD=/usr/bin
>> >> [4004] DEBUG: OS=Windows_NT
>> >> [4004] DEBUG:
>> >> PATH=/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/cygdrive/c/WIN
>> >>
>> DOWS/system32:/cygdrive/c/WINDOWS:/cygdrive/c/WINDOWS/System32/Wbem:/cygdrive/c/
>> >> Program Files/Common Files/Adaptec
>> >> Shared/System:/cygdrive/c/PROGRA~1/ULTRAE~1:/
>> >> cygdrive/c/Program Files/nasm:/cygdrive/c/Program
>> >> Files/cdrecord:/cygdrive/c/j2s
>> >> dk1.4.2/bin:/cygdrive/c/java/apache-ant-1.6.1/bin:/usr/bin
>> >> [4004] DEBUG:
>> PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
>> >> [4004] DEBUG: PKG_CONFIG_PATH=/usr/X11R6/lib/pkgconfig
>> >> [4004] DEBUG: PROCESSOR_ARCHITECTURE=x86
>> >> [4004] DEBUG: PROCESSOR_IDENTIFIER=x86 Family 6 Model 9 Stepping 5,
>> >> GenuineInt
>> >> el
>> >> [4004] DEBUG: PROCESSOR_LEVEL=6
>> >> [4004] DEBUG: PROCESSOR_REVISION=0905
>> >> [4004] DEBUG: PROGRAMFILES=C:\Program Files
>> >> [4004] DEBUG: PROMPT=$P$G
>> >> [4004] DEBUG: PS1=\[\033]0;\w\007
>> >> \033[32m\]\u(at)\h \[\033[33m\w\033[0m\]
>> >> $
>> >> [4004] DEBUG: PWD=/home/mh
>> >> [4004] DEBUG: SESSIONNAME=Console
>> >> [4004] DEBUG: SHLVL=1
>> >> [4004] DEBUG: SYSTEMDRIVE=C:
>> >> [4004] DEBUG: SYSTEMROOT=C:\WINDOWS
>> >> [4004] DEBUG: TEMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
>> >> [4004] DEBUG: TERM=cygwin
>> >> [4004] DEBUG: TMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
>> >> [4004] DEBUG: USER=mh
>> >> [4004] DEBUG: USERDOMAIN=MH2
>> >> [4004] DEBUG: USERNAME=mh
>> >> [4004] DEBUG: USERPROFILE=C:\Documents and Settings\mh
>> >> [4004] DEBUG: WINDIR=C:\WINDOWS
>> >> [4004] DEBUG: _=/usr/bin/postmaster
>> >> [4004] DEBUG: TZ=RST-1RST-2,M3.5.0/2,M10.5.0/3
>> >> [4004] DEBUG: -----------------------------------------
>> >> [4004] DEBUG: searching PATH for executable
>> >> [4004] DEBUG: could not stat "/usr/local/bin/postgres": No such
>> file or
>> >> directo
>> >> ry
>> >> [4004] DEBUG: found "/usr/bin/postgres" using PATH
>> >> [4004] DEBUG: invoking IpcMemoryCreate(size=10461184)
>> >> Bad system call
>> >>
>> >> I tryed reinstalling the postgresql packages (7.3.1) from cygwin,
>> but I
>> >> have not ran a initdb yet. Any idea's?
>> >> I would be very glad for any reply that could help solving this.
>> Thanks.
>> >>
>> >> Regards,
>> >> Martin
>> >>
>> >>
>> >> ---------------------------(end of
>> broadcast)---------------------------
>> >> TIP 9: the planner will ignore your desire to choose an index scan if
>> >> your
>> >> joining column's datatypes do not match
>>
>>
>
> ---------------------------(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)

if you run this command from a bash promt what does it output? env

The paths cygwin is using should be listed in the output. If it is not E then it will need to be changed. When you updated / reinstalled did you move it from drive C to E? I don't know if the cygwin installer is smart enough to remove the previous path references.

I would guess that your path still has references to the C drive location. usually new additions to the path are added to the end of the list. Once cygwin finds a reference to the path it stops looking for others.

start->settings->control panel->system->advanced->enviornment variables->bottom section of system variables should have a line name path. Remove the following if it is still in there 'C:\cygwin\bin;' (must have admin rights). There should be a 'E:\cygwin\bin;' in there.

cygserver doesn't require you to specify a different install location. It will find it via the environment variables set (path).

Otherwise you can start postmaster passing the location with the -D option. In cygwin mapped network drives are prefixed with a /cygdrive. So drive c is really /cygdrive/c. postmaster -D /cygdrive/e/var/postgresql/data

HTH

On Mon, Jul 19, 2004 at 10:11:56AM +0200, Martin Husted Hartvig wrote:
>
> I just installed postgres 7.4.3 on a win2000, here the default max
> connections was set to 40, thanks anyway.
>
> Installing on the win2000 gave me a problem and I found one of your
> mail/replies from the 1/7/2004
> (http://article.gmane.org/gmane.comp.db.postgresql.cygwin/2502), I have
> the precise same error and the only thing I can see that might course it
> is that I was forced to install cygwin in e:\cygwin and not in c:\cygwin.
> Is there anywhere I can set the -l parameter to postmaster like with
> pq_ctl or is there a other way around this problem?
>
> Regards,
> Martin
>
>
> On Thu, 15 Jul 2004 23:42:38 -0500, mike g <mike(at)thegodshalls(dot)com> wrote:
>
> >Not sure to tell you the truth but cygwin postgres 7.4.1 sets the max
> >connections at 10 by default if I remember correctly.
> >
> >
> >On Thu, 2004-07-15 at 02:57, Martin Husted Hartvig wrote:
> >>As I had a backup of the databases I dropped the data folder and made a
> >>initdb, trying with both ipc-daemon and cygserver. When starting
> >>postgresql with ipc-daemon I got the same error, but starting with
> >>cygserver got me a little on the move with semmns and semmni error
> >>indications. When I changed the max_connections from 100 to 45 I was
> >>able
> >>to start postgresql and restore my databases from my backups. Could this
> >>have something to do with the Windows "secure" update from Microsoft?
> >>
> >>
> >>Regards,
> >>Martin
> >>
> >>
> >>On Wed, 14 Jul 2004 23:38:44 -0500, mike g <mike(at)thegodshalls(dot)com>
> >>wrote:
> >>
> >>> With 7.3.1 you really should be using cygserver instead of the
> >>> ipc-daemon. Was the cygserver config script run, installed as a
> >>> service, and running?
> >>>
> >>> Perhaps double check the directory permissions in case the X
> >>> installation changed any.
> >>>
> >>> Bad system call to me would indicate postgres is not able to request a
> >>> program or file it needs. It is the dam$ shmat error that no one
> >>seems
> >>> to be able to solve.
> >>>
> >>> Reinstall cygwin as a last resort.
> >>>
> >>> HTH
> >>>
> >>> On Wed, 2004-07-14 at 07:20, Martin Husted Hartvig wrote:
> >>>> Hello List,
> >>>>
> >>>> I have been using PostgreSQL under CygWin for some time now and have
> >>>> been
> >>>> very glad, but this day it just stopped working. I can't see what the
> >>>> problem is, but 3 things has happend since yesterday where is ran
> >>fine:
> >>>> 1. I installed CygWin/X
> >>>> 2. My my laptop did'nt wake up after hypernate so I had to turn it
> >>off
> >>>> 3. I have just installed the Windows XP service upgrade
> >>>>
> >>>>
> >>>> I was using the IPC daemon2 as an NT service, but I have also tryed
> >>>> using
> >>>> the cygserver.
> >>>>
> >>>> When I try to start this happens:
> >>>>
> >>>> $postmaster -D /var/postgres/data/
> >>>> Bad system call
> >>>>
> >>>>
> >>>> and with debug level 5:
> >>>>
> >>>> $ postmaster -d 5 -D /var/postgres/data/
> >>>> [4004] DEBUG: postmaster: PostmasterMain: initial environ dump:
> >>>> [4004] DEBUG: -----------------------------------------
> >>>> [4004] DEBUG: !::=::\
> >>>> [4004] DEBUG: !C:=C:\cygwin\bin
> >>>> [4004] DEBUG: ALLUSERSPROFILE=C:\Documents and Settings\All Users
> >>>> [4004] DEBUG: ANT_HOME=C:\java\apache-ant-1.6.1
> >>>> [4004] DEBUG: APPDATA=C:\Documents and Settings\mh\Application Data
> >>>> [4004] DEBUG: CLIENTNAME=Console
> >>>> [4004] DEBUG: COMMONPROGRAMFILES=C:\Program Files\Common Files
> >>>> [4004] DEBUG: COMPUTERNAME=MH2
> >>>> [4004] DEBUG: COMSPEC=C:\WINDOWS\system32\cmd.exe
> >>>> [4004] DEBUG: CVS_RSH=/bin/ssh
> >>>> [4004] DEBUG: CYGSERVER=server
> >>>> [4004] DEBUG: CYGWIN=tty
> >>>> [4004] DEBUG: HOME=/home/mh
> >>>> [4004] DEBUG: HOMEDRIVE=C:
> >>>> [4004] DEBUG: HOMEPATH=\Documents and Settings\mh
> >>>> [4004] DEBUG: HOSTNAME=MH2
> >>>> [4004] DEBUG:
> >>>> INFOPATH=/usr/local/info:/usr/info:/usr/share/info:/usr/autotool
> >>>> /devel/info:/usr/autotool/stable/info:
> >>>> [4004] DEBUG: JAVA_HOME=C:\j2sdk1.4.2
> >>>> [4004] DEBUG: LOGONSERVER=\\MH2
> >>>> [4004] DEBUG: MAKE_MODE=unix
> >>>> [4004] DEBUG:
> >>>> MANPATH=/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/dev
> >>>> el/man::/usr/ssl/man:/usr/X11R6/man
> >>>> [4004] DEBUG: NUMBER_OF_PROCESSORS=1
> >>>> [4004] DEBUG: OLDPWD=/usr/bin
> >>>> [4004] DEBUG: OS=Windows_NT
> >>>> [4004] DEBUG:
> >>>> PATH=/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/cygdrive/c/WIN
> >>>>
> >>DOWS/system32:/cygdrive/c/WINDOWS:/cygdrive/c/WINDOWS/System32/Wbem:/cygdrive/c/
> >>>> Program Files/Common Files/Adaptec
> >>>> Shared/System:/cygdrive/c/PROGRA~1/ULTRAE~1:/
> >>>> cygdrive/c/Program Files/nasm:/cygdrive/c/Program
> >>>> Files/cdrecord:/cygdrive/c/j2s
> >>>> dk1.4.2/bin:/cygdrive/c/java/apache-ant-1.6.1/bin:/usr/bin
> >>>> [4004] DEBUG:
> >>PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
> >>>> [4004] DEBUG: PKG_CONFIG_PATH=/usr/X11R6/lib/pkgconfig
> >>>> [4004] DEBUG: PROCESSOR_ARCHITECTURE=x86
> >>>> [4004] DEBUG: PROCESSOR_IDENTIFIER=x86 Family 6 Model 9 Stepping 5,
> >>>> GenuineInt
> >>>> el
> >>>> [4004] DEBUG: PROCESSOR_LEVEL=6
> >>>> [4004] DEBUG: PROCESSOR_REVISION=0905
> >>>> [4004] DEBUG: PROGRAMFILES=C:\Program Files
> >>>> [4004] DEBUG: PROMPT=$P$G
> >>>> [4004] DEBUG: PS1=\[\033]0;\w\007
> >>>> \033[32m\]\u(at)\h \[\033[33m\w\033[0m\]
> >>>> $
> >>>> [4004] DEBUG: PWD=/home/mh
> >>>> [4004] DEBUG: SESSIONNAME=Console
> >>>> [4004] DEBUG: SHLVL=1
> >>>> [4004] DEBUG: SYSTEMDRIVE=C:
> >>>> [4004] DEBUG: SYSTEMROOT=C:\WINDOWS
> >>>> [4004] DEBUG: TEMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
> >>>> [4004] DEBUG: TERM=cygwin
> >>>> [4004] DEBUG: TMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp
> >>>> [4004] DEBUG: USER=mh
> >>>> [4004] DEBUG: USERDOMAIN=MH2
> >>>> [4004] DEBUG: USERNAME=mh
> >>>> [4004] DEBUG: USERPROFILE=C:\Documents and Settings\mh
> >>>> [4004] DEBUG: WINDIR=C:\WINDOWS
> >>>> [4004] DEBUG: _=/usr/bin/postmaster
> >>>> [4004] DEBUG: TZ=RST-1RST-2,M3.5.0/2,M10.5.0/3
> >>>> [4004] DEBUG: -----------------------------------------
> >>>> [4004] DEBUG: searching PATH for executable
> >>>> [4004] DEBUG: could not stat "/usr/local/bin/postgres": No such
> >>file or
> >>>> directo
> >>>> ry
> >>>> [4004] DEBUG: found "/usr/bin/postgres" using PATH
> >>>> [4004] DEBUG: invoking IpcMemoryCreate(size=10461184)
> >>>> Bad system call
> >>>>
> >>>> I tryed reinstalling the postgresql packages (7.3.1) from cygwin,
> >>but I
> >>>> have not ran a initdb yet. Any idea's?
> >>>> I would be very glad for any reply that could help solving this.
> >>Thanks.
> >>>>
> >>>> Regards,
> >>>> Martin
> >>>>
> >>>>
> >>>> ---------------------------(end of
> >>broadcast)---------------------------
> >>>> TIP 9: the planner will ignore your desire to choose an index scan if
> >>>> your
> >>>> joining column's datatypes do not match
> >>
> >>
> >
> >---------------------------(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)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

I'm still workin on this, and it just won't locate the log file position.
I have made some dumps:

The PATH didn't have a ref to cygwin, so I added it like you wrote:

PATH
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;"C:\Program
Files\Symantec\Norton Ghost 2003\";E:\cygwin\bin

Here is what cygwin sees:

$ set
!C:='C:\Documents and Settings\mh\Desktop'
!E:='E:\cygwin\bin'
ALLUSERSPROFILE='C:\Documents and Settings\All Users'
APPDATA='C:\Documents and Settings\mh\Application Data'
BASH=/usr/bin/bash
BASH_VERSINFO=([0]="2" [1]="05b" [2]="0" [3]="1" [4]="release"
[5]="i686-pc-cygw
in")
BASH_VERSION='2.05b.0(1)-release'
CLIENTNAME=MH2
COLUMNS=80
COMMONPROGRAMFILES='C:\Program Files\Common Files'
COMPUTERNAME=SERVER
COMSPEC='C:\WINNT\system32\cmd.exe'
CVS_RSH=/bin/ssh
CYGWIN=server
DIRSTACK=()
EUID=1002
GROUPS=()
HISTFILE=/home/mh/.bash_history
HISTFILESIZE=500
HISTSIZE=500
HOME=/home/mh
HOMEDRIVE=C:
HOMEPATH='\Documents and Settings\mh'
HOSTNAME=Server
HOSTTYPE=i686
IFS=$' \t\n'
INFOPATH=/usr/local/info:/usr/info:/usr/share/info:/usr/autotool/devel/info:/usr
/autotool/stable/info:
LINES=25
LOGONSERVER='\\SERVER'
MACHTYPE=i686-pc-cygwin
MAILCHECK=60
MAKE_MODE=unix
MANPATH=/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/devel/man::/usr/ssl
/man
NUMBER_OF_PROCESSORS=1
OLDPWD=/usr/bin
OPTERR=1
OPTIND=1
OS=Windows_NT
OS2LIBPATH='C:\WINNT\system32\os2\dll;'
OSTYPE=cygwin
PATH='/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/cygdrive/c/WINNT/system32:/cy
gdrive/c/WINNT:/cygdrive/c/WINNT/System32/Wbem:"C:/Program
Files/Symantec/Norton
Ghost 2003/":/usr/bin'
PATHEXT='.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH'
PIPESTATUS=([0]="1")
PPID=1
PRINTER=
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER='x86 Family 6 Model 8 Stepping 3, GenuineIntel'
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0803
PROGRAMFILES='C:\Program Files'
PROMPT='$P$G'
PS1=$'\\[\\033]0;\\w\\007\n\\033[32m\\]\\u(at)\\h
\\[\\033[33m\\w\\033[0m\\]\n$ '
PS2='> '
PS4='+ '
PWD=/home/mh
SESSIONNAME=RDP-Tcp#3
SHELL=/bin/bash
SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments:moni
tor
SHLVL=1
SYSTEMDRIVE=C:
SYSTEMROOT='C:\WINNT'
TEMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp/1
TERM=cygwin
TMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp/1
UID=1002
USER=mh
USERDOMAIN=SERVER
USERNAME=mh
USERPROFILE='C:\Documents and Settings\mh'
WINDIR='C:\WINNT'
_=/var/postgresql/datahtg
f=

Trying to install as a service gives:

$ cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D
/cygdrive/e/var/postgresql/datahtg -i"
--dep cygserver --termsig INT --user mh --shutdown

$ net start postmaster

The postmaster service is starting.
The postmaster service could not be started.

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

DEBUG: exit(1)

hmmm.... starting the postmaster comes with this:

$ /usr/bin/postmaster -d 5 -D /var/postgresql/datahtg
DEBUG: /usr/bin/postmaster: PostmasterMain: initial environ dump:
DEBUG: -----------------------------------------
DEBUG: !C:=C:\Documents and Settings\mh\Desktop
DEBUG: !E:=E:\cygwin\bin
DEBUG: ALLUSERSPROFILE=C:\Documents and Settings\All Users
DEBUG: APPDATA=C:\Documents and Settings\mh\Application Data
DEBUG: CLIENTNAME=MH2
DEBUG: COMMONPROGRAMFILES=C:\Program Files\Common Files
DEBUG: COMPUTERNAME=SERVER
DEBUG: COMSPEC=C:\WINNT\system32\cmd.exe
DEBUG: CVS_RSH=/bin/ssh
DEBUG: CYGWIN=server
DEBUG: HOME=/home/mh
DEBUG: HOMEDRIVE=C:
DEBUG: HOMEPATH=\Documents and Settings\mh
DEBUG: HOSTNAME=Server
DEBUG:
INFOPATH=/usr/local/info:/usr/info:/usr/share/info:/usr/autotool
/devel/info:/usr/autotool/stable/info:
DEBUG: LOGONSERVER=\\SERVER
DEBUG: MAKE_MODE=unix
DEBUG:
MANPATH=/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/dev
el/man::/usr/ssl/man
DEBUG: NUMBER_OF_PROCESSORS=1
DEBUG: OLDPWD=/usr/bin
DEBUG: OS2LIBPATH=C:\WINNT\system32\os2\dll;
DEBUG: OS=Windows_NT
DEBUG:
PATH=/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/cygdrive/c/WIN
NT/system32:/cygdrive/c/WINNT:/cygdrive/c/WINNT/System32/Wbem:"C:/Program
Files/
Symantec/Norton Ghost 2003/":/usr/bin
DEBUG: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
DEBUG: PROCESSOR_ARCHITECTURE=x86
DEBUG: PROCESSOR_IDENTIFIER=x86 Family 6 Model 8 Stepping 3,
GenuineInt
el
DEBUG: PROCESSOR_LEVEL=6
DEBUG: PROCESSOR_REVISION=0803
DEBUG: PROGRAMFILES=C:\Program Files
DEBUG: PROMPT=$P$G
DEBUG: PS1=\[\033]0;\w\007
\033[32m\]\u(at)\h \[\033[33m\w\033[0m\]
$
DEBUG: PWD=/home/mh
DEBUG: SESSIONNAME=RDP-Tcp#3
DEBUG: SHLVL=1
DEBUG: SYSTEMDRIVE=C:
DEBUG: SYSTEMROOT=C:\WINNT
DEBUG: TEMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp/1
DEBUG: TERM=cygwin
DEBUG: TMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp/1
DEBUG: USER=mh
DEBUG: USERDOMAIN=SERVER
DEBUG: USERNAME=mh
DEBUG: USERPROFILE=C:\Documents and Settings\mh
DEBUG: WINDIR=C:\WINNT
DEBUG: _=/usr/bin/postmaster
DEBUG: TZ=RST-1RDT-2,M3.5.0/2,M10.5.0/3
DEBUG: -----------------------------------------
DEBUG: found "/usr/bin/postgres" using argv[0]
DEBUG: invoking IpcMemoryCreate(size=8970240)
WARNING: dup(0) failed after 3195 successes: Bad file descriptor
DEBUG: max_safe_fds = 985, usable_fds = 3195, already_open = 5
DEBUG: found "/usr/bin/postmaster" using argv[0]
E:\cygwin\bin\postgres.exe (4928): *** MapViewOfFileEx (0xF10000), Win32
error 4
87. Terminating.
E:\cygwin\bin\postgres.exe (4924): *** MapViewOfFileEx (0xF10000), Win32
error 4
87. Terminating.
DEBUG: reaping dead processes
LOG: statistics collector process (PID 4928) exited with exit code 1
LOG: startup process (PID 4924) exited with exit code 1
LOG: aborting startup due to startup process failure
DEBUG: proc_exit(1)
DEBUG: shmem_exit(1)

I'm only able to start postgres with the pg_ctl command.

Regards,
Martin

On Mon, 19 Jul 2004 21:55:42 -0500, Mike G <mike(at)thegodshalls(dot)com> wrote:

> if you run this command from a bash promt what does it output? env
>
> The paths cygwin is using should be listed in the output. If it is not
> E then it will need to be changed. When you updated / reinstalled did
> you move it from drive C to E? I don't know if the cygwin installer is
> smart enough to remove the previous path references.
>
> I would guess that your path still has references to the C drive
> location. usually new additions to the path are added to the end of the
> list. Once cygwin finds a reference to the path it stops looking for
> others.
>
> start->settings->control panel->system->advanced->enviornment
> variables->bottom section of system variables should have a line name
> path. Remove the following if it is still in there 'C:\cygwin\bin;'
> (must have admin rights). There should be a 'E:\cygwin\bin;' in there.
>
> cygserver doesn't require you to specify a different install location.
> It will find it via the environment variables set (path).
>
> Otherwise you can start postmaster passing the location with the -D
> option. In cygwin mapped network drives are prefixed with a /cygdrive.
> So drive c is really /cygdrive/c. postmaster -D
> /cygdrive/e/var/postgresql/data
>
>
> HTH
>
>
> On Mon, Jul 19, 2004 at 10:11:56AM +0200, Martin Husted Hartvig wrote:
>>
>> I just installed postgres 7.4.3 on a win2000, here the default max
>> connections was set to 40, thanks anyway.
>>
>> Installing on the win2000 gave me a problem and I found one of your
>> mail/replies from the 1/7/2004
>> (http://article.gmane.org/gmane.comp.db.postgresql.cygwin/2502), I have
>> the precise same error and the only thing I can see that might course it
>> is that I was forced to install cygwin in e:\cygwin and not in
>> c:\cygwin.
>> Is there anywhere I can set the -l parameter to postmaster like with
>> pq_ctl or is there a other way around this problem?
>>
>> Regards,
>> Martin
>>

Ok,

This might be a long shot but what account are you running the postmaster service under? Postgres as the docs mention? Would the postgres account not have permissions to access drive E? If you log into windows as the postgres user can you access the log folder?

From what you posted below it looks like you can start the postmaster using pg_ctl possibly because you are not executing it under the postgres account.

Mike

On Fri, Jul 23, 2004 at 10:42:06AM +0200, Martin Husted Hartvig wrote:
> I'm still workin on this, and it just won't locate the log file position.
> I have made some dumps:
>
> The PATH didn't have a ref to cygwin, so I added it like you wrote:
>
> PATH
> %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;"C:\Program
> Files\Symantec\Norton Ghost 2003\";E:\cygwin\bin
>
> Here is what cygwin sees:
>
> $ set
> !C:='C:\Documents and Settings\mh\Desktop'
> !E:='E:\cygwin\bin'
> ALLUSERSPROFILE='C:\Documents and Settings\All Users'
> APPDATA='C:\Documents and Settings\mh\Application Data'
> BASH=/usr/bin/bash
> BASH_VERSINFO=([0]="2" [1]="05b" [2]="0" [3]="1" [4]="release"
> [5]="i686-pc-cygw
> in")
> BASH_VERSION='2.05b.0(1)-release'
> CLIENTNAME=MH2
> COLUMNS=80
> COMMONPROGRAMFILES='C:\Program Files\Common Files'
> COMPUTERNAME=SERVER
> COMSPEC='C:\WINNT\system32\cmd.exe'
> CVS_RSH=/bin/ssh
> CYGWIN=server
> DIRSTACK=()
> EUID=1002
> GROUPS=()
> HISTFILE=/home/mh/.bash_history
> HISTFILESIZE=500
> HISTSIZE=500
> HOME=/home/mh
> HOMEDRIVE=C:
> HOMEPATH='\Documents and Settings\mh'
> HOSTNAME=Server
> HOSTTYPE=i686
> IFS=$' \t\n'
> INFOPATH=/usr/local/info:/usr/info:/usr/share/info:/usr/autotool/devel/info:/usr
> /autotool/stable/info:
> LINES=25
> LOGONSERVER='\\SERVER'
> MACHTYPE=i686-pc-cygwin
> MAILCHECK=60
> MAKE_MODE=unix
> MANPATH=/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/devel/man::/usr/ssl
> /man
> NUMBER_OF_PROCESSORS=1
> OLDPWD=/usr/bin
> OPTERR=1
> OPTIND=1
> OS=Windows_NT
> OS2LIBPATH='C:\WINNT\system32\os2\dll;'
> OSTYPE=cygwin
> PATH='/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/cygdrive/c/WINNT/system32:/cy
> gdrive/c/WINNT:/cygdrive/c/WINNT/System32/Wbem:"C:/Program
> Files/Symantec/Norton
> Ghost 2003/":/usr/bin'
> PATHEXT='.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH'
> PIPESTATUS=([0]="1")
> PPID=1
> PRINTER=
> PROCESSOR_ARCHITECTURE=x86
> PROCESSOR_IDENTIFIER='x86 Family 6 Model 8 Stepping 3, GenuineIntel'
> PROCESSOR_LEVEL=6
> PROCESSOR_REVISION=0803
> PROGRAMFILES='C:\Program Files'
> PROMPT='$P$G'
> PS1=$'\\[\\033]0;\\w\\007\n\\033[32m\\]\\u(at)\\h
> \\[\\033[33m\\w\\033[0m\\]\n$ '
> PS2='> '
> PS4='+ '
> PWD=/home/mh
> SESSIONNAME=RDP-Tcp#3
> SHELL=/bin/bash
> SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments:moni
> tor
> SHLVL=1
> SYSTEMDRIVE=C:
> SYSTEMROOT='C:\WINNT'
> TEMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp/1
> TERM=cygwin
> TMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp/1
> UID=1002
> USER=mh
> USERDOMAIN=SERVER
> USERNAME=mh
> USERPROFILE='C:\Documents and Settings\mh'
> WINDIR='C:\WINNT'
> _=/var/postgresql/datahtg
> f=
>
>
>
>
>
> Trying to install as a service gives:
>
> $ cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D
> /cygdrive/e/var/postgresql/datahtg -i"
> --dep cygserver --termsig INT --user mh --shutdown
>
>
> $ net start postmaster
>
> The postmaster service is starting.
> The postmaster service could not be started.
>
> A system error has occurred.
>
> System error 1067 has occurred.
>
> The process terminated unexpectedly.
>
>
> DEBUG: exit(1)
>
>
>
> hmmm.... starting the postmaster comes with this:
>
> $ /usr/bin/postmaster -d 5 -D /var/postgresql/datahtg
> DEBUG: /usr/bin/postmaster: PostmasterMain: initial environ dump:
> DEBUG: -----------------------------------------
> DEBUG: !C:=C:\Documents and Settings\mh\Desktop
> DEBUG: !E:=E:\cygwin\bin
> DEBUG: ALLUSERSPROFILE=C:\Documents and Settings\All Users
> DEBUG: APPDATA=C:\Documents and Settings\mh\Application Data
> DEBUG: CLIENTNAME=MH2
> DEBUG: COMMONPROGRAMFILES=C:\Program Files\Common Files
> DEBUG: COMPUTERNAME=SERVER
> DEBUG: COMSPEC=C:\WINNT\system32\cmd.exe
> DEBUG: CVS_RSH=/bin/ssh
> DEBUG: CYGWIN=server
> DEBUG: HOME=/home/mh
> DEBUG: HOMEDRIVE=C:
> DEBUG: HOMEPATH=\Documents and Settings\mh
> DEBUG: HOSTNAME=Server
> DEBUG:
> INFOPATH=/usr/local/info:/usr/info:/usr/share/info:/usr/autotool
> /devel/info:/usr/autotool/stable/info:
> DEBUG: LOGONSERVER=\\SERVER
> DEBUG: MAKE_MODE=unix
> DEBUG:
> MANPATH=/usr/local/man:/usr/man:/usr/share/man:/usr/autotool/dev
> el/man::/usr/ssl/man
> DEBUG: NUMBER_OF_PROCESSORS=1
> DEBUG: OLDPWD=/usr/bin
> DEBUG: OS2LIBPATH=C:\WINNT\system32\os2\dll;
> DEBUG: OS=Windows_NT
> DEBUG:
> PATH=/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/cygdrive/c/WIN
> NT/system32:/cygdrive/c/WINNT:/cygdrive/c/WINNT/System32/Wbem:"C:/Program
> Files/
> Symantec/Norton Ghost 2003/":/usr/bin
> DEBUG: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
> DEBUG: PROCESSOR_ARCHITECTURE=x86
> DEBUG: PROCESSOR_IDENTIFIER=x86 Family 6 Model 8 Stepping 3,
> GenuineInt
> el
> DEBUG: PROCESSOR_LEVEL=6
> DEBUG: PROCESSOR_REVISION=0803
> DEBUG: PROGRAMFILES=C:\Program Files
> DEBUG: PROMPT=$P$G
> DEBUG: PS1=\[\033]0;\w\007
> \033[32m\]\u(at)\h \[\033[33m\w\033[0m\]
> $
> DEBUG: PWD=/home/mh
> DEBUG: SESSIONNAME=RDP-Tcp#3
> DEBUG: SHLVL=1
> DEBUG: SYSTEMDRIVE=C:
> DEBUG: SYSTEMROOT=C:\WINNT
> DEBUG: TEMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp/1
> DEBUG: TERM=cygwin
> DEBUG: TMP=/cygdrive/c/DOCUME~1/mh/LOCALS~1/Temp/1
> DEBUG: USER=mh
> DEBUG: USERDOMAIN=SERVER
> DEBUG: USERNAME=mh
> DEBUG: USERPROFILE=C:\Documents and Settings\mh
> DEBUG: WINDIR=C:\WINNT
> DEBUG: _=/usr/bin/postmaster
> DEBUG: TZ=RST-1RDT-2,M3.5.0/2,M10.5.0/3
> DEBUG: -----------------------------------------
> DEBUG: found "/usr/bin/postgres" using argv[0]
> DEBUG: invoking IpcMemoryCreate(size=8970240)
> WARNING: dup(0) failed after 3195 successes: Bad file descriptor
> DEBUG: max_safe_fds = 985, usable_fds = 3195, already_open = 5
> DEBUG: found "/usr/bin/postmaster" using argv[0]
> E:\cygwin\bin\postgres.exe (4928): *** MapViewOfFileEx (0xF10000), Win32
> error 4
> 87. Terminating.
> E:\cygwin\bin\postgres.exe (4924): *** MapViewOfFileEx (0xF10000), Win32
> error 4
> 87. Terminating.
> DEBUG: reaping dead processes
> LOG: statistics collector process (PID 4928) exited with exit code 1
> LOG: startup process (PID 4924) exited with exit code 1
> LOG: aborting startup due to startup process failure
> DEBUG: proc_exit(1)
> DEBUG: shmem_exit(1)
>
>
> I'm only able to start postgres with the pg_ctl command.
>
> Regards,
> Martin
>
>
>
>
>
> On Mon, 19 Jul 2004 21:55:42 -0500, Mike G <mike(at)thegodshalls(dot)com> wrote:
>
> >if you run this command from a bash promt what does it output? env
> >
> >The paths cygwin is using should be listed in the output. If it is not
> >E then it will need to be changed. When you updated / reinstalled did
> >you move it from drive C to E? I don't know if the cygwin installer is
> >smart enough to remove the previous path references.
> >
> >I would guess that your path still has references to the C drive
> >location. usually new additions to the path are added to the end of the
> >list. Once cygwin finds a reference to the path it stops looking for
> >others.
> >
> >start->settings->control panel->system->advanced->enviornment
> >variables->bottom section of system variables should have a line name
> >path. Remove the following if it is still in there 'C:\cygwin\bin;'
> >(must have admin rights). There should be a 'E:\cygwin\bin;' in there.
> >
> >cygserver doesn't require you to specify a different install location.
> >It will find it via the environment variables set (path).
> >
> >Otherwise you can start postmaster passing the location with the -D
> >option. In cygwin mapped network drives are prefixed with a /cygdrive.
> >So drive c is really /cygdrive/c. postmaster -D
> >/cygdrive/e/var/postgresql/data
> >
> >
> >HTH
> >
> >
> >On Mon, Jul 19, 2004 at 10:11:56AM +0200, Martin Husted Hartvig wrote:
> >>
> >>I just installed postgres 7.4.3 on a win2000, here the default max
> >>connections was set to 40, thanks anyway.
> >>
> >>Installing on the win2000 gave me a problem and I found one of your
> >>mail/replies from the 1/7/2004
> >>(http://article.gmane.org/gmane.comp.db.postgresql.cygwin/2502), I have
> >>the precise same error and the only thing I can see that might course it
> >>is that I was forced to install cygwin in e:\cygwin and not in
> >>c:\cygwin.
> >>Is there anywhere I can set the -l parameter to postmaster like with
> >>pq_ctl or is there a other way around this problem?
> >>
> >>Regards,
> >>Martin
> >>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org