Re: Re: pg_dump problem

On Thu, Jul 27, 2000 at 09:25:17AM -0700, Kyle wrote:

> what if you want to pipe the output to your favorite compression
> utility?  I like doing a weekly:
>  pg_dumpall | bzip2 - > dump.bz2

Debian handles something similar for its nightly do.maintenance
script.  You have to put the password in the cron.d/postgresql file, which
is terrible security practice, but the only way to automate this with
'password' as the authentication method on the local machine.  The
script called by the cron job tests for whether the password is set,
and then passes that on to the postmaster when doing maintenance.

There is an unfortunate side effect, in that you get a daily mail
from cron with the three password prompts.

The better way to do this, I think, is to use some other
authentication method.

--
Andrew Sullivan                                      Computer Services
<sullivana@bpl.on.ca>                        Burlington Public Library
+1 905 639 3611 x158                                   2331 New Street
                                   Burlington, Ontario, Canada L7R 1J4