On the root server

In the following section, DATABASE_HOST refers to the hostname of the new database server, and SERVER_HOST to the hostname of the root server.

  • Remove the rudder-server-root and rudder-reports packages if installed. For example, you can run on Debian:
service rudder restart
apt-mark manual rudder-webapp rudder-inventory-endpoint
apt-get remove --purge rudder-reports
  • You can also remove the postgresql package and database from the server if installed, but keep in mind you will lose all existing data. You can follow the backup and restore procedure to migrate the data to the new database.
  • Change the hostname in /opt/rudder/etc/rudder-web.properties:
rudder.jdbc.url=jdbc:postgresql://DATABASE_HOST:5432/rudder
  • Edit /var/rudder/cfengine-community/inputs/rudder-server-roles.conf and set the following line:
rudder-db:DATABASE_HOST
  • Edit the /etc/rsyslog.d/rudder.conf file and change the hostname in:
:ompgsql:DATABASE_HOST,rudder,rudder,...
  • Run an inventory:
rudder agent inventory
  • Restart rudder services:
service rsyslog restart
service rudder restart
  • Clear the cache (in Administration → Settings)

You should now have finished configuring the database server. You can check the technical logs to see if reports are correctly written into the database and read by the web application.