From: | Joo 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'" <pgsql-cygwin(at)postgresql(dot)org> |
Subject: | Re: accessing a db |
Date: | 2002-05-02 13:09:32 |
Message-ID: | 5AFAC06B34602947BDB5C0076C179CBC1B661C@excalr01.oni.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
Andy,
Thanks a lot for your help. Everything is working great.
Joao
-----Original Message-----
From: Andy Samuel [mailto:andysamuel(at)myrealbox(dot)com]
Sent: tera-feira, 30 de Abril de 2002 3:33
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [CYGWIN] accessing a db
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: "Joo 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Butler | 2002-05-02 23:22:28 | Fw: make errors building libpqdll.lib |
Previous Message | Rob Butler | 2002-05-02 00:47:27 | make errors building libpqdll.lib |