Re: php can't connect to postgresql server

From: "Clodoaldo Pinto" <clodoaldo(dot)pinto(at)gmail(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: php can't connect to postgresql server
Date: 2006-07-03 13:51:05
Message-ID: a595de7a0607030651v1b802189sdd44901bf3a65041@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2006/7/3, A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steven Ridgway 2006-07-03 13:57:03 How serious are these problems?
Previous Message Alexander Farber 2006-07-03 13:47:57 Re: Optimizing query: select ... where id = 4 and md5(...) = '...'