Package: postgresql-common
Version: 94lenny1
Severity: normal
Tags: patch

Hello,

The postgresql-common package includes logrotate rules to rotate the logs of
the PostgreSQL server, that is provided by the postgresql-VERSION package.

When someone installs the server postgresql-VERSION, postgresql-common comes as
a dependency, and the server logs get rotated, which is fine. Now, when someone
uninstalls postgresql-VERSION, or installs only postgresql-common for any
reason, the logrotate rules are installed whereas the server is not, and of
course does not generate any log. Thus, logrotate tries to rotate unexistant
logs, fails, and generates annoying error email messages.

To fix that, I suggest to move the logrotate rule file from postgresql-common
to postgresql-VERSION:
    mv postgresql-common-105/debian/postgresql-common.logrotate 
postgresql-8.4-8.4.2/debian/postgresql-8.4.logrotate

As this bug affects both packages and should be fixed in a coordinated way, I
shall clone it and reassign the clone to postgresql-8.4. I attach the logrotate
rules file for convenience.

Regards,

-- 
Tanguy Ortolo

-- System Information:
Debian Release: 5.0.4
  APT prefers stable
  APT policy: (990, 'stable'), (60, 'testing'), (50, 'unstable'), (1, 
'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.32-trunk-amd64 (SMP w/2 CPU cores)
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages postgresql-common depends on:
ii  adduser                       3.110      add and remove users and groups
ii  debconf [debconf-2.0]         1.5.24     Debian configuration management sy
ii  lsb-base                      3.2-20     Linux Standard Base 3.2 init scrip
ii  postgresql-client-common      94lenny1   manager for multiple PostgreSQL cl
ii  procps                        1:3.2.7-11 /proc file system utilities
ii  ssl-cert                      1.0.23     simple debconf wrapper for OpenSSL

postgresql-common recommends no packages.

postgresql-common suggests no packages.
/var/log/postgresql/*.log {
       weekly
       rotate 10
       copytruncate
       delaycompress
       compress
       notifempty
       missingok
}

Reply via email to