Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Dec 2004
    Posts
    51

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

    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.
    Last edited by PondRicefied; 05-23-2007 at 04:49 AM.
    WHM 11.30.X cPanel 11.30.X
    RHEL5.X

  2. #2
    Member
    Join Date
    Feb 2008
    Location
    Ukraine
    Posts
    13

    Default

    the same problem:

    Warning: pg_query() [function.pg-query]: Query failed: ERROR: permission denied for relation TABLE-NAME in /home/user/public_html/dima-name.com/test.php on line 7
    Query failed: ERROR: permission denied for relation TABLE-NAME
    My test cript:
    <?php

    $dbconn = pg_connect("host=localhost port=5432 dbname=user_db user=user_testik password=xxxxx")
    or die('Could not connect: ' . pg_last_error());

    $query = 'SELECT * FROM TABLE-NAME';
    $result = pg_query($query) or die('Query failed: ' . pg_last_error());
    echo $result;
    ?>
    any ideas?

  3. #3
    Member
    Join Date
    Feb 2008
    Location
    Ukraine
    Posts
    13

    Default

    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

Similar Threads & Tags
Similar threads

  1. cpio: open failed - Permission denied
    By sanjuabrahamk in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 11-26-2009, 10:19 AM
  2. fixeverything, /bin/pwd: failed to stat `.': Permission denied
    By fedlerner in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 04-07-2008, 12:48 PM
  3. /bin/pwd: failed to stat `.': Permission denied
    By speckados in forum cPanel and WHM Discussions
    Replies: 9
    Last Post: 01-30-2008, 02:25 PM
  4. postgresql ERROR: permission denied for relation user
    By edumadma in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 02-06-2007, 12:08 AM
  5. Permission denied: failed to open tmp/
    By pats in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 09-04-2006, 04:40 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube