Hi All, I set up posgresql on RedHat El4. Below are rpms I installed. [root at LinuxBox etc]# rpm -qa |grep postgres postgresql-libs-7.4.16-1.RHEL4.1 postgresql-devel-7.4.16-1.RHEL4.1 postgresql-7.4.16-1.RHEL4.1 postgresql-python-7.4.16-1.RHEL4.1 postgresql-server-7.4.16-1.RHEL4.1 Then, I did below commands to create a user and a database. [root at box root]# su postgres bash-3.1$ createuser -adEP test Enter password for new role: Enter it again: bash-3.1$ createdb -O test testdb CREATE DATABASE bash-3.1$ exit exit Then, I installed phpPgAdmin rpm. [root at LinuxBox etc]# rpm -qa |grep phpPgAdmin phpPgAdmin-4.0.1-1 Then, After I logined to phpPgAdmin via web browser as below http://ipaddress/phpPgAdmin/ Then, I got below erros. *SQL error:* ERROR: relation "pg_user" does not exist *In statement:* SELECT usesuper FROM pg_user WHERE usename='test' PostgreSQL 7.4.16 running on :5432 -- You are logged in as user "test", 11th May, 2007 3:12PMSQL<http://124.43.200.74/phpPgAdmin/sqledit.php?server=%3A5432&action=sql>| Find<http://124.43.200.74/phpPgAdmin/sqledit.php?server=%3A5432&action=find>| Logout<http://124.43.200.74/phpPgAdmin/servers.php?action=logout&logoutServer=:5432> phpPgAdmin <http://124.43.200.74/phpPgAdmin/redirect.php?subject=root>: PostgreSQL<http://124.43.200.74/phpPgAdmin/redirect.php?subject=server&server=%3A5432&> ? <http://124.43.200.74/phpPgAdmin/help.php?help=pg.server&server=%3A5432>: *SQL error:* ERROR: relation "pg_user" does not exist *In statement:* SELECT usesuper FROM pg_user WHERE usename='test' Databases<http://124.43.200.74/phpPgAdmin/all_db.php?subject=server&server=%3A5432> ? <http://124.43.200.74/phpPgAdmin/help.php?help=pg.database&server=%3A5432> Account<http://124.43.200.74/phpPgAdmin/users.php?subject=server&action=account&server=%3A5432> ? <http://124.43.200.74/phpPgAdmin/help.php?help=pg.user&server=%3A5432> Export<http://124.43.200.74/phpPgAdmin/all_db.php?subject=server&action=export&server=%3A5432> Reports<http://124.43.200.74/phpPgAdmin/reports.php?subject=server&server=%3A5432> *SQL error:* ERROR: relation "pg_user" does not exist *In statement:* SELECT pdb.datname AS datname, pu.usename AS datowner, pg_encoding_to_char(encoding) AS datencoding, (SELECT description FROM pg_description pd WHERE pdb.oid=pd.objoid) AS datcomment FROM pg_database pdb, pg_user pu WHERE pdb.datdba = pu.usesysid AND NOT pdb.datistemplate ORDER BY pdb.datname Why . Pls help me to solve this. -- Thank you Indunil Jayasooriya -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos/attachments/20070511/7eb885fa/attachment-0004.html>