Page Comparison

...

• On the old server, stop the xroad-proxy and dump message log data using pg_dump (note that the size of the messagelog database can be large, so this can take time and a space).
sudo service xroad-proxy stop
sudo -iu postgres pg_dump -d messagelog -Fc -f <dump_file>
  (see https://www.postgresql.org/docs/9.3/app-pgdump.html for more information about creating a database dump)
  
  

• Copy the dump to the new server and restore the database on the new server:
  sudo service xroad-proxy stop
sudo -iu postgres pg_restore -d messagelog -c <dump_file>
sudo service xroad-proxy start
  (see https://www.postgresql.org/docs/10/app-pgrestore.html for more information about restoring a dump)
  
  
• Copy the archived message records (in /var/lib/xroad) to the new server.
  
  

Optionally, copy the operational monitoring database from the old server (if xroad-opmonitoring is installed)

• On the old server, stop xroad-opmonitor and dump the database:
sudo service xroad-opmonitor stop
sudo -iu postgres pg_dump -d "op-monitor" -F c -f <dump_file>

• Copy the dump to the new server and restore the database on the new server:
  sudo service xroad-opmonitor stop
sudo -iu postgres pg_restore -d "op-monitor" -c <dump_file>
sudo service xroad-opmonitor start

Switch over to the upgraded server (stop the old server and update your network configuration accordingly).

...