Re: PG_DUMP without asking password

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(at)greatgulfhomes(dot)com
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