[CentOS] PostgreSQL/SELinux Error - relation "pg_catalog.pg_user" does not exist

Mon May 30 14:30:48 UTC 2005
Aleksandar Milivojevic <amilivojevic at pbl.ca>

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