Configure the Redgate Monitor database

The Base Monitor needs to connect to its Data Repository: either an empty database or to a database previously used by Redgate Monitor.

We recommend this is a PostgreSQL with TimescaleDB but it can also be on SQL Server. 

Installing the Base Monitor

1. Extract the RedgateMonitor.BaseMonitor.xxx.tar.gz file 
2. Run the extracted ./install.sh  script
3. Add the repository connection string to the configuration file
   1. Edit /etc/opt/redgate/redgatemonitor/redgatemonitor.conf 
   2. Uncomment either the POSTGRES_REPOSITORYCONNECTIONSTRING or the SQLSERVER_REPOSITORYCONNECTIONSTRING as required and enter your Redgate Data Repository connection information.

POSTGRES_REPOSITORYCONNECTIONSTRING="Host=db-host;Port=5432;Password=db-password;User Id=postgres;database=dbname"

#SQLSERVER_REPOSITORYCONNECTIONSTRING=Data Source=db-host;Initial Catalog=RedgateMonitor;TrustServerCertificate=true;User ID=sa;Password=password;

Installing the Website 

1. Extract the RedgateMonitor.Website.xxx.tar.gz file 
2. Run the extracted ./install.sh  script
3. Open a browser to the website host and connect it to the Base Monitor (see also: Connecting to the Base Monitor and Web Server)
   

Next Step

Now you're Base Monitor and Website are installed get ready to Use Redgate Monitor for the first time