Greenplum: how to configure the Greenplum with LDAP authentication

Products

• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire

Issue/Introduction

This guide will show you how to configure the Greenplum with LDAP authentication.

 

 

Resolution

• In this example, we supposed you have a LDAP server and there is a user:

cn=user02,ou=users,dc=example,dc=com

 

• Create a user called user01 in the greenplum

createuser user01

 

• Configure the pg_hba.conf as below:

The ldapserver is installed in data74 and the port is 1389.

 

• Reload the configuration

gpstop -u

 

• Test the LDAP authentication with the psql