Connecting to Yandex MPP Analytics for PostgreSQL

Can I connect to a DB over SSH and get superuser permissions?Can I connect to a DB over SSH and get superuser permissions?

No, you cannot connect over SSH, nor can you get superuser permissions. This is for the sake of security and user cluster fault tolerance, since direct changes inside hosts can render them completely inoperable. However, you can connect to a DB as an admin user with the mdb_admin role. The privileges such a user has match those of the superuser. For more information, see The mdb_admin role instead of a superuser.

How can I access a running database host?How can I access a running database host?

You can connect to databases in a Yandex MPP Analytics for PostgreSQL cluster using native DBMS methods.

To learn more about connecting to clusters see this guide.

What should I do if I get a revocation check error when obtaining an SSL certificate via PowerShell?What should I do if I get a revocation check error when obtaining an SSL certificate via PowerShell?

Complete error message:

curl: (35) schannel: next InitializeSecurityContext failed: Unknown error (0x80092012)
The revocation function was unable to check revocation for the certificate

This means that, when connecting to the website, the function was unable to check if its certificate was listed as revoked.

To fix this error:

• Make sure your corporate network policies are not blocking the verification.

• Run the command with the --ssl-no-revoke parameter.

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

How do I set up user authentication?How do I set up user authentication?

You can set up user authentication in Yandex MPP Analytics for PostgreSQL using rules.

For more information, see User authentication.