pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Obtain historial of query's
2+ messages / 2 participants
[nested] [flat]

* Obtain historial of query's
@ 2006-10-03 13:59  Sistemas C.M.P. <sistemascmp@redynet4.com.ar>
  0 siblings, 1 reply; 2+ messages in thread

From: Sistemas C.M.P. @ 2006-10-03 13:59 UTC (permalink / raw)
  To: pgsql-admin

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.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Obtain historial of query's
@ 2006-10-03 14:19  Achilleas Mantzios <achill@matrix.gatewaynet.com>
  parent: Sistemas C.M.P. <sistemascmp@redynet4.com.ar>
  0 siblings, 0 replies; 2+ messages in thread

From: Achilleas Mantzios @ 2006-10-03 14:19 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-10-03 14:19 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-03 13:59 Obtain historial of query's Sistemas C.M.P. <sistemascmp@redynet4.com.ar>
2006-10-03 14:19 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox