Configuring an External Server to Import Data with gpfdist

To enable data movement between Greenplum databases, you must install and start gpfdist on the Team Studio host.

1. Download the gpfdist package and install it.
2. Copy the gpfdist files from <greenplum installation>/bin/gpfdist to $CHORUS_HOME/vendor/gpfdist-rhel5/bin/A.
3. Copy the following files from <greenplum installation>/lib to $CHORUS_HOME/vendor/gpfdist-rhel5/lib.

   libcom_err.so
   libcom_err.so.3
   libcom_err.so.3.0
   libcrypto.so
   libcrypto.so.0.9.8
   libk5crypto.so
   libk5crypto.so.3
   libk5crypto.so.3.1
   libkrb5.so
   libkrb5.so.3
   libkrb5.so.3.3
   libkrb5support.so
   libkrb5support.so.0
   libkrb5support.so.0.1
   liblber-2.3.so.0
   liblber-2.3.so.0.2.26
   liblber.so
   libldap_r-2.3.so.0
   libldap_r-2.3.so.0.2.26
   libpq.so
   libpq.so.5
   libpq.so.5.3
   libssl.so.0.9.8
   libz.so
   libz.so.1
   libz.so.1.2.3

   Note: Make sure these files are present in the vendor directory each time you upgrade Team Studio.
4. Examine the gpfdist entry in <installation directory>/shared/chorus.properties.

   gpfdist.ssl.enabled= false

5. Set gpfdist.ssl.enabled to true if gpfdist is configured with SSL certificates.
   Note: SSL certificates must be installed on all segment servers.

   gpfdist.url= sample-gpfdist-server

   This URL must be the externally accessible URL that can be resolved from the source and destination servers.

   gpfdist.write_port= 8000
   gpfdist.read_port= 8001
   gpfdist.data_dir= /tmp

6. Start gpfdist with the write_port value and the data_dir value.
7. Start gpfdist with the read_port value and the data_dir value.
8. Restart Team Studio to activate the changes.