Re: Really Dumb Question...(Dumping db)

> If you have password authentication on for the other server as well try
> this command instead,
>
> psql -e worldwide -f worldwide.pgdump
>
> where the -f switch tells psql to execute commands contained in a file.
> I just fought with that one today for a bit until I remembered that
> switch.  You should then get a password prompt to enter your password.


Oh, and remember to "fix" the dump file -- it'll contain the username and
password prompts (remember that they were sent to stdout...)

You might consider doing filesystem backups instead of the dump stuff --
it's a great deal easier.

John




--
# John Madden  weez@freelists.org ICQ: 2EB9EA
# FreeLists, Free mailing lists for all: http://www.freelists.org
# UNIX Systems Engineer, Ivy Tech State College: http://www.ivy.tec.in.us
# Linux, Apache, Perl and C: All the best things in life are free!