From: | "Oakley " <oakerz(at)eudoramail(dot)com> |
---|---|
To: | "Postgres Mailing List" <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_dump problem |
Date: | 2000-07-27 14:53:45 |
Message-ID: | MPEIKMAHKNFPBAAA@shared1-mail.whowhere.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Using postgres 7.0.2, I am trying to dump my database for archiving the current setup and information that is in it. (surprise there 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 specified directory, but it has "0" size and I never return to prompt unless I hit Ctrl-C. If I leave off the redirect and have 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 still wont work. I have tried to do it as root *and* as postgres - neither of those work either. What exactly am I doing wrong here?
Thanks
Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com
From | Date | Subject | |
---|---|---|---|
Next Message | Merlijn van der Mee | 2000-07-27 15:35:16 | Re: pg_dump problem |
Previous Message | bmccoy | 2000-07-27 13:55:48 | Re: Re: psotgresql history function |