Re: [GENERAL] Backing up and restoring a database with the SELinux pg_user problem.

2006-07-04 Thread Joseph Kiniry
Hi Tom, Thank you for the very quick response. I'll let Robin followup on this for tonight, as I'm heading to bed after a very long day. On 4 Jul, 2006, at 22:12, Tom Lane wrote: Joseph Kiniry <[EMAIL PROTECTED]> writes: As I said above, I have re-examined, and executed

Re: [GENERAL] Backing up and restoring a database with the SELinux pg_user problem.

2006-07-04 Thread Joseph Kiniry
list and RedHat bugzilla id 149237). Tom and I exchanged some emails about this back in February, the last of which was: On 4 Feb, 2005, at 15:19, Tom Lane wrote: Joseph Kiniry <[EMAIL PROTECTED]> writes: I'm currently blocked on the system catalog schema "pg_catalo

Re: [GENERAL] Backing up and restoring a database with the SELinux pg_user problem.

2005-02-04 Thread Joseph Kiniry
Hello Tom, On Feb 4, 2005, at 12:37 AM, Tom Lane wrote: Joseph Kiniry <[EMAIL PROTECTED]> 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

[GENERAL] Backing up and restoring a database with the SELinux pg_user problem.

2005-02-03 Thread Joseph Kiniry
Hello everyone, I have a Postgresql 7.4 database that was created on a Fedora 3 box *prior* to turning off enforcing mode in SELinux, but then has since been used for some time in permissive mode. Since everything seemed to be working, I never knew there was a problem until I attempted to set u