1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
# Regular cron jobs for the postgresql package
#
# To ensure proper access rights, 'peer sameuser' access for localhost is
# required in /etc/postgresql/pg_hba.conf. This is now the default setting for
# the Debian configuration.
#
# If instead password access for "local" is turned on in
# /etc/postgresql/pg_hba.conf, you must do one of the following:
#
# 1. Create a file containing the username and password in a form that
# can be read into a sh script, like this:
# user=postgres
# password="open sesame"
# 2. Add "-P file" to each do.maintenance command
# 3. Make the file readable by the postgres user only
# ** or **
# 1. Add "-u postgres -p <password>" to each do.maintenance command
# 2. Make this file (that you are looking at now) readable by the root
# user only
#
# but neither of these are very secure, nor do I (the Debian maintainer)
# recommend them.
0 4 * * * postgres [ -x /usr/lib/postgresql/bin/do.maintenance ] && /usr/lib/postgresql/bin/do.maintenance -a
|
