Hi All,

I set up posgresql on RedHat El4. Below are rpms I installed.

[root@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@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@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:12PMSQLhttp://124.43.200.74/phpPgAdmin/sqledit.php?server=%3A5432&action=sql| Findhttp://124.43.200.74/phpPgAdmin/sqledit.php?server=%3A5432&action=find| Logouthttp://124.43.200.74/phpPgAdmin/servers.php?action=logout&logoutServer=:5432 phpPgAdmin http://124.43.200.74/phpPgAdmin/redirect.php?subject=root: PostgreSQLhttp://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'

Databaseshttp://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 Accounthttp://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 Exporthttp://124.43.200.74/phpPgAdmin/all_db.php?subject=server&action=export&server=%3A5432 Reportshttp://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.