Re: Troubles with WAL and pg_control - Mailing list pgsql-admin

From Tom Lane
Subject Re: Troubles with WAL and pg_control
Date
Msg-id 12290.1019660019@sss.pgh.pa.us
Whole thread Raw
In response to Troubles with WAL and pg_control  (Rasmus Mohr <rmo@Netpointers.com>)
List pgsql-admin
Rasmus Mohr <rmo@Netpointers.com> writes:
> Hi, we have serious problem with our postgresql db.
> A staling query were killed and all the WAL files were deleted.

Just for the benefit of onlookers: that was a really BAD idea.
The pg_xlog and pg_clog files are not optional; you *will* regret it
if you decide to delete 'em.

BTW, if you want to kill a runaway query, it's usually sufficient
to do "kill -INT" on the specific backend doing the query.  This
executes a query-cancel, which should stop the query fairly quickly
without any damage to the rest of the system.

            regards, tom lane

pgsql-admin by date:

Previous
From: Rasmus Mohr
Date:
Subject: Re: Troubles with WAL and pg_control
Next
From: Denny-Schierz
Date:
Subject: is it a bug?