Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8A2779FB279 for ; Tue, 31 Oct 2006 01:03:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 49531-01 for ; Tue, 31 Oct 2006 01:03:42 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.188]) by postgresql.org (Postfix) with ESMTP id D13C29FB278 for ; Tue, 31 Oct 2006 01:03:38 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id g2so172817nfe for ; Mon, 30 Oct 2006 21:03:37 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=lbF559dYbk/NJCHu2Wwr3MWaSehq3PKHYkBWOnYj09uR4clXqocla/G9C8/RN/4UYKf4fypbSsVRSzajL+uFkS2YEbK4uuGiCM2n2JyY3IRxT5aumWJh74eTdQ6FYZpP+mRpiRO3nzOmFj0A7YCeRj9YWQaHNYPbnBK6QXkwGAM= Received: by 10.82.98.13 with SMTP id v13mr969464bub; Mon, 30 Oct 2006 21:03:36 -0800 (PST) Received: by 10.82.111.12 with HTTP; Mon, 30 Oct 2006 21:03:36 -0800 (PST) Message-ID: <74721f460610302103n7acea18bna012c3987ea7798a@mail.gmail.com> Date: Tue, 31 Oct 2006 10:33:36 +0530 From: viraj To: pgsql-admin@postgresql.org Subject: [FIXED] Re: can not restart posgresql after dist-upgrade - debian In-Reply-To: <74721f460610300749p5ddc05abib7e915d98140733@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <74721f460610300749p5ddc05abib7e915d98140733@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/215 X-Sequence-Number: 23518 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 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 >