Search Postgresql Archives

Unable to dump database using pg_dump

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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]
  Powered by Linux