I'm running RHEL4, and I just downloaded postgresql-server-7.4.7-2.RHEL4.1 today. I started it, it init'ed the DB, and everything seemed fine. I did an "su - postgres", created a database with createdb, and connected to it using "psql <db_name>". When I try to use any \d command that would tell me anything about a table, I get the error: ERROR: relation "pg_catalog.pg_user" does not exist
OK, I've managed to repair the issue locally, here's the steps I took that I *think* fixed it (I did a few other things, too, but I think they were mostly a no-op): service postgresql stop rm -rf /var/lib/pgsql/data mkdir /var/lib/pgsql/data chmod go-rwx /var/lib/pgsql/data restorecon /var/lib/pgsql/data setenforce 0 su - postgres initdb exit service postgresql start service postgresql stop setenforce 1 service postgresql start I'm not sure that the last little bit of doing the first start before turning back on SELinux is necessary.
Yeah, this sounds exactly like bug #149237. I believe this is fixed (or more accurately, worked around) as of postgresql-7.4.7-3.RHEL4.1. See also bug #143208 *** This bug has been marked as a duplicate of 149237 ***
OK so where is postgresql-7.4.7-3.RHEL4.1? It's not in the errata