On Thu, Mar 21, 2013 at 8:12 PM, <marcelo_matheus@oi.com.br> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7983
> Logged by: Marcelo Nunes
> Email address: marcelo_matheus@oi.com.br
> PostgreSQL version: 9.1.4
> Operating system: Linux Red Hat 6
> Description:
>
> Hello, good afternoon.
>
> When trying to run a batch in pgAgent the following error occurs.
>
> DEBUG: Checking for jobs to run
> DEBUG: Sleeping... sh: /tmp/pga_GvQxqM/5_9.scr: Permission denied
> DEBUG: Clearing inactive connections
> DEBUG: Connection stats: total - 1, free - 0, deleted - 0
> DEBUG: Checking for jobs to run
> DEBUG: Sleeping...
>
> I have no idea what may be happening. The / tmp is allowed for everyone.
Is /tmp mounted with the noexec option?
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company