Getting started with Managed Service for Greenplum®

To get started with the service:

1. Create a cluster.
2. Connect to the DB.

Getting startedGetting started

1. Go to the management console and log in to Yandex Cloud or sign up if not signed up yet.

2. If you do not have a folder yet, create one:

   1. In the management console, select the appropriate cloud in the list on the left.

   2. At the top right, click Create folder.

   3. Enter the folder name. The naming requirements are as follows:

      • The name must be from 3 to 63 characters long.
      • It may contain lowercase Latin letters, numbers, and hyphens.
      • The first character must be a letter and the last character cannot be a hyphen.

   4. (Optional) Enter a description of the folder.

   5. Select Create a default network. This will create a network with subnets in each availability zone. Within this network, a default security group will be created, inside which all network traffic is allowed.

   6. Click Create.

3. Make sure your account has the vpc.user role and managed-greenplum.editor role or higher for creating a cluster.

4. You can connect to a cluster 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).
   • To be able to connect to the cluster from the internet, request public access when creating the cluster.

   Note

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

5. Connect to the VM over SSH.

6. Install the required dependencies and the PostgreSQL client:

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

Create a clusterCreate a cluster

1. In the management console, select the folder where you want to create a DB cluster.
2. Select Managed Service for Greenplum.
3. Click Create cluster.
4. Set the cluster parameters and click Create. For more information, see Creating clusters.
5. Wait until the cluster is ready: its status on the Managed Service for Greenplum® dashboard will change to Running and its state, to Alive. This may take some time.

Connect to the clusterConnect to the cluster

1. To connect to the DB cluster, get an SSL certificate:

   Linux (Bash)/macOS (Zsh)

   Windows (PowerShell)

   mkdir -p ~/.postgresql && \
   wget "https://storage.yandexcloud.net/cloud-certs/CA.pem" \
        --output-document ~/.postgresql/root.crt && \
   chmod 0655 ~/.postgresql/root.crt
   

   The certificate will be saved to the ~/.postgresql/root.crt file.

   mkdir $HOME\.postgresql; curl.exe -o $HOME\.postgresql\root.crt https://storage.yandexcloud.net/cloud-certs/CA.pem
   

   The certificate will be saved to the $HOME\.postgresql\root.crt file.

   Corporate policies and antivirus software can block the download of certificates. For more information, see FAQ.

2. Connect to the primary master host using via a special FQDN using psql:

   psql "host=c-<cluster_ID>.rw.mdb.yandexcloud.net \
         port=6432 \
         sslmode=verify-full \
         dbname=postgres \
         user=<username> \
         target_session_attrs=read-write"
   

3. After connecting, run the following query:

   SELECT version();
   

   The cluster will return the PostgreSQL and Greenplum® versions used.

What's nextWhat's next

• Read about service concepts.
• Learn more about creating a cluster and connecting to a cluster.
• Install the auxiliary utilities.

Greenplum® and Greenplum Database® are registered trademarks or trademarks of VMware, Inc. in the United States and/or other countries.