Re: pg_dump + cronjob

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
>


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings