Configure the Redgate Monitor database

For the Redgate Monitor database, you can either:

Use an existing empty database
or
Use a database created by Redgate Monitor through the installer (which will be called RedGateMonitor by default).

If your TimescaleDB is self-managed, ensure that:

If your TimescaleDB is a TigerData Cloud instance then select "tsdb" as your existing, empty database to use.

Using an existing PostgreSQL with TimescaleDB database

Specify the PostgreSQL host, port, database name, user, and password in the POSTGRES_REPOSITORYCONNECTIONSTRING.

Click Select database. Leave the default option of Use an existing database selected and click Next:

Specify the PostgreSQL host, port, database name, user, and password:

Note that you need to choose either an empty database or a database that was created during a previous Redgate Monitor installation. Click OK.

1. Create a new database in postgres for Redgate Monitor use as a data repository:

Create data repository

CREATE DATABASE RedGateMonitor

Note the database name will be redgatemonitor since postgres automatically lowers the case of all database names.

2. Once the TimescaleDB and TimescaleDB toolkit extensions have been installed, Tune the new RedGateMonitor database.

Specify the PostgreSQL host, port, database name, user, and password in the POSTGRES_REPOSITORYCONNECTIONSTRING

1. Click Select database and choose Create a new database. Then click Next:

2. Specify the credentials used to create the database.

Specify the PostgreSQL host, port, database name, user, and password.

3. Click Create now.

When you click Next, Redgate Monitor will summarize the install, and you can click Install to start it.

If you're installing the Base Monitor and Web Server on one machine, then this will complete the installation.
- Go to Using Redgate Monitor for the first time
If you're installing the Base Monitor on a separate server, then:
- Go to Connecting to the Base Monitor and Web Server.