From: pierce at hogranch.com (John R Pierce) Date: Sun, 28 Aug 2011 23:21:53 -0700 Subject: [Pljava-dev] question on reading files using PL/Java In-Reply-To: <1270594531.828544.1314584875392.JavaMail.root@sz0075a.westchester.pa.mail.comcast.net> References: <1270594531.828544.1314584875392.JavaMail.root@sz0075a.westchester.pa.mail.comcast.net> Message-ID: <4E5B3001.8040405@hogranch.com> On 08/28/11 7:27 PM, tjkincaid at comcast.net wrote: > ERROR: java.lang.SecurityException: read on > /home/tomkincaid/pgdevel/pljava/ubiq-aug-2011-aug3.xml d0es that file and all the directories above it have world-read attributes? pljava will be running as the postgresql *server* user, probably 'postgres', not as your local user account, so will only be able to access files that 'postgres' can access. -- john r pierce N 37, W 122 santa cruz ca mid-left coast