Skip site navigation (1) Skip section navigation (2)

Re: accessing a db

From: "Andy Samuel" <andysamuel(at)myrealbox(dot)com>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: accessing a db
Date: 2002-04-30 02:32:39
Message-ID: 004301c1efef$4c1aede0$0200a8c0@edphgm (view raw or flat)
Thread:
Lists: pgsql-cygwin
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
/usr/share/postgresql/data/postmaster.pid.
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.

Good luck.

----- Original Message -----
From: "João Carlos Fernandes Costa" <joao(dot)costa(at)oni(dot)pt>
To: "'Andy Samuel'" <andysamuel(at)myrealbox(dot)com>
Cc: <pgsql-cygwin(at)postgresql(dot)org>
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
> following:
>
> pg_ctl: Another postmaster may be running.  Trying to start
> postmaster anyway.
> pg_ctl: cannot start postmaster
> Examine the log output.
> [3]+  Done                    ipc-daemon
>
> Any ideas?
>
> Thanks,
> Joao





In response to

pgsql-cygwin by date

Next:From: Dave PageDate: 2002-04-30 08:19:36
Subject: Re: plpgsql won't work
Previous:From: Jason TishlerDate: 2002-04-29 19:27:16
Subject: Re: Cygwin-Postgres-IpcMemoryCreate

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group