Em ter, 29 de out de 2019 às 08:54, Muziwandile Zwane
<mzwai99@outlook.com> escreveu:
>
> I wanted to change the port from default to 5437, initially it worked, but suddendly I had issues connecting.
> I changed the port postgresql.conf back to 5432.
>
... if you change the port, you should specify it in psql command-line.
> [root@zardplpsmasdev01 data]# su - postgres -c "psql"
> psql (12.0)
> Type "help" for help.
>
su - postgres -c "psql -p 5437"
The default port (5432 or what it was compiled with) is hardcoded in
all postgres binaries. If you change the port to something else, you
should specify --port (-p) parameter or set PGPORT variable.
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento