SCM

[#1011137] csvlog support broken for PostgreSQL >= 9.0

View Trackers | Bugs | Download .csv | Monitor

Date:
2011-12-20 14:02
Priority:
3
State:
Open
Submitted by:
Laurenz Albe (albe)
Assigned to:
Nobody (None)
Category:
Group:
Resolution:
None
 
Summary:
csvlog support broken for PostgreSQL >= 9.0

Detailed description
In PostgreSQL 9.0, the format for csvlog log files changed:
a new column "application_name" was appended.

This makes pgFouine gag with the following message:

pgFouine did not find any valid PostgreSQL log line in your log file:
* check that PostgreSQL uses an english locale for logging (lc_messages in your postgresql.conf),
* check that you use the -logtype option (syslog, stderr) according to your log file,
* if you use syslog and log_line_prefix, check that your log_line_prefix has a trailing space,
* if you use stderr, check that your log_line_prefix is of the form '%t [%p]: [%l-1] '.
If you think your log file and your options are correct, please contact the author (gsmet on #postgresql@freenode or guillaume-pg at smet dot org).

Followup

No Followups Have Been Posted

Attached Files:

Changes:

No Changes Have Been Made to This Item

Powered By FusionForge