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 }