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.

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:
    6
    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.
     
    #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:
    1
    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:
    1
    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