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