Connecting to Greenplum®

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 DB host?How can I access a running DB host?

You can connect to Greenplum® databases using conventional DBMS methods.

Learn more about connecting to clusters in this guide.

What should I do if I get a revocation check error when using PowerShell to obtain an SSL certificate?What should I do if I get a revocation check error when using PowerShell to obtain an SSL certificate?

Here is the full text of the error:

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

This means that the service was unable to verify the website certificate against the revocation list when trying to connect.

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.

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