PostgreSQL - Connect with pgAdmin

Connect to your Public Cloud Databases for PostgreSQL using pgAdmin

Last updated 4th April, 2022

Objective

Public Cloud Databases allow you to focus on building and deploying cloud applications while OVHcloud takes care of the database infrastructure and maintenance in operational conditions.

This guide explains how to connect to a PostgreSQL database instance with one of the world's most famous Open Source management tool for PostgreSQL: pgAdmin.

Requirements

Concept

A PostgreSQL instance can be managed through multiple ways. One of the easiest, yet powerful, is to use a Command Line Interface (CLI), as shown in our guide: Connect to PostgreSQL with CLI or by using programming languages, such as PHP or Python.

Another way is to interact directly using a management tool for PostgreSQL: pgAdmin.

In order to do so, we will need to install pgAdmin, then configure our Public Cloud Databases for PostgreSQL instances to accept incoming connections, and finally configure pgAdmin 4.

Instructions

Installation

To interact with your PostgreSQL instance with pgAdmin 4 you need to install it.

Please follow the official pgAdmin to get the latest information.

We are now ready to learn how to connect to our PostgreSQL instance.

Connect with pgAdmin 4

Configuration

Once logged in pgAdmin, from the Servers dashboard view select Add new server.

pgAdmin Dashboard view

In the Create - Server dialog of the General tab, fill in the Name field.

Create - Server General tab

Then select the Connection tab and fill in the following fields with the collected credentials:

  • Host
  • Port
  • Maintenance database
  • Username
  • Password

Create - Server Connection tab

Finally, select the SSL tab and set the SSL Mode to Require.

Create - Server SSL tab

If needed you can adjust the connection timeout in the Advanced tab.

Once saved, select your server in the servers list on the left. In the Dashboard view, you can observe that the connection is active:

Connection Dashboard view

pgAdmin has useful functions such as:

Go further

Visit our dedicated Discord channel: https://discord.gg/PwPqWUpN8G. Ask questions, provide feedback and interact directly with the team that builds our databases services.

Join our community of users on https://community.ovh.com/en/.


¿Le ha resultado útil esta guía?

Si lo desea, también puede enviarnos sus sugerencias para ayudarnos a mejorar nuestra documentación.

Imágenes, contenido, estructura...: ayúdenos a mejorar nuestra documentación con sus sugerencias.

No podemos tratar sus solicitudes de asistencia a través de este formulario. Para ello, haga clic en "Crear un tíquet" .

¡Gracias! Tendremos en cuenta su opinión.


Otras guías que podrían interesarle...

OVHcloud Community

¡Acceda al espacio de la OVHcloud Community! Resuelva sus dudas, busque información, publique contenido e interactúe con otros miembros de la comunidad.

Discuss with the OVHcloud community

A partir del 1 de enero de 2015, con arreglo a la Directiva 2006/112/CE modificada, los precios IVA incluido pueden variar según el país de residencia del cliente (por defecto, los precios con IVA incluyen el IVA español vigente).