pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedObtain 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>
2006-10-03 14:19 ` Re: Obtain historial of query's Achilleas Mantzios <achill@matrix.gatewaynet.com>
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 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>
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