postgres erros on RHEL 4

["Indunil Jayasooriya" <indunil75@xxxxxxxxx>]

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:12PM

SQL | Find | Logout

phpPgAdmin:

PostgreSQL?:

SQL error:

ERROR:  relation "pg_user" does not exist

In statement:
SELECT usesuper FROM pg_user WHERE usename='test'

Databases ?

Account ?

Export

Reports

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
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos