Install TimescaleDB on Windows

URL: llms-txt#install-timescaledb-on-windows

Contents:

• Prerequisites
• Install and configure TimescaleDB on Postgres
• Add the TimescaleDB extension to your database
• Supported platforms
• Where to next

TimescaleDB is a Postgres extension for time series and demanding workloads that ingest and query high volumes of data.

This section shows you how to:

• [Install and configure TimescaleDB on Postgres][install-timescaledb]: set up a self-hosted Postgres instance to efficiently run TimescaleDB.
• [Add the TimescaleDB extension to your database][add-timescledb-extension]: enable TimescaleDB features and performance improvements on a database.

The following instructions are for development and testing installations. For a production environment, we strongly recommend that you implement the following, many of which you can achieve using Postgres tooling:

• Incremental backup and database snapshots, with efficient point-in-time recovery.
• High availability replication, ideally with nodes across multiple availability zones.
• Automatic failure detection with fast restarts, for both non-replicated and replicated deployments.
• Asynchronous replicas for scaling reads when needed.
• Connection poolers for scaling client connections.
• Zero-down-time minor version and extension upgrades.
• Forking workflows for major version upgrades and other feature testing.
• Monitoring and observability.

Deploying for production? With a Tiger Cloud service we tune your database for performance and handle scalability, high availability, backups, and management, so you can relax.

To install TimescaleDB on your Windows device, you need:

For TimescaleDB v2.14.1 only, you need to install OpenSSL v1.1.1.

• [Visual C++ Redistributable for Visual Studio 2015][ms-download]