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
}