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