Re: pg_dump + cronjob

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Gerd Terlutter <gerd(at)MplusB(dot)de>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: pg_dump + cronjob
Date: 2003-11-06 15:04:05
Message-ID: 20031106230354.X39902-100000@houston.familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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
>

In response to

Browse pgsql-php by date

  From Date Subject
Next Message Daniel Struck 2003-11-06 15:52:10 Re: Reducing duplicated business rules
Previous Message Bruno Wolff III 2003-11-06 15:00:51 Re: pg_dump + cronjob