Using postgres 7.0.2, I am trying to dump my database for archiving the current setup and information that is in it.
(surprisethere huh?) and when I try:
/usr/local/pgsql/bin/pg_dump -u dbname > /some_directory/dbname.dump
it wont work! It doesnt prompt me for username and passwd or anything, and still creates the dbname.dump file in the
specifieddirectory, but it has "0" size and I never return to prompt unless I hit Ctrl-C. If I leave off the redirect
andhave it print to STDOUT, no problems...
I have done it as myself, as I read in the docs, since the database I am trying to dump has the same name as me, but it
stillwont work. I have tried to do it as root *and* as postgres - neither of those work either. What exactly am I doing
wronghere?
Thanks
Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com