Re: Server instrumentation for 8.1

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de>
Cc: <josh(at)agliodbs(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Server instrumentation for 8.1
Date: 2005-05-12 09:17:00
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE6C7492@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > Not kill -9. Kill -9 is "safe" because it causes a complete
> restart of
> > the postmaster (it's the same as a backend crash, really).
> Kill -INT
> > is also safe, because it does a simlpe query cancel.
>
> I don't recall exactly; AFAIR this was discussed between Dave
> and Tom.
> Actually, *both* should be accessible (maybe with some
> restriction making it difficult to call it from an sql cmd line)

Actually, I take the blame for starging that discussion - it started
when I craeted the pg_cancel_backend / pg_kill_backend questions.

Now, I *want* these functions. But I want them to be safe :-) (I want
kill -TERM on the commandline to be safe as well!)

//Magnus

Browse pgsql-hackers by date

  From Date Subject
Next Message John Hansen 2005-05-12 09:30:13 Re: SQL_ASCII vs. 7-bit ASCII encodings
Previous Message Andrew - Supernews 2005-05-12 09:16:00 Re: Server instrumentation for 8.1