CentOS - May 2007 - postgres erros on RHEL 4

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

On Friday 11 May 2007, Indunil Jayasooriya wrote:
> *SQL error:*
>
> ERROR:  relation "pg_user" does not exist
Ok, here's a procedure that should correct this.  Note that any existing
data
in the database will be deleted by this procedure (although, if pg_user does 
not exist you have bigger problems, and probably haven't stored any data to 
begin with):

su - 
service postgresql stop
rm -rf /var/lib/pgsql/data/*
setenforce 0
service postgresql start

Then, if you want SELinux enforcing mode, 'setenforce 1' again.  Then
repeat
the setup steps for phpPgAdmin and see if that solves the problem.
-- 
Lamar Owen
Chief Information Officer
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC  28772
(828)862-5554
www.pari.edu