From: johann at 2ndquadrant.com (Johann 'Myrkraverk' Oskarsson) Date: Fri, 18 Feb 2011 15:05:10 -0000 Subject: [Pljava-dev] Problems with SELinux and PL/Java In-Reply-To: <3A59BB6451C972429019B12996F92DAD02C207C9@frodo.zbw-nett.zbw-kiel.de> References: <3A59BB6451C972429019B12996F92DAD02C207C9@frodo.zbw-nett.zbw-kiel.de> Message-ID: Hi, On Fri, 18 Feb 2011 09:07:40 -0000, Riese Wolfgang wrote: > So far the only partly working solution I've found is putting the jars > in the /var/lib/pgsql/data/ directory, and I mean putting them there, > symbolic links didn't work for me. Usually jars are put in the database with the sqlj.install_jar() function, but I presume you have a reason to have them elsewhere? > Since I don't want to have the same files in many locations I'd > appreciate any hints on rules/file rights for SELinux, to solve this > problem. The user/role the Postgres server is running as will need read access to these files. If you can read these files as the postgres user (as it's traditionally called) and it still doesn't work with SELinux on then you need to somehow tune the server process rights. Sadly I have no idea how to configure SELinux itself. -- Johann Oskarsson http://www.2ndquadrant.com/ |[] PostgreSQL Development, 24x7 Support, Training and Services --+-- | Blog: http://my.opera.com/myrkraverk/blog/