Search Results

If you want to add a new node to your cluster, you can: Click on the Add Node button in the top-right corner of your cluster page. Alternatively, in the Overview tab, click on Add Node. A prompt will appear, asking for confirmation to add a new node. ...

If you want to remove a node from your cluster, you can: Click on the Delete button with the trash icon in the Nodes tab. Alternatively, click on a node to view its details, then click Delete Node in the top-left corner. A confirmation popup will appear...

If you want to promote a node to Primary in your cluster, follow these steps: Go to the Nodes tab. Click on the Promote button with the arrow icon next to the node you wish to promote. A confirmation popup will appear, asking if you really want to promo...

Elestio offers a Backup section specifically for managing backups.For clusters, only the backups of the Primary node are supported.If you promote a new node to Primary, a new backup will automatically be created for security purposes, ensuring a healthy backup...

If you want to restrict your cluster to specific IPs for enhanced security, follow these steps: Go to the Overview tab. Click on the Limit Access per IP button. A popup will appear where you can configure IP restrictions: In the text field, add the...

If one or more Replica nodes are unhealthy or desynchronized, you can resynchronize them with the Primary node by following these steps: Go to the Overview tab of your cluster. Click on the Resync Cluster button. A confirmation popup will appear to ensu...

If you want to migrate an existing database to your cluster, you can do so easily by following these steps: Go to the Overview tab of your cluster. Click on the Migrate Database button. Migration Process Start the Migration: A popup will appear....

If you want to delete your cluster, follow these steps: Go to the Overview tab of your cluster. Click on the Delete Cluster button located in the top-right corner. A confirmation popup will appear to ensure you want to proceed. Enter the name of your...

Edit the website nginx configuration From the service overview screen it's possible to edit the nginx configuration for the elestio default subdomain domain & custom domain, to do that go to the Security tab, then click on Nginx configuration then click on Co...

Elestio offers comprehensive services, including various support plans, support for multiple database types, and robust backup retention policies.  Support Plans Elestio offers flexible support plans tailored to meet different user needs, ensuring smooth dep...

PostgreSQL is an open-source relational database management system. It supports SQL language and offers features like transactions, referential integrity, and user-defined types and functions. PostgreSQL can handle complex queries, supports various data types,...

This guide explains how to establish a connection between a Node.js application and a PostgreSQL database using the pg package. It walks through the necessary setup, configuration, and execution of a simple SQL query. Variables Certain parameters must be pro...

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

Elestio provides a structured approach for migrating PostgreSQL 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 smoot...

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

This guide explains how to establish a connection between a Python application and a PostgreSQL database using the psycopg2-binary package. It walks through the necessary setup, configuration, and execution of a simple SQL query. Variables To connect to a Po...

This guide explains how to establish a connection between a PHP application and a PostgreSQL database using the built-in PDO extension. It walks through the necessary setup, configuration, and execution of a simple SQL query. Variables To connect to a Postgr...

This guide explains how to establish a connection between a Go (Golang) application and a PostgreSQL database using the github.com/lib/pq driver. It walks through the necessary setup, configuration, and execution of a simple SQL query. Variables To connect t...

This guide explains how to establish a connection between a Java application and a PostgreSQL database using the JDBC driver. It walks through the necessary setup, configuration, and execution of a simple SQL query. Variables Certain parameters must be provi...

This guide explains how to connect to a PostgreSQL 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 PostgreSQL database, you only need one envi...