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, whole thread or download thread mbox)
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/'

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.

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-2017 The PostgreSQL Global Development Group