Re: pg_log

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrew W(dot) Nosenko" <awn(at)bcs(dot)zp(dot)ua>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_log
Date: 2001-01-17 00:31:45
Message-ID: 15295.979691505@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Andrew W. Nosenko" <awn(at)bcs(dot)zp(dot)ua> writes:
> Question: what is logged in pg_log table and how I can cleanup it?

Transaction commit-status bits, and don't even *think* of touching it.
Easiest way to hose your database that I know of :-(

If it gets big enough to be really annoying, you can
dumpall/initdb/reload. There is no shortcut.

regards, tom lane

In response to

  • pg_log at 2001-01-16 23:57:59 from Andrew W. Nosenko

Responses

  • Re: pg_log at 2001-01-17 08:22:37 from Alfred Perlstein

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-17 00:34:37 Re: pg_log
Previous Message Oliver Elphick 2001-01-17 00:26:22 Re: pg_log