You should do
/usr/local/pgsql/bin/pg_dump -u dbname -f /some_directory/dbname.dump
> 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?
> 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
Email: M(dot)vanderMee(at)amc(dot)uva(dot)nl tel. +31-20-5668601
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?
In response to
pgsql-general by date
|Next:||From: Philip Warner||Date: 2000-07-27 15:46:29|
|Subject: ISO Fonts for DocBook?|
|Previous:||From: Oakley ||Date: 2000-07-27 14:53:45|
|Subject: pg_dump problem|