For AI agents: the complete documentation index is available at https://docs.us.ovhcloud.com/en/llms.txt, the full documentation bundle is available at https://docs.us.ovhcloud.com/en/llms-full.txt, and this page is available as Markdown at https://docs.us.ovhcloud.com/en/public-cloud/databases/postgresql-connect-pgadmin.md.
  • English

PostgreSQL® - Connect with pgAdmin

View as Markdown

Learn how to connect to a PostgreSQL® database instance with one of the world's most famous Open Source management tools for PostgreSQL®: pgAdmin.

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.

 

Requirements

 

Concept

A PostgreSQL® instance can be managed in 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.

To do so, we will need to install pgAdmin, configure our 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.

Info

This guide was created using version 7.5 of pgAdmin 4. More recent versions may look different than the images used below.

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

 

Connect with pgAdmin 4

Configuration

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

Pg administration 4 home page

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

PgAdmin - step 2

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

  • Host
  • Port
  • Maintenance database
  • Username
  • Password

PgAdmin - step 3

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

PgAdmin - step 4

Info

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:

PgAdmin - step 5

Info

pgAdmin has useful functions such as:

 

Go further

Visit the GitHub examples repository to find out how to connect to your database with several languages.

Browse all the Databases guides.

Browse the rest of the OVHcloud US documentation for guides on our other products and services.

Learn more about Managed Databases on the OVHcloud US website.

OVHcloud Managed Databases and Analytics:

  • Grafana® is a registered trademark of Grafana Labs and is used with the permission of Grafana Labs. OVH SAS and its subsidiaries are not affiliated with or endorsed by Grafana Labs.
  • Kafka® is a registered trademark of The Apache Software Foundation and has been licensed for use by OVHcloud, who has no affiliation with and is not endorsed by The Apache Software Foundation.
  • MongoDB® is a registered trademark of MongoDB, Inc.
  • MySQL® is a registered trademark of Oracle and/or its affiliates.
  • PostgreSQL® is a registered trademark of the PostgreSQL Community Association of Canada.