TimescaleDB
Overview
TimescaleDB is an open-source time-series database engineered for fast, scalable ingestion and co...
How to Connect
Connecting with Node.js
This guide walks you through the process of connecting a Node.js application to a TimescaleDB dat...
Connecting with Python
This guide explains how to connect a Python application to a TimescaleDB database using the psyco...
Connecting with PHP
This guide explains how to connect a PHP application to a TimescaleDB database using the PDO exte...
Connecting with Go
This guide walks you through setting up a Go application to connect to a TimescaleDB database, us...
Connecting with Java
This guide shows how to connect your Java app to a TimescaleDB database using the PostgreSQL JDBC...
Connecting with psql
This guide explains how to connect to a TimescaleDB database using the psql command-line tool. It...
Connecting with pgAdmin
pgAdmin is a widely used graphical interface for TimescaleDB that allows you to manage, connect t...
How-To Guides
Creating a Database
TimescaleDB allows you to create databases using different methods, including the PostgreSQL inte...
Upgrading to a Major Version
Upgrading a database service on Elestio can be done without creating a new instance or performing...
Installing or Updating an Extension
TimescaleDB supports a growing range of PostgreSQL-compatible extensions that add extra functiona...
Creating Manual Backups
Regular backups are a key part of managing a TimescaleDB deployment. While Elestio provides autom...
Restoring a Backup
Restoring backups is essential for recovery, environment duplication, or rollback scenarios. Eles...
Identifying Slow Queries
Slow queries can significantly affect application performance and user experience. TimescaleDB of...
Detect and terminate long-running queries
Long-running queries can significantly impact database performance by consuming CPU, memory, and ...
Preventing Full Disk Issues
Running out of disk space in a database environment can lead to failed writes, service downtime, ...
Checking Database Size and Related Issues
As your TimescaleDB database grows over time, it’s important to monitor its size and identify wha...
Database Migration
Database Migration Service for TimescaleDB
Elestio provides a structured approach for migrating TimescaleDB databases from various environme...
Cloning a Service to Another Provider or Region
Migrating or cloning services across cloud providers or geographic regions is a critical part of ...
Manual Migration Using pg_dump and pg_restore
Manual Migrations using TimescaleDB's built-in tools pg_dump and pg_restore are ideal for users w...
Cluster Management
Overview
Elestio provides a complete solution for setting up and managing software clusters. This helps us...
Deploying a New Cluster
Creating a cluster is a foundational step when deploying services in Elestio. Clusters provide is...
Node Management
Node management plays a critical role in operating reliable and scalable infrastructure on Elesti...
Adding a Node
As your application usage grows or your infrastructure requirements change, scaling your cluster ...
Promoting a Node
Clusters can be designed for high availability or role-based workloads, where certain nodes may t...
Removing a Node
Over time, infrastructure needs change. You may scale down a cluster after peak load, decommissio...
Backups and Restores
Reliable backups are essential for data resilience, recovery, and business continuity. Elestio pr...
Restricting Access by IP
Securing access to services is a fundamental part of managing cloud infrastructure. One of the mo...
Cluster Resynchronization
In distributed systems, consistency and synchronization between nodes are critical to ensure that...
Database Migrations
When managing production-grade services, the ability to perform reliable and repeatable database ...
Deleting a Cluster
When a cluster is no longer needed whether it was created for testing, staging, or an obsolete wo...