pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedaccess log for 1 table
2+ messages / 2 participants
[nested] [flat]
* access log for 1 table
@ 2011-09-12 18:42 Peter Koczan <pjkoczan@gmail.com>
2011-09-13 07:24 ` Re: access log for 1 table Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 1 reply; 2+ messages in thread
From: Peter Koczan @ 2011-09-12 18:42 UTC (permalink / raw)
To: pgsql-admin
Is there any way to set an access log for a specific table?
What I'd like to do is have a record of all access for one table. It
would be nice to do this by raising a notice and having it show up in
syslog. I could use triggers, but I would need to log for SELECT
queries as well. Rules look like like they are not the best way to go
about this, either.
Are there any ideas?
Thanks,
Peter
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: access log for 1 table
2011-09-12 18:42 access log for 1 table Peter Koczan <pjkoczan@gmail.com>
@ 2011-09-13 07:24 ` Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 2+ messages in thread
From: Guillaume Lelarge @ 2011-09-13 07:24 UTC (permalink / raw)
To: Peter Koczan <pjkoczan@gmail.com>; +Cc: pgsql-admin
On Mon, 2011-09-12 at 13:42 -0500, Peter Koczan wrote:
> Is there any way to set an access log for a specific table?
>
> What I'd like to do is have a record of all access for one table. It
> would be nice to do this by raising a notice and having it show up in
> syslog. I could use triggers, but I would need to log for SELECT
> queries as well. Rules look like like they are not the best way to go
> about this, either.
>
Rules are probably not a great way to do this, but actually it's your
only option if you want to trap SELECT.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-09-13 07:24 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-09-12 18:42 access log for 1 table Peter Koczan <pjkoczan@gmail.com>
2011-09-13 07:24 ` Guillaume Lelarge <guillaume@lelarge.info>
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