Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

pg_dumpall: query failed: ERROR: permission denied for relation pg_shadow

Discussion in 'General Discussion' started by PondRicefied, May 22, 2007.

  1. PondRicefied

    PondRicefied Well-Known Member

    Joined:
    Dec 13, 2004
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    156
    When Export (export.php) of phpPgAdmin is run, this errors happen.

    -------------------------------------
    pg_dumpall: query failed: ERROR: permission denied for relation pg_shadow
    pg_dumpall: query was: SELECT usename, usesysid, passwd, usecreatedb, usesuper, valuntil FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0')
    -------------------------------------

    Why? Please help.

    phpPgAdmin's version is 4.0X.
    postgresql's version 7.4.X.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 PondRicefied, May 22, 2007
    Last edited: May 23, 2007
  2. onknown

    onknown Member

    Joined:
    Feb 1, 2008
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    Ukraine
    the same problem:

    My test cript:
    any ideas?
     
  3. onknown

    onknown Member

    Joined:
    Feb 1, 2008
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    Ukraine
    The problem is user doesn't have any privileges to access tables.
    If I am adding privileges for database through PHPPgAdmin all is working fine.
    So, why when I adding user to database via cpanel it doesn't give me option to choose privileges?

    P.S. Sorry for my English
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice