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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
