If you run it on the same server, with a user who has permission to
access the db using ident (e.g. user "postgres"),
i.e. you have a pg_hba.conf entry like:
local all postgres ident sameuser
Then pg_dump and pg_dumpall will not require a password.
Alternatively, you can create a .pgpass file in the users home directory
(if ident not available, but you *need* to think about the permissions
of this file and ramifications)
Terry
Terry Fielder
terry@xxxxxxxxxxxxxxxxxx
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Alain Roger wrote:
Hi,
is there a way to backup the database thanks a command script, without
postgresql requesting the user password ?
thanks a lot,
Alain
