Re: Problem with PostgreSQL

[Stefan Bellon <sbellon@sbellon.de>]

Casey T. Deccio wrote:
> On Thu, 2006-03-16 at 11:37 +0100, Stefan Bellon wrote:
> > Insecure dependency in exec while running with -T switch at
> > /usr/sbin/pg_maintenance line 49. calling vacuumdb on cluster
> > 7.4/main failed

> Seems that the -T switch is new to the /usr/sbin/pg_maintenance
> script. What does line 49 read in your script?

bellonsn@cube:~$ cat -n /usr/sbin/pg_maintenance | head -50 | tail -7
    44          @options = ('--cluster', "$v/$c", '-a');
    45          push @options, '-f' if $full;
    46          push @options, '-z' if $analyze;
    47          push @options, '-v' if $verbose;
    48          push @options, '-q' unless $verbose;
    49          exec '/usr/bin/vacuumdb', @options or
    50              error 'could not execute vacuumdb';
bellonsn@cube:~$ grep -- "-T" /usr/sbin/pg_maintenance
bellonsn@cube:~$ su -
cube:~# grep pg_maintenance /etc/cron.d/postgresql-common
2 0,5,10,15,20 * * 1-6 root if [ -x /usr/sbin/pg_maintenance ]; then
/usr/sbin/pg_maintenance --analyze >/dev/null; fi
# 10 3 * * Sun root if [ -x /usr/sbin/pg_maintenance ]; then
/usr/sbin/pg_maintenance --full --analyze >/dev/null; fi

Any further ideas?

-- 
Stefan Bellon