---
name: "pgsql2dlf"
section: "1"
platform: "linux"
package: "lire"
version: "2.1.1-8"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/pgsql2dlf"
---

# pgsql2dlf(1)

convert pgsql logfiles to dlf format

## NAME

pgsql2dlf - convert pgsql logfiles to dlf format

## SYNOPSIS

**pgsql2dlf**

## DESCRIPTION

**pgsql2dlf** converts a PostgreSQL query log file to DLF format.  Information on PostgreSQL can be found on http://www.postgresql.org/. 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.

## EXAMPLES

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
```

## NOTES

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

## SEE ALSO

[**psql**(1)](/psql/1.md), [**postmaster**(1)](/postmaster/1.md), **postgresql.conf**(5)

## VERSION

`$Id:` pgsql2dlf.in,v 1.12 2006/07/23 13:16:33 vanbaal Exp $

## COPYRIGHT

Copyright (C) 2002 Stichting LogReport Foundation LogReport@LogReport.org

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 http://www.gnu.org/copyleft/gpl.html.

## AUTHOR

Wessel Dankers \<wsl@logreport.org\>