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
