Search Results

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...

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...

This guide walks you through the process of connecting a Node.js application to a Hydra 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 Hydra database,...

This guide explains how to connect a Python application to a Hydra 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 Hydra database, you onl...

This guide explains how to connect a PHP application to a Hydra 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 Hydra database, you only need one en...

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

This guide shows how to connect your Java app to a Hydra database using the PostgreSQL JDBC driver, parse command-line arguments, and run a basic query. Variables To connect to a Hydra database, the following parameters are required. You can find these detai...

This guide explains how to connect to a Hydra database using the psql command-line tool. It walks through the necessary setup, connection process, and execution of a simple SQL query. Variables To connect to a Hydra database, you only need one environment va...

pgAdmin is a widely used graphical interface for Hydra that allows you to manage, connect to, and run queries on your databases with ease. Variables To connect using pgAdmin, you'll need the following connection parameters. When you deploy a Hydra service on...

Elestio provides a structured approach for migrating Hydra 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 smooth tra...

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 Migrations using Hydra’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 Hydra...

Hydra allows you to create databases using different methods, including the PostgreSQL interactive shell (psql), Docker (assuming Hydra is running inside a container), and the command-line interface (createdb). This guide explains each method step-by-step, cov...

Upgrading a database service on Elestio can be done without creating a new instance or performing a full manual migration. Elestio provides a built-in option to change the database version directly from the dashboard. This is useful for cases where the upgrade...

Hydra supports a growing range of PostgreSQL-compatible extensions that add extra functionality to the core database system. Extensions like pg_trgm (for text search) and some UUID utilities are used to extend native capabilities. However, not all PostgreSQL e...

Regular backups are a key part of managing a Hydra deployment. While Elestio provides automated backups by default, you may want to perform manual backups for specific reasons, such as preparing for a major change, keeping a local copy, or testing backup autom...

Restoring backups is essential for recovery, environment duplication, or rollback scenarios. Elestio supports restoring backups both through its built-in dashboard and via command-line tools like pg_restore psql. You can also restore from inside Docker Compose...

Long-running queries can significantly impact database performance by consuming CPU, memory, and I/O resources over extended periods. In production environments like Elestio, it’s important to monitor for these queries and take timely action to terminate them ...

Running out of disk space in a database environment can lead to failed writes, service downtime, and even data corruption. Hydra systems require available space not only for storing data but also for managing temporary files, WAL logs, indexes, and routine bac...

As your Hydra database grows over time, it’s important to monitor its size and identify what parts of the database consume the most space. Unmanaged growth can lead to performance issues, disk exhaustion, and backup delays. On Elestio, where Hydra is hosted in...