Received: from web1.nexusinternetsolutions.net (web1.nexusinternetsolutions.net [206.47.131.12]) by postgresql.org (Postfix) with SMTP id 2569947510B for ; Fri, 19 Apr 2002 13:39:59 -0400 (EDT) Received: (qmail 87241 invoked from network); 19 Apr 2002 17:52:05 -0000 Received: from unknown (HELO cr159591a) (24.102.18.54) by web1.nexusinternetsolutions.net with SMTP; 19 Apr 2002 17:52:05 -0000 From: "Dave" To: "Josh Berkus" , Subject: Re: Security - local(TRUST) and php/perl access Date: Fri, 19 Apr 2002 13:45:15 -0400 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Archive-Number: 200204/69 X-Sequence-Number: 1093 >Anything running on the same machine, whether a shell, PHP, or Perl, is >covered by the "trust" statement, unless you make the mistake of >routing your connection through an external interface. this is what I was afraid of >However, I strongly reccommend against using "trust" on any public web >server. agreed, thus my concern... it appears however that if everything is set to password (or better) that postgres doesn't start on reboot. the startup script reads case $1 in start) [ -d /usr/local/pgsql/lib ] && /sbin/ldconfig -m /usr/local/pgsql/lib [ -x /usr/local/pgsql/bin/pg_ctl ] && { su -l pgsql -c \ 'exec /usr/local/pgsql/bin/pg_ctl -w start > /usr/local/pgsql/errlog echo -n ' pgsql' } ;; essentially what happens is that the startup waits for the password to be entered, and as such that and any following services in the local/rc directory are never started... it times out after a time (if memory serves). workaround without security ramifications? Dave