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
[EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
