| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgres does not accept socket connections |
| Date: | 2006-03-02 15:49:11 |
| Message-ID: | 3107.1141314551@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> writes:
> am 02.03.2006, um 4:37:02 -0800 mailte kishore(dot)sainath(at)gmail(dot)com folgendes:
>> psql: could not connect to server: Connection refused
>> Is the server running on host "server-name" and accepting
>> TCP/IP connections on port 5432?
> Check the postgresql.conf for the value "listen_addresses".
> My guess: listen_address is at the moment 'localhost'. Change this to
> the LAN-address or '*'.
If listen_addresses is correct and you still get "Connection refused",
the other thing to look at is the kernel's packet filtering rules
(iptables). I believe the default configuration on FC4 will reject
external connections to 5432.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2006-03-02 15:57:52 | Re: [SQL] Without OIDs |
| Previous Message | Tom Lane | 2006-03-02 15:20:26 | Re: Thread scheduling in postgresql 8.1.3 on windows |