export PGPASSWORD=mypassword
Chris
On Thu, 6 Nov 2003, Gerd Terlutter wrote:
> Hi list,
> i've written a script for dumping several databases (mysql + PG), and it
> runs fine. But now i have the problem to convert it into a cron script.
> how can i run pg_dump with password? i found nothing in the manpages
> about pg login and passwords, e.g. on mysql i can use --password=xxx.
> any ideas how todo this?
>
> Greetings,
> Gerd
> --
> --------------------------------------------------------
> # Gerd Terlutter | Mueller+Blanck Software GmbH #
> # Gutenbergring 38 | D-22848 Norderstedt #
> # office:+49 40 500 171-1| fax:+49 40 500 171-71 #
> --------------------------------------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>