Re: Checking what is the current query running

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dilipkumar" <dilipkumar_parikh(at)sifycorp(dot)com>
Cc: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>, "Postgres" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Checking what is the current query running
Date: 2006-07-25 15:10:42
Message-ID: 10103.1153840242@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Dilipkumar" <dilipkumar_parikh(at)sifycorp(dot)com> writes:
> Is there any way to log all the queries in 7.1.1 (older release).please =
> help out guys.

The very best advice anyone could give you is to stop using 7.1.anything
and get onto a more modern PG release as soon as possible. 7.1 *will*
eat your data eventually, and even in the 7.1 series, there are later
bug-fix releases than 7.1.1 ...

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message JieJun Xu 2006-07-25 16:37:32 Re: problem backup/restore PSQL DB
Previous Message Aaron Bono 2006-07-25 14:53:28 Re: Out of memory when vacuuming