Re: php can't connect to postgresql server - Mailing list pgsql-general

From Clodoaldo Pinto
Subject Re: php can't connect to postgresql server
Date
Msg-id a595de7a0607030651v1b802189sdd44901bf3a65041@mail.gmail.com
Whole thread Raw
In response to Re: php can't connect to postgresql server  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
2006/7/3, A. Kretschmer <andreas.kretschmer@schollglas.com>:
> am  03.07.2006, um 10:25:29 -0300 mailte Clodoaldo Pinto folgendes:
> > $conn_string = "hostaddr=127.0.0.1 port=5432 dbname=dbname
>                            ^^^^^^^^^
>
> > I can connect as that user with psql:
> >
> > $ psql -h localhost -U username dbname
>             ^^^^^^^^^
>
> Try 'localhost' instead '127.0.0.1' in your $conn_string.

As I already said I have tried localhost also.

> My guess: pg don't listen on tcp/ip, only on the local socket.
> (check listen_addresses in your postgresql.conf)

listen_addresses = '127.0.0.1,xx.xx.xxx.xx'

If I can connect with the -h localhost psql's option then I guess it
is listening to tcp/ip, isn't it?

Clodoaldo

pgsql-general by date:

Previous
From: "Alexander Farber"
Date:
Subject: Re: Optimizing query: select ... where id = 4 and md5(...) = '...'
Next
From: Robert Treat
Date:
Subject: Re: php can't connect to postgresql server