pgsql2dlf(1) convert pgsql logfiles to dlf format




pgsql2dlf converts a PostgreSQL query log file to DLF format. Information on PostgreSQL can be found on Logging can be enabled in the postgresql.conf file.

The following options should be present at least for this converter to work well:

debug_level = 1

debug_print_parse = on

debug_print_query = on

The generic database dlf format is described in database.xml.


To process a log as produced by PostgreSQL:

 $ pgsql2dlf < /var/log/postgresql.log

pgsql2dlf will be rarely used on its own, but is more likely called by lr_log2report:

 $ lr_log2report pgsql < /var/log/postgresql.log


The parser has been tested for log files from PostgreSQL 7.2.1.


$Id:,v 1.12 2006/07/23 13:16:33 vanbaal Exp $


Copyright (C) 2002 Stichting LogReport Foundation [email protected]

This file is part of Lire.

Lire is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with


Wessel Dankers <[email protected]>