X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 29E2452A4F for ; Mon, 21 Mar 2005 13:34:23 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89341-03 for ; Mon, 21 Mar 2005 13:34:14 +0000 (GMT) Received: from mout.perfora.net (mout.perfora.net [217.160.230.41]) by svr1.postgresql.org (Postfix) with ESMTP id 2A60D563DD for ; Mon, 21 Mar 2005 13:34:13 +0000 (GMT) Received: from ool-182c7886.dyn.optonline.net[24.44.120.134] (helo=[192.168.2.18]) by mrelay.perfora.net with ESMTP (Nemesis), id 0MKyxe-1DDN2t1bYk-00088s; Mon, 21 Mar 2005 08:34:15 -0500 Mime-Version: 1.0 (Apple Message framework v619.2) In-Reply-To: <20050321131047.93504.qmail@web53406.mail.yahoo.com> References: <20050321131047.93504.qmail@web53406.mail.yahoo.com> Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Matthew Terenzio Subject: Re: PHP and Postgres setup Date: Mon, 21 Mar 2005 08:34:14 -0500 To: pgsql-php@postgresql.org X-Mailer: Apple Mail (2.619.2) X-Provags-ID: perfora.net abuse@perfora.net login:55dcc513cc7db400396c2523adeeb8ca X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/59 X-Sequence-Number: 3074 On Mar 21, 2005, at 8:10 AM, germ germ wrote: > > What do I need to configure in order for Appache and > Postgres to be able to talk back and forth? A couple things need to be done. It would help if you stated where and what the failure message was. If you haven't gotten that far then start with these items. 1. Check to see if you started postgres with a -i flag. this alows it to receive connections over the internet. 2.Also, in pg_hba.conf you must make sure you are allowing connections from the web server host. If that is the local host, you should be okay if you can already connect with the given user and pass you are going to use inside the PHP scripts. Restart postgres if you change this file. remember the -i again. 3. And you must have PHP compiled with postgres support. You don't really need to change Apache. At least it's not necessary to start making connections to the DB.