Vultr DocsLatest Articles

How to Retrieve Connection Details for Vultr Managed Databases for PostgreSQL

Updated on November 27, 2024

Managed database connection details consist of host, port, username, password, default database, connection strings, and SSL certificates. These credentials allow you to connect to the managed databases from your favorite database client or modern programming language libraries. These include the terminal-based front-end to PostgreSQL (psql), PostgreSQL adapter for Python (Psycopg), Go PostgreSQL driver (github.com/lib/pq), and PostgreSQL Driver for PHP (pg_connect).

Follow this guide to manage connection details for Vultr Managed Databases for PostgreSQL using the Vultr Customer Portal, API, or CLI.

  • Vultr Customer Portal
  • Vultr API
  • Vultr CLI

  1. Navigate to Products and select Databases.

  2. Click the target database instance.

    Select Managed Database

  3. Navigate to Connection Details under Overview.

    Connection Details

Copy Connection String

Click Copy Connection String.

Copy Connection String

Copy PostgreSQL URL

Click Copy PostgreSQL URL.

Copy MySQL URL

Download Signed Certificate

Click Download Signed Certificate and save the certificate.

Download Signed Certificate

  1. List all the database instances by sending a GET request to the List Managed Databases endpoint and note the database ID. For example, 43b4c774-5dff-4ac0-a01f-78a23c2205b5.

    console 
    $ curl "https://api.vultr.com/v2/databases" \
    -X GET \
    -H "Authorization: Bearer ${VULTR_API_KEY}"

  2. Send a GET request to the Get Managed Database endpoint and specify a database ID.

    console 
    $ curl "https://api.vultr.com/v2/databases/database_id" \
    -X GET \
    -H "Authorization: Bearer ${VULTR_API_KEY}"

    Visit the Get Managed Database endpoint to view additional attributes to add to your request.

  3. Copy the host, port, user, password, and dbname values.

  1. List all database instances and note the database ID. For instance, d6ac2a3c-92ea-43ef-8185-71a23e58ad8c.

    console 
    $ vultr-cli database list --summarize

  2. Retrieve connection details by specifying the database ID.

    console 
    $ vultr-cli database get database_id

    Run vultr-cli database get --help to view all options.