Re: Passwords and batch processes (was Re: Problem with Dump)

7.3 will have a password file read from the user's home directory that
will handle this; it can support multiple usernames in the same file.

PGPASSWORD is documented, but in libpq, which is clearly not enough
because something effects libpq by default is used by all the apps that
use libpq, which is almost everything.

---------------------------------------------------------------------------

David F. Skoll wrote:
> On Fri, 23 Aug 2002, Ian Barwick wrote:
>
> > AFAIK utilities such as pg_dump prompt for the password but
> > won't accept it as a command line option, which makes password-based
> > authentication almost unusable when calling these utilities from a script.
>
> This really should be Question #1 in the FAQ.
>
> You can set the environment variable PGPASSWORD to the password, and avoid
> prompts. This assumes the same username/password has access to all the
> databases for pg_dumpall.
>
> I didn't find this documented anywhere. It probably is, but somewhere
> buried...
>
> --
> David.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073