Dotan Barak <dotanba(at)gmail(dot)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?
> 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
In response to
pgsql-general by date
|Next:||From: Vick Khera||Date: 2009-07-30 15:02:55|
|Subject: Re: SVN and Postgres 8.3|
|Previous:||From: Greg Stark||Date: 2009-07-30 14:30:15|
|Subject: Re: Clients disconnect but query still runs|