A. Kretschmer wrote:
May 11 01:36:46 pgsql pgsql[73794]: [7-3] STATEMENT: select count(*)
from forum_msg where grp_id=6709 (200 ok) ACCEPTED and is_blocked='f'
Are there any ways to log database, to which invalid query was issued ?
Sure:
log_line_prefix = '%t ' # special values:
# %u = user name
# %d = database name
Thank you. Somehow I've missed this line in the manual.
> Do you know pgfouine?
http://pgfouine.projects.postgresql.org/
Thanks for the hint. I've looked at it. Also looked at tail_n_mail
(http://bucardo.org/downloads/tail_n_mail.pl ), but this may be too
much for us. Especially, having php on db server is not desirable. Grep
may be my best friend.
--
С уважением,
Александр Пыхалов,
системный администратор ЮГИНФО ЮФУ.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
