Re: PostgreSQL server listen on other port than 5432

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL server listen on other port than 5432
Дата
Msg-id 12782.1248964422@sss.pgh.pa.us
обсуждение исходный текст
Ответ на PostgreSQL server listen on other port than 5432  (Dotan Barak <dotanba@gmail.com>)
Ответы Re: PostgreSQL server listen on other port than 5432
Список pgsql-general
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?

> 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Clients disconnect but query still runs
Следующее
От: Jennifer Trey
Дата:
Сообщение: pg_config --sharedir points to the wrong folder.. is this a problem?