Skip to main content
Advanced Search
Search Terms
Content Type

Exact Matches
Tag Searches
Date Options
Updated after
Updated before
Created after
Created before

Search Results

217 total results found

Identifying Slow Queries

Hydra How-To Guides

Slow queries can significantly affect application performance and user experience. Hydra offers built-in tools to analyze and identify these slow operations. On Elestio, whether you’re connected via terminal, inside a Docker Compose container, or using Hydra C...

Overview

TimescaleDB

TimescaleDB is an open-source time-series database engineered for fast, scalable ingestion and complex analytics on time-series data. Built as a PostgreSQL extension, TimescaleDB combines the reliability, flexibility, and SQL support of PostgreSQL with powerfu...

Overview

TimescaleDB Cluster Management

Elestio provides a complete solution for setting up and managing software clusters. This helps users deploy, scale, and maintain applications more reliably. Clustering improves performance and ensures that services remain available, even if one part of the sys...

Deploying a New Cluster

TimescaleDB Cluster Management

Creating a cluster is a foundational step when deploying services in Elestio. Clusters provide isolated environments where you can run containerized workloads, databases, and applications. Elestio’s web dashboard helps the process, allowing you to configure co...

Node Management

TimescaleDB Cluster Management

Node management plays a critical role in operating reliable and scalable infrastructure on Elestio. Whether you’re deploying stateless applications or stateful services like databases, managing the underlying compute units nodes is essential for maintaining st...

Adding a Node

TimescaleDB Cluster Management

As your application usage grows or your infrastructure requirements change, scaling your cluster becomes essential. In Elestio, you can scale horizontally by adding new nodes to an existing cluster. This operation allows you to expand your compute capacity, im...

Promoting a Node

TimescaleDB Cluster Management

Clusters can be designed for high availability or role-based workloads, where certain nodes may take on leadership or coordination responsibilities. In these scenarios, promoting a node is a key administrative task. It allows you to change the role of a node. ...

Removing a Node

TimescaleDB Cluster Management

Over time, infrastructure needs change. You may scale down a cluster after peak load, decommission outdated resources, or remove a node that is no longer needed for cost, isolation, or maintenance reasons. Removing a node from a cluster is a safe and structure...

Backups and Restores

TimescaleDB Cluster Management

Reliable backups are essential for data resilience, recovery, and business continuity. Elestio provides built-in support for managing backups across all supported services, ensuring that your data is protected against accidental loss, corruption, or infrastruc...

Restricting Access by IP

TimescaleDB Cluster Management

Securing access to services is a fundamental part of managing cloud infrastructure. One of the most effective ways to reduce unauthorized access is by restricting connectivity to a defined set of IP addresses. Elestio supports IP-based access control through i...

Cluster Resynchronization

TimescaleDB Cluster Management

In distributed systems, consistency and synchronization between nodes are critical to ensure that services behave reliably and that data remains accurate across the cluster. Elestio provides built-in mechanisms to detect and resolve inconsistencies across node...

Database Migrations

TimescaleDB Cluster Management

When managing production-grade services, the ability to perform reliable and repeatable database migrations is critical. Whether you’re applying schema changes, updating seed data, or managing version-controlled transitions, Elestio provides a built-in mechani...

Deleting a Cluster

TimescaleDB Cluster Management

When a cluster is no longer needed whether it was created for testing, staging, or an obsolete workload—deleting it helps free up resources and maintain a clean infrastructure footprint. Elestio provides a straightforward and secure way to delete entire cluste...

Database Migration Service for TimescaleDB

TimescaleDB Database Migration

Elestio provides a structured approach for migrating TimescaleDB databases from various environments, such as on-premises systems or other cloud platforms, to its managed services. This process ensures data integrity and minimizes downtime, facilitating a smoo...

Cloning a Service to Another Provider or Region

TimescaleDB Database Migration

Migrating or cloning services across cloud providers or geographic regions is a critical part of modern infrastructure management. Whether you’re optimizing for latency, preparing for disaster recovery, meeting regulatory requirements, or simply switching prov...

Manual Migration Using pg_dump and pg_restore

TimescaleDB Database Migration

Manual Migrations using TimescaleDB's built-in tools pg_dump and pg_restore are ideal for users who prefer full control over data export and import, particularly during provider transitions, database version upgrades, or when importing an existing self-managed...

Connecting with Node.js

TimescaleDB How to Connect

This guide walks you through the process of connecting a Node.js application to a TimescaleDB database using the pg package. You’ll learn how to set up the environment, configure the connection, and run a simple SQL query. Variables To connect to a Timescale...

Connecting with Python

TimescaleDB How to Connect

This guide explains how to connect a Python application to a TimescaleDB database using the psycopg2-binary package. It covers environment setup, configuration, and execution of a simple query to test connectivity. Variables To connect to a TimescaleDB datab...

Connecting with PHP

TimescaleDB How to Connect

This guide explains how to connect a PHP application to a TimescaleDB database using the PDO extension. It covers setting up prerequisites, configuring the connection URI, and running a test SQL query. Variables To connect to a TimescaleDB database, you only...

Connecting with Go

TimescaleDB How to Connect

This guide walks you through setting up a Go application to connect to a TimescaleDB database, using the PostgreSQL-compatible lib/pq driver, and running a basic query to verify the connection. Variables To connect to a TimescaleDB database, you only need on...