Debian Etch pg_dumpall cron problem

Debian Etch default postgresql's superuser is postgres. And cron run as root.
Hence, pg_dumpall not working as expected in cron job. Workaround is to create user name root with superuser privilege.


postgres# create role root with superuser login


p/s: you have to create database root