Обсуждение: BUG #15012: psql doesn't use server's default port

Поиск
Список
Период
Сортировка

BUG #15012: psql doesn't use server's default port

От
PG Bug reporting form
Дата:
The following bug has been logged on the website:

Bug reference:      15012
Logged by:          Константин Калинин
Email address:      konstantin@kkalinin.pro
PostgreSQL version: 10.1
Operating system:   Xubuntu 16.04
Description:

I had PosgreSQL 9.6 server, that ran on 5432 port and installed 10.1
simultaneously so it started to use 5433 port. 
Both were installed via apt repo http://apt.postgresql.org/pub/repos/apt/
xenial-pgdg main.
After that I've uninstalled 9.6.

Now, though `psql` says in help that it's going to connect to 5433 port by
default, it's connecting to 5432. So I have to explicitly set a `-p 5433`
option.


Re: BUG #15012: psql doesn't use server's default port

От
Pavel Stehule
Дата:
Hi

2018-01-15 17:06 GMT+01:00 PG Bug reporting form <noreply@postgresql.org>:
The following bug has been logged on the website:

Bug reference:      15012
Logged by:          Константин Калинин
Email address:      konstantin@kkalinin.pro
PostgreSQL version: 10.1
Operating system:   Xubuntu 16.04
Description:

I had PosgreSQL 9.6 server, that ran on 5432 port and installed 10.1
simultaneously so it started to use 5433 port.
Both were installed via apt repo http://apt.postgresql.org/pub/repos/apt/
xenial-pgdg
main.
After that I've uninstalled 9.6.

Now, though `psql` says in help that it's going to connect to 5433 port by
default, it's connecting to 5432. So I have to explicitly set a `-p 5433`
option.

Probably somewhere in your environment is setting export PGPORT=5433.

You should to find it and remove.

Regards

Pavel