On Thu, Jul 30, 2009 at 5:33 PM, Tom Lane<tgl@xxxxxxxxxxxxx> wrote: > Dotan Barak <dotanba@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general