[CentOS] postgres erros on RHEL 4

Sat May 12 14:01:59 UTC 2007
Lamar Owen <lowen at pari.edu>

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