Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id A7DA79FB276 for ; Tue, 3 Oct 2006 11:19:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 07203-10 for ; Tue, 3 Oct 2006 14:19:14 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210]) by postgresql.org (Postfix) with ESMTP id D7E679FA4F4 for ; Tue, 3 Oct 2006 11:19:13 -0300 (ADT) Received: from host3.dynacom.ondsl.gr ([62.103.35.211] helo=ip216.internal.net) by matrix.gatewaynet.com with esmtp (Exim 4.62) (envelope-from ) id 1GUl6x-0006kn-41 for pgsql-admin@postgresql.org; Tue, 03 Oct 2006 17:19:07 +0300 From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: Re: Obtain historial of query's Date: Tue, 3 Oct 2006 17:19:04 +0300 User-Agent: KMail/1.9.3 References: <003001c6e6f4$2925ce30$0d01a8c0@pcsistemas> In-Reply-To: <003001c6e6f4$2925ce30$0d01a8c0@pcsistemas> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200610031719.04598.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/14 X-Sequence-Number: 23317 =CE=A3=CF=84=CE=B9=CF=82 =CE=A4=CF=81=CE=AF=CF=84=CE=B7 03 =CE=9F=CE=BA=CF= =84=CF=8E=CE=B2=CF=81=CE=B9=CE=BF=CF=82 2006 16:59, =CE=BF/=CE=B7 Sistemas = C.M.P. =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5: > 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 (i= f=20 not purged by some periodic task) for these strangely deleted rows. What version of PgSQL do you run? =2D-=20 Achilleas Mantzios