Search Postgresql Archives
Unable to dump database using pg_dump
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: pgsql-general@xxxxxxxxxxxxxx
- Subject: Unable to dump database using pg_dump
- From: Adam Dear <adear@xxxxxxxx>
- Date: Wed, 11 Jun 2008 11:28:45 -0500
- Organization: Hub.Org Networking Services
- User-agent: Thunderbird 2.0.0.14 (Windows/20080421)
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.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]