Debian Bug report logs - #22597
postgresql: postgreql crontab entry doesn't work w. anacron

version graph

Package: postgresql; Maintainer for postgresql is Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org>; Source for postgresql is src:postgresql-common (PTS, buildd, popcon).

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

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


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):

From: upp105@ibm.rhrz.uni-bonn.de
To: submit@bugs.debian.org
Subject: postgresql: postgreql crontab entry doesn't work w. anacron
Date: 18 May 1998 16:36:55 -0000
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):

From: "Oliver Elphick" <olly@lfix.co.uk>
To: upp105@ibm.rhrz.uni-bonn.de, 22597@bugs.debian.org
Subject: Re: Bug#22597: postgresql: postgreql crontab entry doesn't work w. anacron
Date: Mon, 18 May 1998 21:14:18 +0200
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):

From: "Oliver Elphick" <olly@lfix.co.uk>
To: upp105@ibm.rhrz.uni-bonn.de, 22597@bugs.debian.org
Subject: Re: Bug#22597: postgresql: postgreql crontab entry doesn't work w. anacron
Date: Fri, 22 May 1998 10:09:43 +0200
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.