The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Postgresql Schema / pg_dump issue

Discussion in 'General Discussion' started by noosalife, Apr 13, 2011.

  1. noosalife

    noosalife Member

    Jan 13, 2006
    Likes Received:
    Trophy Points:
    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.

    Attached Files:

Share This Page