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: 398056B4.5B78F235@amc.uva.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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. (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

--
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

Browse pgsql-general by date

  From Date Subject
Next Message Philip Warner 2000-07-27 15:46:29 ISO Fonts for DocBook?
Previous Message Oakley 2000-07-27 14:53:45 pg_dump problem