Configuring Greenplum Database for Remote Client Access

A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.

Configuring Greenplum Database for Remote Client Access

Greenplum Database does not, by default, accept remote client connections. You must configure Greenplum Database to accept remote connections. This configuration involves identifying each client host system and Greenplum Database role combination to which you want to provide access, and then adding access rules to the pg_hba.conf client authentication configuration file. Refer to Allowing Connections to Greenplum Database for detailed information about configuring remote client access.

Note: Ensure that the authentication method that you configure for a role is supported by the Greenplum Database client program(s) that the role will execute.

In addition to configuring remote client access, you must also ensure that each Greenplum role that you are allowing to connect to the master exists in the cluster, and that the role has the correct privileges to database objects. Managing Roles and Privileges describes configuring Greenplum Database users and granting privileges.