Re: [BUGS] BUG #7983: Problem with pgAgent.

2013-03-22 Thread Dave Page
On Thu, Mar 21, 2013 at 8:12 PM,  marcelo_math...@oi.com.br wrote:
 The following bug has been logged on the website:

 Bug reference:  7983
 Logged by:  Marcelo Nunes
 Email address:  marcelo_math...@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


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] BUG #7983: Problem with pgAgent.

2013-03-22 Thread Marcelo Matheus
Hello, Dave.

The pemissões of / tmp are:

[root@vmpjebdh /]# ls -ld /tmp
drwxrwxrwt. 18 root root 4096 Mar 22 12:29 /tmp

Thanks,
Marcelo Matheus



--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/BUG-7983-Problem-with-pgAgent-tp5749215p5749296.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] BUG #7983: Problem with pgAgent.

2013-03-22 Thread Dave Page
On Fri, Mar 22, 2013 at 11:58 AM, Marcelo Matheus
marcelo_math...@oi.com.br wrote:
 Hello, Dave.

 The pemissões of / tmp are:

 [root@vmpjebdh /]# ls -ld /tmp
 drwxrwxrwt. 18 root root 4096 Mar 22 12:29 /tmp

Right, but is it mounted with noexec? Look at the output from the mount command.


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs