Connecting to databases in Managed Service for PostgreSQL®

​

Prerequisites

1. Create a cluster and securely store the password you specified during creation.
2. To connect to a database, install psql, a PostgreSQL command line client:
   • macOS
   • Ubuntu

   brew install libpq
   echo 'export PATH="/opt/homebrew/opt/libpq/bin:$PATH"' >> ~/.zshrc
   

   After that, restart the terminal.

   sudo apt update && sudo apt install postgresql-client
   
3. To secure connections to databases, install the Nebius AI Cloud certificate:
   mkdir -p ~/.postgresql \
   curl "https://storage.eu-north1.nebius.cloud/msp-certs/ca.pem" \
      -o ~/.postgresql/root.crt \
   chmod 0600 ~/.postgresql/root.crt
   
   This command creates the .postgresql folder, downloads the certificate into it and then sets the access rights to the certificate file.

​

How to connect to a database

​

Details of the connection command

psql "host=<cluster_endpoint> \
  port=5432 \
  sslmode=verify-full \
  dbname=<DB_name> \
  user=<username>" 

• <DB_name>: Default database name that you specified when creating the cluster. If you created another database in this cluster, you can use its name instead.
• <username>: The username you specified when creating the cluster.
  Once you create other databases and users, you can use their names instead.
• <cluster_endpoint>: Depends on where you are connecting from:
  • To connect from the internet, use the public cluster endpoint. You can connect from the internet only if you enabled public access to the cluster when you created it.
  • To connect from other Nebius AI Cloud resources, use the private cluster endpoint.

nebius msp postgresql v1alpha1 cluster get-by-name \
  --name <cluster_name> \
  --format json | jq -r ".status.connection_endpoints.public_read_write"

nebius msp postgresql v1alpha1 cluster get-by-name \
  --name <cluster_name> \
  --format json | jq -r ".status.connection_endpoints.private_read_write"