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
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(...) = '...' |