Getting started with Managed Service for PostgreSQL®

Modern AI and ML workloads operate with sizable datasets. Managed Service for PostgreSQL allows you to apply its flexibility and dataset management capabilities to enhance the performance of your projects in Nebius AI Cloud. This guide will get you started with Managed Service for PostgreSQL. You will:

Install and configure CLIs to work with Managed Service for PostgreSQL
Create your first cluster
Connect to the cluster
Perform basic operations with a PostgreSQL database

If you want to move data from an external PostgreSQL cluster to a Managed PostgreSQL cluster, use migration or replication.

Prepare your environment

Before moving on with this guide, make sure you have the postgresql package installed. You will need it to connect to your cluster and test a database within it.

Install postgresql package

macOS
Ubuntu

Ensure you have Homebrew installed.
Run the command to install PostgreSQL CLI:
```
brew install libpq
```

Run the command to install PostgreSQL CLI:

sudo apt update && sudo apt install -y postgresql-client

(Optional) Install the Nebius AI Cloud CLI or provider for Terraform

If you want to manage clusters and other Nebius AI Cloud resources in the command line or using Terraform, install and configure one of these tools:

Create a cluster

Web console
CLI
Terraform

In the sidebar, go to Storage → PostgreSQL.
Click Create cluster.
On the page that opens:
1. Specify the Name for your cluster. Do not use spaces in cluster names.
2. Write a short Description of your cluster. For example, .
3. In the Username field, type the username.
4. In the Password field, come up with a secure password. Such a password must contain at least:
  - 8 characters
  - One lowercase character
  - One uppercase character
  - One special character
5. Keep all the other settings with their default values - they will be more than enough for the purposes of this guide.
6. Click Create cluster.

On the Managed Service for PostgreSQL® page, you will see your cluster with the Provisioning status.Please wait until its status changes to Running before trying to perform any operations on your new cluster.

Prepare environment variables:
1. Come up with a name for your Managed Service for PostgreSQL cluster:
  export CLUSTER_NAME=<new_PostgreSQL_cluster_name>
  Do not use spaces in your cluster names.
2. Copy the network ID from the Network section of the web console and save it to an environment variable:
  export NETWORK_ID=<network_ID>
3. Set the credentials for your Managed Service for PostgreSQL database: database name, your username and database password:
  export BOOTSTRAP_DB_NAME=<PostgreSQL_database_name> export BOOTSTRAP_USER_NAME=<username> export BOOTSTRAP_USER_PASSWORD=<database_password>

Run the command to create a cluster:

nebius msp postgresql v1alpha1 cluster create \
  --name $CLUSTER_NAME \
  --description "My first PostgreSQL cluster" \
  --network-id $NETWORK_ID \
  --bootstrap-db-name $BOOTSTRAP_DB_NAME \
  --bootstrap-user-name $BOOTSTRAP_USER_NAME \
  --bootstrap-user-password $BOOTSTRAP_USER_PASSWORD \
  --config-version 16 \
  --config-template-disk-type network-ssd \
  --config-template-disk-size-gibibytes 96 \
  --config-template-resources-platform cpu-e2 \
  --config-template-resources-preset 2vcpu-8gb \
  --config-template-hosts-count 1 \
  --config-public-access

Wait for the operation to complete.

The configuration below assumes that the project is stored in the project_id input variable.For more information about how to get the network ID, see the instructions.

resource "nebius_msp_postgresql_v1alpha1_cluster" "example_cluster" {
  parent_id   = var.project_id
  description = "My first Managed PostgreSQL cluster"
  name        = "postgres_cluster_example"
  network_id  = "<network_ID>"

  bootstrap = {
    db_name       = "<your_postgresql_db_name>"
    user_name     = "<your_username>"
    user_password = "<your_database_password>"
  }

  config = {
    template = {
      resources = {
        platform = "cpu-e2"
        preset   = "2vcpu-8gb"
      }
      disk = {
        size_gibibytes = 96
        type           = "network-ssd"
      }
      hosts = {
        count = 1
      }
    }
    version = "16"

    public_access = true
  }
}

