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

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: konstantin(at)kkalinin(dot)pro, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15012: psql doesn't use server's default port
Date: 2018-01-15 18:05:47
Message-ID: CAFj8pRBAaArXFPSx-aa_NzkHU4xXLGsTN90p01V-NRfpbO9fJw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi

2018-01-15 17:06 GMT+01:00 PG Bug reporting form <noreply(at)postgresql(dot)org>:

> The following bug has been logged on the website:
>
> Bug reference: 15012
> Logged by: Константин Калинин
> Email address: konstantin(at)kkalinin(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Aleksandr Parfenov 2018-01-16 07:52:26 Re: PostgreSQL crashes with SIGSEGV
Previous Message PG Bug reporting form 2018-01-15 16:06:08 BUG #15012: psql doesn't use server's default port