pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: bruce <bedouglas@earthlink.net>
To: 'Jean-Christian Imbeault' <jc@mega-bucks.co.jp>
To: christoph.dellavalle@goetheanum.ch
To: 'pgsql-novice' <pgsql-novice@postgresql.org>
Subject: Re: Accessing Postgres db from apache using PHP
Date: Mon, 28 Jul 2003 09:32:16 -0700
Message-ID: <003b01c35525$cf5dfca0$0301a8c0@Mesa.com> (raw)
In-Reply-To: <3F24CEDB.6040300@mega-bucks.co.jp>

hi....

I just searched my drive... I find the following files:
	postgresql
	postgres.conf.sample

I do not find a file --> postgres.conf

Where should it be/reside.... The information in the postgres.conf.sample
has the tcpip_socket parameter !!!

This might be the issue!!!!!!!!!!!!

Thanks

Bruce
bedouglas@earthlink.net


-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Jean-Christian
Imbeault
Sent: Monday, July 28, 2003 12:21 AM
To: christoph.dellavalle@goetheanum.ch; pgsql-novice
Subject: Re: [NOVICE] Accessing Postgres db from apache using PHP


>i then do a:
>	$tmp = "host=localhost dbname=gforge user=gforge
>password=gforge";
>	$conn = @pg_connect($tmp);


Just jumping in here but don't you need to specify the port?

$conn = pg_connect("host=localhost port=5432 dbname=gforge user=gforge");

Also, don't use the @, that way you can see any useful error messages
that are displayed :)

Oh, and you did change the conf file to let postgres use TCP/IP?

tcpip_socket = true
port=5432

Jc



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend




view thread (13+ messages)  latest in thread

Message-ID: <003b01c35525$cf5dfca0$0301a8c0@Mesa.com>
Permalink:  ../003b01c35525$cf5dfca0$0301a8c0@Mesa.com/
Also on:    postgresql.org/message-id/003b01c35525$cf5dfca0$0301a8c0@Mesa.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: bedouglas@earthlink.net, jc@mega-bucks.co.jp, christoph.dellavalle@goetheanum.ch, pgsql-novice@postgresql.org
  Subject: Re: Accessing Postgres db from apache using PHP
  In-Reply-To: <003b01c35525$cf5dfca0$0301a8c0@Mesa.com>
  References: <3F24CEDB.6040300@mega-bucks.co.jp> <003b01c35525$cf5dfca0$0301a8c0@Mesa.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox