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

You can connect to Greenplum® databases using native DBMS connection 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 indicates that the verification of the website’s certificate against the revocation list failed during the connection attempt.

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.