Re: PHP and Postgres setup

From: Matthew Terenzio <matt(at)jobsforge(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: Re: PHP and Postgres setup
Date: 2005-03-21 13:34:14
Message-ID: f8d92a49d6efe8df74bfe74991f02b92@jobsforge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-php


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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Ben-Nes 2005-03-21 14:19:24 Re: Installing PostgreSQL in Debian
Previous Message germ germ 2005-03-21 13:10:46 PHP and Postgres setup

Browse pgsql-php by date

  From Date Subject
Next Message Michael Fuhr 2005-03-21 16:15:55 Re: PHP and Postgres setup
Previous Message germ germ 2005-03-21 13:10:46 PHP and Postgres setup