Re: postmaster does not shut down

I just deleted the pid file and started PG again. I guess closing the window kills it?

John

 Justin Clift <justin@postgresql.org> wrote:

John Smith wrote:
> I can't get pg to shutdown or otherwise respond. I closed the cygwin
> console window and opened another (PG was working fine with the other
> window).
>
> $ pg_ctl status
> pg_ctl: postmaster is running (pid: 1656)
> Command line was:
> /usr/bin/postmaster
>
> $ pg_ctl stop -m immediate
> kill 1656: No such process
> waiting for postmaster to shut down........................
> ......... failed
> pg_ctl: postmaster does not shut down

Hi John,

As a thought, what happens if you try a slightly different syntax of:

$ pg_ctl -m immediate stop

?

Also, does it look like PostgreSQL might be being kept open by a
connection to it from an application or something not closing down?

Regards and best wishes,

Justin Clift

--
"My grand father once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi