We have huge amount of logs files and when using syslog all logs go to journal and journal cannot handle that amount logs. Then we have found nxlog. It is a good solution and double work. Send pg logs as usual and read the read from the file, filter them and either put them into separate files or to another syslog server. Here is the link. Best ever log collector.
I am using PostgreSQL 9.6.6 on Debian 9 Stretch system. Installed using apt-get. I wonder if I can have two log files. One for complete database server and another for one specific database in the server. I have already read below link, but cannot understand if that is possible, or how. https://www.postgresql.org/docs/9.6/static/runtime-config-logging.html
I appreciate any help.
Regards, Ertan Küçükoğlu
Not sure what you're reasoning may be, but if it's just to be able to do log analysis, there are tools that can do that for you as long as you have the database name in the log_line_prefix. Take a look at pgbadger
