Re: Obtain historial of query's

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Obtain historial of query's
Date: 2006-10-03 14:19:04
Message-ID: 200610031719.04598.achill@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Στις Τρίτη 03 Οκτώβριος 2006 16:59, ο/η Sistemas C.M.P. έγραψε:
> It's posible to obtain querys that user had sent in some date?
> because there are records that had been deleted strangely. And I'd like
> to obtain an historial of sent query's from the users.

What does:
SHOW log_statement;
say?
if it is set to on, then you might stand a chance by examining your logs (if
not purged by some periodic task) for these strangely deleted rows.
What version of PgSQL do you run?
--
Achilleas Mantzios

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message lst_hoe01 2006-10-03 16:03:02 Re: Please. Do cancel my subscription!!
Previous Message Sistemas C.M.P. 2006-10-03 13:59:36 Obtain historial of query's