...
To change the port range for a Server, use the Network settings utility (see Network settings utility).
Changing the PostgreSQL database port
In Axxon One 4.5.0, the default port of PostgreSQL database was replaced for 20110. If you upgrade your system from a previous version (see Update), the old port number 49998 is preserved.
There are two ways to change it:
- Complete removal of Axxon One and PostgreSQL with all data.
- Configuration changes.
Changing the PostgreSQL database port by removing Axxon One completely
To do this:
- Remove Axxon One without saving the configuration (see Removal).
- Remove PostgreSQL.
- Delete all folders with PostgreSQL.NGP in their names in the С:\Program Files\Common Files\AxxonSoft\ folder.
- Delete the HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\ registry section.
- Restart the computer.
- Install Axxon One (see Installation).
Changing the PostgreSQL database port in the configuration
If it is necessary to change the PostgreSQL database port and at the same time save the system and database configuration, then do the following:
...
Stop Axxon One services:
| Code Block |
|---|
powershell -Command "get-service NGP_* | stop-service" |
Stop PostgreSQL service:
| Code Block |
|---|
powershell -Command "get-service postgresql* | stop-service" |
...
On the command line, run the following commands in sequence:
| Info |
|---|
|
The first two commands use the default Axxon One installation paths (see Installation). If other paths are used, then it is necessary to change the commands. |
| Code Block |
|---|
set CONFIG_PATH=C:\ProgramData\AxxonSoft\Axxon One |
| Code Block |
|---|
set InstallDir=C:\Program Files\AxxonSoft\Axxon One |
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\config_repo\EventDatabase.0\" |
| Code Block |
|---|
powershell -Command "(gc main.conf) -replace '<port>49998</port>', '<port>20110</port>' | Out-File -encoding ASCII main.conf" |
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\config_repo\" |
| Code Block |
|---|
"%InstallDir%\bin\hg.exe" commit --verbose "--message=change DB port" --user "Manual change DB" -- EventDatabase.0/main.conf |
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\clone_config_repo\EventDatabase.0\" |
| Code Block |
|---|
powershell -Command "(gc main.conf) -replace '<port>49998</port>', '<port>20110</port>' | Out-File -encoding ASCII main.conf" |
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\clone_config_repo\" |
| Code Block |
|---|
"%InstallDir%\bin\hg.exe" commit --verbose "--message=change DB port" --user "Manual change DB" -- EventDatabase.0/main.conf |
If there is a main.conf file in the C:\ProgramData\AxxonSoft\Axxon One\Config.local\config_repo\ObjectSearcher.0 folder, and there is a <port>49998</port> parameter in this file, then run the following commands in sequence:
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\config_repo\ObjectSearcher.0\"
powershell -Command "(gc main.conf) -replace '<port>49998</port>', '<port>20110</port>' | Out-File -encoding ASCII main.conf" |
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\config_repo\"
"%InstallDir%\bin\hg.exe" commit --verbose "--message=change DB port" --user "Manual change DB" -- ObjectSearcher.0/main.conf |
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\clone_config_repo\ObjectSearcher.0\"
powershell -Command "(gc main.conf) -replace '<port>49998</port>', '<port>20110</port>' | Out-File -encoding ASCII main.conf" |
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\clone_config_repo\"
"%InstallDir%\bin\hg.exe" commit --verbose "--message=change DB port" --user "Manual change DB" -- ObjectSearcher.0/main.conf |
If there is no main.conf file in the folder, or if the port parameter is missing in the file, then skip this step.
If there is a main.conf file in the C:\ProgramData\AxxonSoft\Axxon One\Config.local\config_repo\RealtimeRecognizer.0 folder, and there is a <port>49998</port> parameter in this file, then run the following commands in sequence:
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\config_repo\RealtimeRecognizer.0\"
powershell -Command "(gc main.conf) -replace '<port>49998</port>', '<port>20110</port>' | Out-File -encoding ASCII main.conf" |
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\config_repo\"
"%InstallDir%\bin\hg.exe" commit --verbose "--message=change DB port" --user "Manual change DB" -- RealtimeRecognizer.0/main.conf |
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\clone_config_repo\RealtimeRecognizer.0\"
powershell -Command "(gc main.conf) -replace '<port>49998</port>', '<port>20110</port>' | Out-File -encoding ASCII main.conf" |
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\clone_config_repo\"
"%InstallDir%\bin\hg.exe" commit --verbose "--message=change DB port" --user "Manual change DB" -- RealtimeRecognizer.0/main.conf |
If there is no main.conf file in the folder, or if the port parameter is missing in the file, then skip this step.
If there is a main.conf file in the C:\ProgramData\AxxonSoft\Axxon One\Config.local\config_repo\VMDA2_DB.0 folder, and there is a <port>49998</port> parameter in this file, then run the following commands in sequence:
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\config_repo\VMDA2_DB.0\"
powershell -Command "(gc main.conf) -replace '<pg_port>49998</pg_port>', '<pg_port>20110</pg_port>' | Out-File -encoding ASCII main.conf"" |
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\config_repo\"
"%InstallDir%\bin\hg.exe" commit --verbose "--message=change DB port" --user "Manual change DB" -- VMDA2_DB.0/main.conf |
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\clone_config_repo\VMDA2_DB.0\"
powershell -Command "(gc main.conf) -replace '<pg_port>49998</pg_port>', '<pg_port>20110</pg_port>' | Out-File -encoding ASCII main.conf" |
| Code Block |
|---|
cd "%CONFIG_PATH%\Config.local\clone_config_repo\"
"%InstallDir%\bin\hg.exe" commit --verbose "--message=change DB port" --user "Manual change DB" -- VMDA2_DB.0/main.conf |
If there is no main.conf file in the folder, or if the port parameter is missing in the file, then skip this step.
Run the PostgreSQL service:
| Code Block |
|---|
powershell -Command "get-service postgresql* | start-service" |
Run the Axxon One services:
| Code Block |
|---|
powershell -Command "get-service NGP_* | start-service" |
