BUG #7983: Problem with pgAgent.

On Fri, Mar 22, 2013 at 5:12 AM, <marcelo_matheus@oi.com.br> wrote:

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.

Isn't this bug something related with pgAdmin?
You should perhaps report this bug to their dedicated ML instead:
http://www.pgadmin.org/support/list.php
--
Michael

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

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

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

On Fri, Mar 22, 2013 at 11:58 AM, Marcelo Matheus
<marcelo_matheus@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

Good afternoon, Dave.

The output of led mount brings the following about the / tmp:

/dev/mapper/vg_vmpjebdh2-LogVol01 on /tmp type ext4
(rw,noexec,nosuid,nodev,noat
ime)
Thanks,
Marcelo Matheus

--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-7983-Problem-with-pgAgent-tp5749215p5749308.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

Hi

On Fri, Mar 22, 2013 at 2:23 PM, Marcelo Matheus
<marcelo_matheus@oi.com.br> wrote:

Good afternoon, Dave.

The output of led mount brings the following about the / tmp:

/dev/mapper/vg_vmpjebdh2-LogVol01 on /tmp type ext4
(rw,noexec,nosuid,nodev,noat
ime)

That's likely the issue then - you need to mount /tmp without the
noexec option for pgAgent to be able to work.

--
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

Good afternoon, Dave.

That was it, bingo!

Thank you for your help.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-7983-Problem-with-pgAgent-tp5749215p5749598.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