Re: pg_terminate_backend - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: pg_terminate_backend
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCEA35541@algol.sollentuna.se
Whole thread Raw
In response to Re: pg_terminate_backend  (Andreas Pflug <pgadmin@pse-consulting.de>)
Responses Re: pg_terminate_backend
Re: pg_terminate_backend
List pgsql-hackers
> >> Since I have a stuck backend without client again, I'll have to
> kill
> >> -SIGTERM a backend. Fortunately, I do have console access to
> that
> >> machine and it's not win32 but a decent OS.
> >>
> >>
> >
> > You do know that on Windows you can use pg_ctl to send a pseudo
> > SIGTERM to a backend, don't you?
> The main issue still is that console access id required, on any OS.

Yeah.
Though for the Windows case only, we could easily enough make it
possible to run pg_ctl kill remotely, since we use a named pipe. Does
this seem like a good or bad idea?

//Magnus



pgsql-hackers by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Bug with initDB under windows 2003
Next
From: Andreas Pflug
Date:
Subject: Re: pg_terminate_backend