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 (download here)
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 REDGATE_MONITOR_PostgresRepositoryConnectionString or the REDGATE_MONITOR_RepositoryConnectionString as required and enter your Redgate Data Repository connection information.

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

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

Upgrading from an earlier version? Your config strings might instead be called POSTGRES_REPOSITORYCONNECTIONSTRING and SQLSERVER_REPOSITORYCONNECTIONSTRING or SQLMONITOR_ARG_PostgresRepositoryConnectionString and SQLMONITOR_ARG_SqlServerRepositoryConnectionString.

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.
   

Next Steps

• You can configure your Redgate Monitor Website to use HTTPS, if required. 
• Now you're Base Monitor and Website are installed get ready to Use Redgate Monitor for the first time