Troubleshooting PostgreSQL with TimescaleDB Data Repository
Published 09 April 2025
See Also
- TimescaleDB tuning tool: https://docs.timescale.com/self-hosted/latest/configuration/timescaledb-tune
- TimescaleDB troubleshooting guide: https://docs.timescale.com/use-timescale/latest/troubleshoot-timescaledb/
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:
- Check there is a connection to the PostgreSQL instance.
- Check the database machine is not out of storage
- Check
- See the official troubleshooting docs:
How can I migrate my existing SQL Server base monitor to TimescaleDB?
This is on our roadmap, but not currently supported