Обсуждение: can not restart posgresql after dist-upgrade - debian
hi all, i'm running postgresql-7.4 on a debian etch box. postgresql was working fine before the dist upgrade (it was sarge). now, when i restart the service it says.. viraj:/var/log/postgresql# pg_ctlcluster 7.4 main reload Insecure directory in $ENV{PATH} while running with -T switch at /usr/bin/pg_ctlcluster line 384. i didn't change permission of postgresql directories. and the configuration files are untouched. can somebody shed some light on this? thank you ~virajj
hi all, manged to overcome the issue. the problem was with the shebang line of the pg_ctlcluster script. i replaced the switch '-T' with a '-t', turning Perl's 'tainting checks' to 'tainting warnings'. http://www252.pair.com/comdog/mastering_perl/Chapters/03.taint-checking.html thanks ~viraj p.s. turning security off is never a solution. On 10/30/06, viraj <kalinga@gmail.com> wrote: > hi all, > i'm running postgresql-7.4 on a debian etch box. postgresql was > working fine before the dist upgrade (it was sarge). > > now, when i restart the service it says.. > > viraj:/var/log/postgresql# pg_ctlcluster 7.4 main reload > Insecure directory in $ENV{PATH} while running with -T switch at > /usr/bin/pg_ctlcluster line 384. > > i didn't change permission of postgresql directories. and the > configuration files are untouched. can somebody shed some light on > this? > > > thank you > > > ~virajj >
viraj wrote: > hi all, > manged to overcome the issue. the problem was with the shebang line of > the pg_ctlcluster script. > > i replaced the switch '-T' with a '-t', turning Perl's 'tainting > checks' to 'tainting warnings'. Just FYI, pg_ctlcluster is a Debian-specific program, so you should take this bug report with them. Maybe this particular problem is already fixed in a later revision of the Debian packages; it's too serious for it to be overlooked for too long. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.