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
-----Original Message-----Hi,
From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Alain Roger
Sent: Friday, September 22, 2006 1:32 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: [GENERAL] PG_DUMP without asking password
is there a way to backup the database thanks a command script, without postgresql requesting the user password ?
thanks a lot,
Alain
