[CentOS] PostgreSQL/SELinux Error - relation "pg_catalog.pg_user" does not exist
Aleksandar Milivojevic
amilivojevic at pbl.ca
Mon May 30 14:30:48 UTC 2005
Matt Arnilo S. Baluyos (Mailing Lists) wrote:
> while i can definitely just disable SELinux on this box, i would want
> a more elegant solution that solves this annoying problem. can anyone
> help me on this?
There's several bug report's on Red Hat's Bugzilla about PostgreSQL and
SELinux. You might want to check them out. For starters, there's
annoying bug that you must turn off SELinux (or set it to permissive
mode) when you start PostgreSQL service for the very first time so that
everything initializes correctly. After that you can put it into
enforcing mode again, and it will work OK. If you haven't done that,
you might want to reinitialize your PostgreSQL installation from scratch
(remove everyting from /var/lib/pgsql/data directory).
Also, if your /tmp is on tmpfs, there are couple more issues to address
(if /tmp is simply part of root file system like most people have it,
you shouldn't have problems with it).
--
Aleksandar Milivojevic <amilivojevic at pbl.ca> Pollard Banknote Limited
Systems Administrator 1499 Buffalo Place
Tel: (204) 474-2323 ext 276 Winnipeg, MB R3T 1L7
More information about the CentOS
mailing list