PostgreSQL 9.3 logging: separate log messages

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi!

What is the proper way to separate queries from other messages while logging?

For example:

I have 'log_min_duration_statement' parameter in postgresql.conf . Therefore I get postgresql system messages and slow queries in one log file /var/log/postgresql/postgresql-9.3-main.log . 

In order to simplify further reading I'd like to get slow queries in /var/log/postgresql/postgresql-slowqueries.log and all the rest in /var/log/postgresql/postgresql.log. 

I tried to implement this by means of rsyslog but didn't manage to get any decent result. 

Any help will be greatly appreciated :)

--
Best regards,
Sergey Arlashin







-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin





[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux