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 320.1109002505@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
List pgsql-admin
Vinicius <cviniciusm@terra.com.br> writes:
> /var/log/messages shows:
> "...
> Feb 21 09:10:43 ronin kernel: audit(1108987843.094:0): avc:  denied  {
> read } for  pid=6766 exe=/usr/bin/postgres path=/tmp/sh-thd-1108997049
> (deleted) dev=dm-0 ino=1046660 scontext=user_u:system_r:postgresql_t
> tcontext=user_u:object_r:tmp_t tclass=file

> And I still don't get the template1 database.

Sigh.  I coulda sworn I tested this in December, but it's definitely
busted now:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=149237
(I might have messed up by only testing PG 8.0 --- 8.0 does not have
this problem, since initdb is no longer a shell script.)

The short-term workaround is to temporarily disable selinux
(sudo /usr/sbin/setenforce 0) while you initialize the database.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Anjan Dave"
Date:
Subject: pg_clog corrupt, can't start postgres
Next
From: Tom Lane
Date:
Subject: Re: pg_clog corrupt, can't start postgres