Unable to dump database using pg_dump

From: Adam Dear <adear(at)usnx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Unable to dump database using pg_dump
Date: 2008-06-11 16:28:45
Message-ID: g2oujn$208s$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am migrating to a new server. I am trying to get a dump of my
database to import into postgres 8.1.11 on my new server. When I run
the pg_dump commmand:

pg_dump --clean --file=madison.sql --schema=public -U madisoncounty
madisoncounty

I get this message:

pg_dump: query to obtain list of schemas failed: ERROR: more than one
row returned by a subquery used as an expression

I'm pretty new to postgres, and I'm not sure how to debug / fix this
issue. I did a VACUUM FULL on the server before I tried to do the dump.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2008-06-11 17:31:29 Re: Unable to dump database using pg_dump
Previous Message Selena Deckelmann 2008-06-11 14:15:59 Call for proposals: PDXPUG PgDay at OSCON - proposals due FRIDAY!