Postgresql Schema / pg_dump issue


Jan 13, 2006
I have been searching for an answer to this issue for a while and can't for the life of me find anyone else that has had a similar problem. Well either that or I am using the wrong terms.

One of my servers appears to have an issue with Postgresql which has gone undetected long enough so that all backups now include the issue. (before I get asked to install a backup)

It is a strange one where pg_dump will no longer work, and all databases show two (2) public schemas. Attached is a screen shot to show what I mean. The error on the backup scripts is now pg_dump: query to obtain list of schemas failed: ERROR: more than one row returned by a subquery used as an expression

The really weird thing is that the database read/write/delete actions still work fine.

Has anyone else experienced this issue (and solved it) or does any one have some tips on how I can solve it. Any help/pointers appreciated.