Re: postgres erros on RHEL 4

["Lamar Owen" <lowen@xxxxxxxx>]

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