On Thu, Jul 30, 2009 at 5:33 PM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
> Dotan Barak <dotanba@gmail.com> writes:
>> I'm using CentOS 5.3 and PostgreSQL version 8.1.11.
>
> Are you using the Red Hat/CentOS postgresql RPMs, or some other
> distribution of PG?
Yes, I'm using the original RPM that comes with CentOS.
>
>> It seems that the posgres SQL sometimes listen on other ports than 5432:
>> # lsof -i -n -P | grep postg
>> postmaste 18415 postgres 3u IPv4 99670 TCP *:17583 (LISTEN)
>> postmaste 18415 postgres 4u IPv6 102029 TCP *:5432 (LISTEN)
>> postmaste 18415 postgres 5u IPv4 102030 TCP *:5432 (LISTEN)
>
> Odd, particularly seeing that that port was evidently opened before
> 5432. The only idea that comes to mind is that it's being opened by
> a library for Kerberos or LDAP or some such. What auth methods have
> you got listed in pg_hba.conf?
>
> regards, tom lane
>
"trust all".
The weird thing is that i used this port in a service that i wrote
only few seconds before this happened...
Dotan