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-configure-instance-accept-incoming-connections.md.
  • English

PostgreSQL® - Configure an instance to accept incoming connections

View as Markdown

Learn how to configure your PostgreSQL® instance to accept incoming connections.

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

 

Instructions

Configure your PostgreSQL® instance to accept incoming connections

Before making a connection, we must verify that our PostgreSQL® instance is correctly configured.

Log in to your OVHcloud Control Panel and open your database via the Public Cloud and Databases menus.

Manager - PostgreSQL configure instance accept incoming connections - step 3

 

Step 1: Verify your user roles and password

Select the Users tab. Verify that you have a user with sufficient rights and a configured password. If you don't remember the user's password, you can either create a new user or regenerate the password of an existing user. Be careful! By doing so you will need to update all the places where you already use this user/password pair.

This first user avnadmin comes with the following privileges:

  LOGIN
  NOSUPERUSER
  INHERIT
  CREATEDB
  CREATEROLE
  REPLICATION

We rely on official PostgreSQL® roles and privileges. You can manage them yourself via CLI or code. So far, user grants and privileges management are not supported via the OVHcloud Control Panel or the OVHcloud API.

Please read the official PostgreSQL® documentation to select the right roles for your use case.

To reset the avnadmin password, click on the more options ... to the right of the user, then on Reset password.

Manager - PostgreSQL configure instance accept incoming connections - step 2

To create a new user, click on + Add User, fill out the form, and click the Create User button.

Once created or updated, the user has to be ready and have the status "READY" in the Control Panel.

Manager - PostgreSQL configure instance accept incoming connections

 

Step 2: Authorize incoming connections from the PostgreSQL® client

In this step, select the Configuration tab (Access Control List). By default, a Cloud Database does not accept any form of connection from the outside world. This way, we can help prevent intrusive connection attempts.

In the IPs section and enter the IP of your pgAdmin environment. Click the add + button.

When finished, click Save changes.

Manager - PostgreSQL configure instance accept incoming connections - step 5

Info

If you want to allow connections from the outside, you can enter the IP 0.0.0.0/0. Please use it carefully.

 

Collect required information

Select the Dashboard tab to find the required login credentials in the Connection information section.

Manager - PostgreSQL configure instance accept incoming connections - step 7

Select the Databases tab to get the database name.

Manager - PostgreSQL configure instance accept incoming connections - step 4

Select the Users tab to get the username.

Manager - PostgreSQL configure instance accept incoming connections - step 6

 

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.