TCP port 5433 used for PostgreSQL

Description
mbidner
Posts: 9
Joined: Thu May 04, 2017 9:55 am

TCP port 5433 used for PostgreSQL

Postby mbidner » Fri Jan 05, 2018 3:16 pm

Hello all,
after Polarion installation the port number 5433 is used for access of postgresql server.
The official port number for postgresql according IANA should be 5432.
Is there any reason why 5433 is used (instead of official port)?
Is it possible to change this number in configuration files (after shutdown).

Thanks in advance
BR
Michael

ALMighty
Posts: 77
Joined: Wed Apr 27, 2016 10:34 am
Location: Austria

Re: TCP port 5433 used for PostgreSQL

Postby ALMighty » Mon Jan 08, 2018 2:24 pm

Hello! :D

mbidner wrote:after Polarion installation the port number 5433 is used for access of postgresql server.
The official port number for postgresql according IANA should be 5432.
Is there any reason why 5433 is used (instead of official port)?


The official Postgre documentation says that "normally" it uses 5432, an answer on Stackoverflow also suggests that if 5432 is not available, then 5433 is used. Ask you System Administrator if 5432 is used by a different application in your network already, maybe that is why it used 5433 instead of 5432.

mbidner wrote:Is it possible to change this number in configuration files (after shutdown).


Yes you can, you can set this in the configuration files located in your Polarion installation on your server, see here:
https://almdemo.polarion.com/polarion/s ... ection.pdf

Port number can be determined from the Polarion system property
[...]
Appendix
The polarion.properties file is located on the following paths depending on theenvironment:

Windows:
%POLARION_HOME%/polarion/configuration/polarion.properties

Linux:
%POLARION_HOME%/etc/polarion.properties
%PGDATA%
is the folder where the database files are stored and the location on which the database was initialized.
The default location is:
%POLARION_HOME%/data/postgres-data


I suggest also asking your System Administrator for help for this, she/he knows best where the installation is located in your network.
---------------------------------------------------------------------------------------------------
Playing a good game is never lame. :D
Image


Return to “Polarion Application Lifecycle Management (ALM)”

Who is online

Users browsing this forum: No registered users and 2 guests