| From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
|---|---|
| To: | "Stefano B(dot)" <stefano(dot)bonnin(at)comai(dot)to> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgresql server "crash" after some day |
| Date: | 2005-08-17 13:20:51 |
| Message-ID: | 430339B3.7030709@wildenhain.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Stefano B. schrieb:
> Hi all,
>
> I have some strange problems with postgres.
> After some days it works in local but it doesn't listen on port 5432 for
> remote request.
>
> I can make a connection from local host but I can't from remote host. If
> I try to make a connection from remote host the server returns me the
> classic remote error:
>
> could not connect to server ... is the server running on host ...
> and accepting TCP/IP connections on port 5432?
>
> This problem happens after some day that I have start the server.
> There is no particular error in the log file (the server seems to work)
>
> PostgreSql version: 8.0.3
> on FreeBSD 5.3
after some day? If you did not change the config files and if there
was not another process using that port during the start, chances
are you configured a firewall which just refuses connections to port
5432?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Davis | 2005-08-17 13:39:20 | Re: Finding nearest numeric value |
| Previous Message | Tino Wildenhain | 2005-08-17 13:17:29 | Re: Set autocommit to off |