Redgate Monitor 14

Troubleshooting PostgreSQL with TimescaleDB Data Repository

Installation

Install using  https://docs.timescale.com/self-hosted/latest/install/

See also: Configuring Redgate Monitor database using PostgreSQL with TimescaleDB

Verifying installation

Check extension is installed

SELECT extname, extversion FROM pg_extension WHERE extname in ('timescaledb_toolkit', 'timescaledb');


Check extension is available

SELECT name, default_version, installed_version FROM pg_available_extensions WHERE name in ('timescaledb_toolkit', 'timescaledb');

What errors might I get if TimescaleDB extension is not installed

"function X does not exist" eg:

function counter_agg(timestamp with time zone, bigint) does not exist

Slow performance:

Run timescaledb-tune

TimescaleDB tuning tool: https://docs.timescale.com/self-hosted/latest/configuration/timescaledb-tune 
NB: in virtualized environments the tool might not correctly detect the CPU/RAM sizes in which case pass them in using flags.

Run this tool if:

  • The Base Monitor is running slower than expected (for its load and machine configuration)
  • Your machine configuration has changed (e.g. changing virtual machine specifications)
  • You see errors about background workers

Check timing

Checking the timing of background jobs (e.g. if they're all running at the same time).

Machine Specifications

Ensure your machine has sufficient specifications for your desired performance. 

See also

https://docs.timescale.com/use-timescale/latest/troubleshoot-timescaledb/

Database server is refusing connections

Errors may be "Cannot get data from the following Base Monitor", "Couldn't connect to database"

Solutions:

How can I migrate my existing SQL Server base monitor to TimescaleDB? 

This is on our roadmap, but not currently supported



Didn't find what you were looking for?