Debian Bug report logs - #660649
postgresql-common: postgresql does not log to logfile when log_filename is set

version graph

Package: postgresql-common; Maintainer for postgresql-common is Debian PostgreSQL Maintainers <pkg-postgresql-public@lists.alioth.debian.org>; Source for postgresql-common is src:postgresql-common.

Reported by: Christoph Anton Mitterer <calestyo@scientia.net>

Date: Mon, 20 Feb 2012 16:18:02 UTC

Severity: normal

Found in version postgresql-common/128

Reply or subscribe to this bug.

Toggle useless messages

View this report as an mbox folder, status mbox, maintainer mbox


Report forwarded to debian-bugs-dist@lists.debian.org, Martin Pitt <mpitt@debian.org>:
Bug#660649; Package postgresql-common. (Mon, 20 Feb 2012 16:18:05 GMT) Full text and rfc822 format available.

Acknowledgement sent to Christoph Anton Mitterer <calestyo@scientia.net>:
New Bug report received and forwarded. Copy sent to Martin Pitt <mpitt@debian.org>. (Mon, 20 Feb 2012 16:18:05 GMT) Full text and rfc822 format available.

Message #5 received at submit@bugs.debian.org (full text, mbox):

From: Christoph Anton Mitterer <calestyo@scientia.net>
To: Debian Bug Tracking System <submit@bugs.debian.org>
Subject: postgresql-common: postgresql does not log to logfile when log_filename is set
Date: Mon, 20 Feb 2012 17:16:03 +0100
Package: postgresql-common
Version: 128
Severity: normal


Hi.

I've recently reported PostgreSQL issue #6459 (http://archives.postgresql.org/pgsql-bugs/2012-02/msg00113.php).

The documentation of PostgreSQL says, that log_filename is only used
when logging_collector is enabled.

However, when log_filename is set, Debian's logfile
(/var/log/postgresql/<version>-<name>.log) is not used.

Guess this comes from the code in /usr/bin/pg_ctlcluster .

Could you please either adapt this to follow upstream documentation
or "warn" about it in README.Debian?

:)

Thanks,
Chris.




Information forwarded to debian-bugs-dist@lists.debian.org, Debian PostgreSQL Maintainers <pkg-postgresql-public@lists.alioth.debian.org>:
Bug#660649; Package postgresql-common. (Mon, 13 May 2013 10:00:07 GMT) Full text and rfc822 format available.

Acknowledgement sent to Adrian Vondendriesch <Adrian.Vondendriesch@credativ.de>:
Extra info received and forwarded to list. Copy sent to Debian PostgreSQL Maintainers <pkg-postgresql-public@lists.alioth.debian.org>. (Mon, 13 May 2013 10:00:07 GMT) Full text and rfc822 format available.

Message #10 received at 660649@bugs.debian.org (full text, mbox):

From: Adrian Vondendriesch <Adrian.Vondendriesch@credativ.de>
To: 660649@bugs.debian.org
Subject: RE: postgresql-common: postgresql does not log to logfile when log_filename is set
Date: Mon, 13 May 2013 11:57:48 +0200
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

I took a look at PgCommon.pm.

If log_filename is set and loggin_collector is off, in
postgresql.conf, pg_ctlcluster assumes that postgresql has set up his
own logfile. Postgres on the other site ignores log_filename because
logging_collector is set to off.

The responsable lines are these:

    # default log file (only if not expliticly configured in
postgresql.conf)
    unless (exists $postgresql_conf{'log_filename'} ||
        exists $postgresql_conf{'log_directory'} ||
        (defined $postgresql_conf{'log_destination'} &&
            $postgresql_conf{'log_destination'} eq 'syslog')) {
        my $log_symlink = $result{'configdir'} . "/log";
        if (-l $log_symlink) {
            ($result{'logfile'}) = readlink ($log_symlink) =~ /(.*)/;
# untaint
        } else {
            $result{'logfile'} =
"/var/log/postgresql/postgresql-$_[0]-$_[1].log";
        }
    }

Regards

	- Adrian
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJRkLkYAAoJEJg+KbLX08eJTuMIAIIwlne++k6Qo0sbx8a++0xQ
2fKi22NlVHBgLB3ktBy0nu7yh5q3hmp7EeO0VTGutuuUJJ5qxq7++W/gwdakZxFs
xjXyL2uo7L5AlzdvNNQGxqdzjFeZ79U1X15f0JXE2M6FDjfhShN7mRa0NYgVjjj9
BgRvxKDIJzd3FIrqf+5iwRqC5cGCciYKA0MjzDZOhvpifpBVYcHHB5xjrKfssy5j
qpKlTKaMtHIiToAqrnH0iE30cqbhWXyg+Uje7V6wX6btV+vGauUwCCUZB0OGDszk
5+ne9gpJnplKP8v+NLNIFz8NR7oqHLBAifimqF73yNQTbUsi1RdfzU9iodjvPXo=
=eaCy
-----END PGP SIGNATURE-----



Send a report that this bug log contains spam.


Debian bug tracking system administrator <owner@bugs.debian.org>. Last modified: Wed Apr 23 17:44:41 2014; Machine Name: buxtehude.debian.org

Debian Bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.