Skip site navigation (1) Skip section navigation (2)

Re: pg_dump problem

From: Merlijn van der Mee <M(dot)vanderMee(at)amc(dot)uva(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump problem
Date: 2000-07-27 15:35:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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?
> Thanks
> Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at

Merlijn van der Mee - Bioinformatician
Academic Medical Centre - Amsterdam
Bioinformatics Laboratory
Email: M(dot)vanderMee(at)amc(dot)uva(dot)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? 

In response to

pgsql-general by date

Next:From: Philip WarnerDate: 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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group