You should do
/usr/local/pgsql/bin/pg_dump -u dbname -f /some_directory/dbname.dump
Merlijn
>
> 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
itstill wont work. I have tried to do it as root *and* as postgres - neither of those work either. What exactly am I
doingwrong here?
>
> Thanks
>
> Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com
--
Merlijn van der Mee - Bioinformatician
Academic Medical Centre - Amsterdam
Bioinformatics Laboratory
Email: M.vanderMee@amc.uva.nl tel. +31-20-5668601
-
Version: 3.1
GCS d- s+:- a- C+++ UL++ P++++ L+++ E---- W++ N o-- K- w---
O M-- V-- PS+++ PE- Y+ PGP+ t+ 5 X- R+ tv-- b+ DI-- D++
G e* h- r--- y?
--