May be you did not shutdown the database when the last time you start it.
Try this :
1. type 'ps -a' . Can you see any 'postgres' in the 'command' column ?
If not proceed to no. 2
2. type 'rm /usr/share/postgresql/data/postmaster.pid'
Each time PostgreSQL runs, it creates the
If you shutdown the database cleanly, the file will be deleted.
Upon starting the postmaster, PostgreSQL check this file, if the file exist,
then it is a sign that a postmaster already running.
Everytime you're done working with Cygwin + PostgreSQL, use this command to
cleanly shutdown the postmaster :
'pg_ctl stop -D /usr/share/postgresq/data'
Hey...I hope this is not a production server.
I can not bear the responsible any lost of your data.
----- Original Message -----
From: "João Carlos Fernandes Costa" <joao(dot)costa(at)oni(dot)pt>
To: "'Andy Samuel'" <andysamuel(at)myrealbox(dot)com>
Sent: Monday, April 29, 2002 4:09 PM
Subject: Re: [CYGWIN] accessing a db
> Hi Andy,
> I try your command sequence, but when I typed the second line I got the
> pg_ctl: Another postmaster may be running. Trying to start
> postmaster anyway.
> pg_ctl: cannot start postmaster
> Examine the log output.
> + Done ipc-daemon
> Any ideas?
In response to
pgsql-cygwin by date
|Next:||From: Dave Page||Date: 2002-04-30 08:19:36|
|Subject: Re: plpgsql won't work|
|Previous:||From: Jason Tishler||Date: 2002-04-29 19:27:16|
|Subject: Re: Cygwin-Postgres-IpcMemoryCreate|