On 7th of September, Jeff Davis committed patch:
Add log_line_prefix option 'n' for Unix epoch.
Prints time as Unix epoch with milliseconds.
Tomas Vondra, reviewed by Fabien Coelho.
Continue reading Waiting for 9.6 – Add log_line_prefix option ‘n' for Unix epoch.
After loooong pause, adding next (well, second) post to the “series“. This time, I'd like to describe how logging works. And I don't mean binary logging (WAL), but the log for us, humans, to read.
Before I will go to the postgresql.conf options, let me first describe what happens when PostgreSQL wants to log something.
Continue reading Understanding postgresql.conf : log*
On 28th of November Tom Lane committed patch by Dave Page, which adds new capability to system monitoring and logging:
Add support for an application_name parameter, which is displayed in
pg_stat_activity and recorded in log entries.
Dave Page, reviewed by Andres Freund
Continue reading Waiting for 8.5 – Application name reporting