Re: Backing up and restoring a database with the SELinux pg_user problem. - Mailing list pgsql-general

From Tom Lane
Subject Re: Backing up and restoring a database with the SELinux pg_user problem.
Date
Msg-id 7595.1107477429@sss.pgh.pa.us
Whole thread Raw
In response to Backing up and restoring a database with the SELinux pg_user problem.  (Joseph Kiniry <kiniry@acm.org>)
Responses Re: Backing up and restoring a database with the SELinux pg_user problem.
List pgsql-general
Joseph Kiniry <kiniry@acm.org> writes:
> Does anyone have any suggestions on this problem? How can I recreate
> pg_user?

Sure, just run the CREATE VIEW command executed by initdb; it's in the
initdb shell script.  Note that all the objects created that way (with
"postgres <<EOF" shell constructs) will be missing --- you'll likely
find you have to create some more missing bits too.

FWIW, I think that the latest selinux-policy and postgresql RPMs should
fix this problem.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Start problem on OSX
Next
From: David Fetter
Date:
Subject: Re: Is there a peer-to-peer server solution with PG?