# use /bin/sh to run commands, overriding the default set by cron
SHELL=/bin/sh
# mail any output to `dan', no matter whose crontab this is
MAILTO=dan@langille.org
 
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/usr/X11R6/bin:$HOME/bin; export PATH
 
2      2       *       *       *       ~/bin/backup.sh > ${HOME}/logs/backup.log

[11:34 x8dtu-pg01 dvl ~] % sudo su -l postgres
$ psql postgres
psql (16.8)
Type "help" for help.

postgres=# grant select on all tables    in schema pg_catalog to rsyncer;
grant select on all sequences in schema pg_catalog to rsyncer;
GRANT
GRANT
postgres=# grant select on pg_authid to rsyncer;
GRANT
postgres=# \c freshports.org
You are now connected to database "freshports.org" as user "postgres".
freshports.org=# grant select on all tables    in schema public to rsyncer;
grant select on all sequences in schema public to rsyncer;
GRANT
GRANT
freshports.org=#