Re: How to connect using pg_connect function from php3 ?

On Wed, 26 Apr 2000, Luiz Antonio wrote:

> Hello list!!!
> I�ve installed the postgresql 6.5.2-2cl.i386.rpm, the postgresql-devel, the
> postgresql-client and postgresql-lib. After, I created the user postmaster
> and the user nobody.
> I did a php3 script using the next line:
> $conn = pg_connect("localhost", "5432", "", "", "ss"),
> but didn�t get to do it work and I had the next warning:
> Warning: Unable to connect to PostgresSQL server: connectDB() -- connect()
> failed:
> Is the postmaster running (with -i) at 'localhost' and accepting connections
> on TCP/IP port '5432'? in
> /home/httpd/html/postgresql/multi.php3 on line 14

Have you checked the suggestion it makes? You need to run postmaster with
the -i flag so that it is listening on TCP/IP ports, not only UDP. Also
make sure that you have the correct port number.

> Does anybody know how can I do it?
> Do I need to change any name of the last parameters that I am using? Do I
> need to add others?
>
> If somebody could help me...thanks!!!

HTH!
--
Tom Cook - Software Engineer

"Never criticize a man until you've walked a mile in his shoes; that way,
when you criticize him, you're a mile away and have his shoes."
    - Unknown

LISAcorp - www.lisa.com.au

--------------------------------------------------
38 Greenhill Rd.          Level 3, 228 Pitt Street
Wayville, SA, 5034        Sydney, NSW, 2000

Phone:   +61 8 8272 1555  Phone:   +61 2 9283 0877
Fax:     +61 8 8271 1199  Fax:     +61 2 9283 0866
--------------------------------------------------