Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-php by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group