Getting started with Managed Service for PostgreSQL

To get started with the service:

• Create a DB cluster.
• Connect to the DB.

Before you start

1. Go to the management console. Then log in to Yandex.Cloud or sign up if you don't have an account yet.

2. If you don't have a folder yet, create one:

   1. Click Create folder in the Home page of the management console.

   2. Enter the folder name.

      • Length — from 3 to 63 characters.
      • The name may contain lowercase Latin letters, numbers, and hyphens.
      • The first character must be a letter. The last character can't be a hyphen.

   3. Select Create a default network. A network is created with subnets in each availability zone.

   4. Click Create.

3. You can connect to DB clusters from both inside and outside Yandex.Cloud:

   • To connect to a DB cluster from inside Yandex.Cloud, create a VM in the same cloud network as the DB cluster (with Linux or Windows).
   • To be able to connect to the cluster from the internet, request public access to hosts when creating the cluster.

   Note

   The next step assumes that you connect to the cluster from a Linux-based VM.

4. Connect to the VM via SSH.

5. Install the necessary dependencies and the PostgreSQL client:

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

Create a cluster

1. In the management console, select the folder where you want to create a DB cluster.
2. Select Managed Service for PostgreSQL.
3. Click Create cluster.
4. Set the cluster parameters and click Create cluster. This process is described in detail in Creating PostgreSQL clusters.
5. When the cluster is ready, its status on the Managed Service for PostgreSQL dashboard changes to Running and its state to Alive. This may take some time.

Connect to the DB

1. Configure security groups for the cloud network to enable all the relevant traffic between the cluster and the connecting host.

2. To connect to the DB server, get an SSL certificate:

   1. Create a folder:

      $ mkdir ~/.postgresql
      

   2. Get a certificate:

      $ wget "https://storage.yandexcloud.net/cloud-certs/CA.pem" -O ~/.postgresql/root.crt
      

   3. Configure permissions to the certificate:

      $ chmod 0600 ~/.postgresql/root.crt
      

3. Use the psql command to connect:

   $ psql "host=<host address> \
         port=6432 \
         sslmode=verify-full \
         dbname=<DB name> \
         user=<DB user name>"
   

What's next

• Read about service concepts.
• Learn more about creating a cluster and connecting to the database.
• Read questions and answers.