Connecting to Greenplum®

Can I connect to the DB via SSH and get superuser permissions?Can I connect to the DB via SSH and get superuser permissions?

No, you cannot connect via SSH, nor can you get superuser permissions. This is done for the sake of security and user cluster fault tolerance because direct changes inside hosts can render them completely inoperable. However, you can connect to the DB as an admin user with the mdb_admin role. The privileges it has matches 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 Managed Service for Greenplum® databases using standard DBMS methods.

Learn more about connecting to clusters.

What do I do if I get the revocation check error when using PowerShell to obtain an SSL certificate?What do I do if I get the 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, when connecting to the website, the service failed to check whether or not the website’s certificate is on the list of revoked certificates.

To fix this error:

• Make sure the corporate network settings do not block the check.

• 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 Managed Service for Greenplum® using rules.

For more information, see User authentication.

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