Hm, depends on how the security settings of the database are set. For local users you could set in the pg_hba.conf ident as authentication method. Then they won't need a password anymore.
See the pg_hba.conf documentation for more infos.
Another way could be to execute the dump script under a privileged user. For my machines here, the user postgres can dump all databases without entering a password.
If you backup your database via a cron job started by root, you can simply do a su postgres -c ... to run the backupjob under user postgres.
-- Matthias
Hi,
is there a way to backup the database thanks a command script, without postgresql requesting the user password ?
thanks a lot,
Alain
