Prerequisite for this tutorial:
OS: Windows
PostgreSQL: component in the installation 20.2
Before you begin
Read these instructions carefully from start to finish. Make sure that you understand each step before starting the upgrade.
Setup and configuration:
PostgreSQL host: localhost
PostgreSQL port: 5432
PostgreSQL user: postgres
PostgreSQL password: __YOUR_INTERNAL_PASSWORD__
Newired Portal: 20.2
Newired Portal path: C:\Newired
Newired license file: C:\Newired\tomcat\conf\newired.license
HTTP port (tomcat internal service): 8090
Newired default language: en_US
Newired Portal URL address: http://__YOUR_SERVER__
Steps:
Run PowerShell as Administrator Using the Run Window
Windows PowerShell will launch with the rights of the current user.
If you want to switch from normal mode to administrator mode, type the following PowerShell command and press Enter.
Start-Process powershell -Verb runAs
- Stop the Newired service:
net stop "Newired Portal"
-Stop the Newired PostgreSQL service:
net stop "Newired PostgreSQL"
- Backup all application files inc. PostgreSQL :
robocopy "C:\Newired\" "C:\Newired_backup\Newired\" /e /zb /copyall
- To see if backup was really made:
dir C:\
Terminal output:
Start the Newired PostgreSQL service for individually backup dump database:
net start "Newired PostgreSQL"
C:\Newired\postgresql\bin\pg_dump.exe -C -h localhost -p 5432 -U postgres -W -d newired -f C:\Newired_backup\newired.sql
C:\Newired\postgresql\bin\pg_dump.exe -C -h localhost -p 5432 -U postgres -W -d collector -f C:\Newired_backup\collector.sql
C:\Newired\postgresql\bin\pg_dump.exe -C -h localhost -p 5432 -U postgres -W -d report -f C:\Newired_backup\report.sql
Again write here to do dir command and that they should see there collector.sql, newired.sql and report.sql files:
dir C:\Newired_backup\
Terminal output:
Uninstall the 20.2 version of Newired portal:
C:\Newired\uninstall.exe
Uninstall the 20.2 version of Newired Editor:
C:\Newired\editor\uninstall.exe
Remove its installation folder:
Remove-Item C:\Newired -Recurse
Download Newired Portal 20.3 and SQL update scripts from https://download.newired.com
and save files listed below to C:\ on your server (extract db update sql from archive into C:\):
Newired-Portal-20_3_0-x64.exe
database_update20.2_to_20.3_newired.sql
dir C:\
You should see this files in terminal output:
Start the installation of portal:
C:\Newired-Portal-20_3_0-x64.exe
You must agree to the license:
You set the path where you want to install the portal. It is important to remember this because we will copy the data from the previous installation here:
Select Postgre SQL and Reporting components. If you used the Editor on the server, then it was chosen too.
You leave the default settings:
Enter your original license that we backed up at the beginning of the update process.
And here you have to set up your domain where you want the portal to run. You have created a certificate for this domain. It is important to fill this correctly otherwise the update process will fail.
Select the language you had set in the previous installation:
The portal with your specified address and your certificate will not run correctly. It's alright.
Now we move your previous configuration and certificate to a new installation.
Stop the Newired service:
net stop "Newired Portal"
Remove production databases of just installed Newired 20.3:
C:\Newired\postgresql\bin\psql.exe -h localhost -p 5432 -U postgres -W -c "Drop DATABASE newired;" -c "DROP DATABASE collector;" -c "DROP DATABASE report;"
Import procedure our databases that we backed up at the beginning of the upgrade process (SQL files includes creating Newired, collector and report databases):
C:\Newired\postgresql\bin\psql.exe -h localhost -p 5432 -U postgres -W -f C:\Newired_backup\newired.sql
C:\Newired\postgresql\bin\psql.exe -h localhost -p 5432 -U postgres -W -f C:\Newired_backup\collector.sql
C:\Newired\postgresql\bin\psql.exe -h localhost -p 5432 -U postgres -W -f C:\Newired_backup\report.sql
Run the SQL script to update the database from 20.2 to 20.3
C:\Newired\postgresql\bin\psql.exe -h localhost -p 5432 -U postgres -W -d newired -f C:\database_update20.2.0_to_20.3.0_newired.sql
Note: If you have an older version of the portal it is necessary to run SQL scripts of older versions. SQL files of previous versions can be found at https://download.newired.com
Copy the tomcat configuration from the previous installation:
Copy-Item -Path C:\Newired_backup\Newired\tomcat\conf\ -Destination C:\Newired\tomcat\ -Recurse -Force
Copy files from the delivery server from the previous installation:
robocopy "C:\Newired_backup\Newired\content\" "C:\Newired\content\" /e /zb /copyall
Check folders C:\Newired_backup\Newired\plugins and C:\Newired_backup\Newired\themes
Copy if there are other plugins and themes than default to C:\Newired\plugins and C:\Newired\themes
Default Plugins and Themes must be new from version 20.3.
Start the Newired service
net start "Newired Portal"