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
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.