Re: accessing a db
От | Andy Samuel |
---|---|
Тема | Re: accessing a db |
Дата | |
Msg-id | 004301c1efef$4c1aede0$0200a8c0@edphgm обсуждение исходный текст |
Ответ на | Re: accessing a db (João Carlos Fernandes Costa <joao.costa@oni.pt>) |
Список | 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.costa@oni.pt> To: "'Andy Samuel'" <andysamuel@myrealbox.com> Cc: <pgsql-cygwin@postgresql.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
В списке pgsql-cygwin по дате отправления: