Re: Having problem with postgresql configuration (template1 doesn't - Mailing list pgsql-admin

From Tom Lane
Subject Re: Having problem with postgresql configuration (template1 doesn't
Date
Msg-id 15926.1108930090@sss.pgh.pa.us
Whole thread Raw
In response to Re: Having problem with postgresql configuration (template1 doesn't  (Vinicius <cviniciusm@terra.com.br>)
Responses Re: Having problem with postgresql configuration (template1 doesn't  (Vinicius <cviniciusm@terra.com.br>)
List pgsql-admin
Vinicius <cviniciusm@terra.com.br> writes:
> I tryed to create another data dir because I don't have the template1
> database.

I think you got bit by one of the early-FC3 selinux policy bugs; see
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=142607
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=143208

You probably want to rm -rf /var/lib/pgsql/data/ and try again
after making sure (a) you have the latest postgres and selinux
packages and (b) you've done restorecon on /var/lib/pgsql and
/var/log/pgsql.

            regards, tom lane

pgsql-admin by date:

Previous
From: Vinicius
Date:
Subject: Re: Having problem with postgresql configuration (template1 doesn't
Next
From: Bruce Momjian
Date:
Subject: Re: Postgres crashed on invalid IP entry in pg_hba.conf