For details about the nebius_msp_postgresql_v1alpha1_cluster Terraform resource, see the provider reference.

Connect to your cluster

Open your cluster’s page.
Under the cluster name, click How to connect.
Follow the instructions in the dialog window.

To check the connection, list all the databases on your cluster with the command:

\l

You should see the following output:

Output

                                List of databases
    Name    |  Owner   | Encoding | Collate | Ctype |        Access privileges         
------------+----------+----------+---------+-------+----------------------------------
 postgres   | postgres | UTF8     | C       | C     | =Tc/postgres                    +
            |          |          |         |       | postgres=CTc/postgres           +
            |          |          |         |       | cnpg_pooler_pgbouncer=c/postgres
 template0  | postgres | UTF8     | C       | C     | =c/postgres                     +
            |          |          |         |       | postgres=CTc/postgres
 template1  | postgres | UTF8     | C       | C     | =c/postgres                     +
            |          |          |         |       | postgres=CTc/postgres

Perform operations with a test database

In this guide, we’ll use the dellstore2 dataset. It contains a fictional store database with products, orders, inventory and customer information.

Download the dellstore2-normal-1.0.tar.gz file from the PostgreSQL website.
Unarchive the file into a folder.
From the folder to which you unarchived the file, connect to your Managed Service for PostgreSQL cluster with the Nebius AI Cloud CLI and create a database on your cluster:
```
CREATE DATABASE dellstore;
```
Upload the dataset from the file onto your cluster:
```
\i dellstore2-normal-1.0.sql;
```

Check if the objects were created successfully:

\d

You should see the following output:

Output

                    List of relations
 Schema |           Name           |   Type   |      Owner  
--------+--------------------------+----------+-----------------
 public | categories               | table    | <your_username>
 public | categories_category_seq  | sequence | <your_username>
 public | cust_hist                | table    | <your_username>
 public | customers                | table    | <your_username>
 public | customers_customerid_seq | sequence | <your_username>
 public | inventory                | table    | <your_username>
 public | items                    | table    | <your_username>
 public | orderlines               | table    | <your_username>
 public | orders                   | table    | <your_username>
 public | orders_orderid_seq       | sequence | <your_username>
 public | products                 | table    | <your_username>
 public | products_prod_id_seq     | sequence | <your_username>
 public | reorder                  | table    | <your_username>
(13 rows)

Write a row into the products table:

INSERT INTO products(
    prod_id,
    category,
    title,
    actor,
    price,
    special,
    common_prod_id
)
VALUES (
    10001,
    42,
    'FUTURE INTELLIGENCE',
    'FORD PREFECT',
    42.42,
    0,
    1978
);

Query the database to see that your row was written correctly:

SELECT * FROM products WHERE prod_id = 10001;

You should get the following output:

 prod_id | category |        title        |    actor     | price | special | common_prod_id 
---------+----------+---------------------+--------------+-------+---------+----------------
   10001 |       42 | FUTURE INTELLIGENCE | FORD PREFECT | 42.42 |       0 |           1978
(1 row)

Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.

Object Storage

Managed Service for PostgreSQL®

Container Registry

Getting started with Managed Service for PostgreSQL®

Prepare your environment

Install postgresql package

(Optional) Install the Nebius AI Cloud CLI or provider for Terraform

Create a cluster

Connect to your cluster

Perform operations with a test database

Object Storage

Managed Service for PostgreSQL®

Container Registry

​Prepare your environment

​Install postgresql package

​(Optional) Install the Nebius AI Cloud CLI or provider for Terraform

​Create a cluster

​Connect to your cluster

​Perform operations with a test database

Prepare your environment

Install postgresql package

(Optional) Install the Nebius AI Cloud CLI or provider for Terraform

Create a cluster

Connect to your cluster

Perform operations with a test database