# 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
