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

From: Joseph Kiniry <kiniry(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Backing up and restoring a database with the SELinux pg_user problem.
Date: 2005-02-04 00:03:06
Message-ID: 22A18972-9742-421A-A1CE-4CD054E6AAA3@acm.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
up backups a few days later and found that the pg_user table/view did
not exist. Now, I am seemingly unable to backup any database or table,
since any use of pg_dump fails due to the missing pg_user table.

Does anyone have any suggestions on this problem? How can I recreate
pg_user? I would expect this should be possible given there should only
be the default postgres super user and my gforge user installed, and
the latter works fine, as this is a running GForge db that I wish to
shutdown over the weekend and repair.

I have read all prior discussions on the topic on various
postgresql.org mailing lists and none of their suggestions helped me,
nor seemed to help any previously afflicted user. E.g., these threads
http://archives.postgresql.org/pgsql-general/2004-08/msg01286.php
http://archives.postgresql.org/pgsql-sql/2005-01/msg00167.php

I have also read the Fedora 3 bug report on this issue.
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=142607

Thanks very much,
Joe Kiniry

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonel Rienton 2005-02-04 00:17:03 Re: Start problem on OSX
Previous Message Paul Tillotson 2005-02-03 23:27:46 Applications that leak connections