Re: pg_dump problem

Andrew Sullivan wrote:
[pg_dump problem]
> If you just type the username and password after that, you'll get the
> output you want.  Problem is that you're redirecting all output to a
> file, and that includes the username and password prompts.
>
> In 7.x versions, this appears to be fixed using the '-f' switch:
>
>     mymachine:~$ pg_dump -u [database] -f [somefile]

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

-Kyle