Debian Bug report logs -
#22597
postgresql: postgreql crontab entry doesn't work w. anacron
Reported by: upp105@ibm.rhrz.uni-bonn.de
Date: Mon, 18 May 1998 16:48:05 UTC
Severity: normal
Found in version 6.3.2-8
Done: unknown
Bug is archived. No further changes may be made.
Toggle useless messages
Report forwarded to debian-bugs-dist@lists.debian.org, Oliver Elphick <Oliver.Elphick@lfix.co.uk>
:
Bug#22597
; Package postgresql
.
(full text, mbox, link).
Acknowledgement sent to upp105@ibm.rhrz.uni-bonn.de
:
New bug report received and forwarded. Copy sent to Oliver Elphick <Oliver.Elphick@lfix.co.uk>
.
(full text, mbox, link).
Message #5 received at submit@bugs.debian.org (full text, mbox, reply):
Package: postgresql
Version: 6.3.2-8
The crontab entry for postgresql doesn't fit in the new debian
crontab scheme with scripts in cron.daily etc. For users which
aren't running their machine all night long and running anacron,
the script will never be executed.
I propose something like
'su postgres -c "/usr/lib/postgresql/bin/do.maintenance"'
in cron.daily and the same with "-a" in cron.weekly (if this doesn't
conflict).
Thanks for your great work, greetings
joachim
-- System Information
Debian Release: 2.0 (frozen)
Kernel Version: Linux wabe.in-bonn.de 2.0.33 #1 Tue Mar 3 19:27:26 CET 1998 i586 unknown
Versions of the packages postgresql depends on:
ii libc6 2.0.7pre1-4 The GNU C library version 2 (run-time files)
ii libpgsql 6.3.2-8 Shared library for PostgreSQL
ii libreadlineg2 2.1-9 GNU readline and history libraries, run-time
ii ncurses3.4 1.9.9g-8.2 Video terminal manipulation - shared librari
ii tcl8.0 8.0p2-3 The Tool Command Language (TCL) v8.0 - Run-T
ii tk8.0 8.0p2-4 The Tk toolkit for TCL and X11 v8.0 - Run-Ti
ii xlib6g 3.3.2.1-1 shared libraries required by X clients
ii libpgsql 6.3.2-8 Shared library for PostgreSQL
ii debianutils 1.9 Miscellaneous utilities specific to Debian.
--- Begin /etc/postgresql/postmaster.init (modified conffile)
POSTGRES_HOME=`grep '^postgres:' /etc/passwd | awk -F: '{print $6}'`
if [ -z "$POSTGRES_HOME" ]
then
POSTGRES_HOME=/var/postgres
fi
PGALLOWTCPIP=yes
--- End /etc/postgresql/postmaster.init
Information forwarded to debian-bugs-dist@lists.debian.org, Oliver Elphick <Oliver.Elphick@lfix.co.uk>
:
Bug#22597
; Package postgresql
.
(full text, mbox, link).
Acknowledgement sent to "Oliver Elphick" <olly@lfix.co.uk>
:
Extra info received and forwarded to list. Copy sent to Oliver Elphick <Oliver.Elphick@lfix.co.uk>
.
(full text, mbox, link).
Message #10 received at 22597@bugs.debian.org (full text, mbox, reply):
upp105@ibm.rhrz.uni-bonn.de wrote:
>Package: postgresql
>Version: 6.3.2-8
>
>The crontab entry for postgresql doesn't fit in the new debian
>crontab scheme with scripts in cron.daily etc. For users which
>aren't running their machine all night long and running anacron,
>the script will never be executed.
>
>I propose something like
>'su postgres -c "/usr/lib/postgresql/bin/do.maintenance"'
>in cron.daily and the same with "-a" in cron.weekly (if this doesn't
>conflict).
Well, the trouble is that it would run twice once a week, and with a big
database it could take a long time.
Again, some users might want to modify it to run more often; it's a
lot easier to modify an exiting entry in /etc/cron.d
As far as I am aware, cron.d crontabs are a supported part of Debian.
Your proposal amounts to a policy statement that cron.d should not be
used. I think you should put this to debian-policy for discussion.
I think that anyone who doesn't leave his machine on all the time should
be running anacron.
(If I am breaking any policy here, please tell me the reference.)
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"For to me to live is Christ, and to die is gain."
Philippians 1:21
Information forwarded to debian-bugs-dist@lists.debian.org, Oliver Elphick <Oliver.Elphick@lfix.co.uk>
:
Bug#22597
; Package postgresql
.
(full text, mbox, link).
Acknowledgement sent to "Oliver Elphick" <olly@lfix.co.uk>
:
Extra info received and forwarded to list. Copy sent to Oliver Elphick <Oliver.Elphick@lfix.co.uk>
.
(full text, mbox, link).
Message #15 received at 22597@bugs.debian.org (full text, mbox, reply):
upp105@ibm.rhrz.uni-bonn.de wrote:
>Package: postgresql
>Version: 6.3.2-8
>
>The crontab entry for postgresql doesn't fit in the new debian
>crontab scheme with scripts in cron.daily etc. For users which
>aren't running their machine all night long and running anacron,
>the script will never be executed.
In my last message I misunderstood what you had been saying; of course,
you *are* running anacron.
In that case, I think that this bug really belongs to anacron, which ought
to have some means of dealing with /etc/cron.d crontabs.
I propose to reassign the bug to anacron. What do you think?
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"We are troubled on every side, yet not distressed; we
are perplexed, but not in despair; persecuted, but not
forsaken; cast down, but not destroyed; Always bearing
about in the body the dying of the Lord Jesus, that
the life also of Jesus might be made manifest in our
body." II Corinthians 4:8-10
Send a report that this bug log contains spam.
Debian bug tracking system administrator <owner@bugs.debian.org>.
Last modified:
Thu Mar 28 12:38:34 2024;
Machine Name:
buxtehude
Debian Bug tracking system
Debbugs is free software and licensed under the terms of the GNU
Public License version 2. The current version can be obtained
from https://bugs.debian.org/debbugs-source/.
Copyright © 1999 Darren O. Benham,
1997,2003 nCipher Corporation Ltd,
1994-97 Ian Jackson,
2005-2017 Don Armstrong, and many other contributors.