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 >