This section contains information for installing the Greenplum data loading programs on your Windows machine and for enabling Greenplum Database to accept remote client connections:
See the Greenplum Database Release Notes for the list of currently supported platforms for the Load Tools.
Parent topic: Greenplum Database Load Tools for Windows
The Greenplum loader program (gpload.py
) for Windows requires Python 2.5.4 (32-bit version) to also be installed on your machine. If you do not have an installation of Python, you can get one from https://www.python.org.
Note: The 64-bit version of Python is not compatible with the Greenplum loader program for Windows.
python Load Tools for Windows-2.5.4.x.msi
package to launch the installer.C:\Pythonxx
. Click Up or New if you want to choose another location. Click Next.The Greenplum loader installer installs the following loader programs:
gpload.py
)Download the greenplum-clients-<version>-WinXP-x86_32.msi
package from Broadcom Support Portal under the specific Greenplum release.
NoteFor more information about download prerequisites, troubleshooting, and instructions, see Download Broadcom products and software.
Follow the instructions in Verifying the Greenplum Database Software Download to verify the integrity of the Greenplum Loaders software.
Double-click on the greenplum-clients-<version>-WinXP-x86_32.msi
package to launch the installer.
Click Next on the Welcome screen.
Click I Agree on the License Agreement screen.
By default, Greenplum loader will be installed into greenplum-db-<version>
. Click Browse to choose another location.
Click Next.
Click Install to begin the installation.
Click Finish to exit the installer.
Your Greenplum loader installation contains the following files and directories:
gpload.py
and gpfdist.exe
)gpload.py
Greenplum provides a batch program (greenplum_loaders_path.bat
) to set the required environment settings for Greenplum loader (located in greenplum-db-<version>
by default).
Open a Windows command prompt (Start > Run and type cmd
).
At the command prompt, go to the directory where you installed Greenplum loader. For example:
cd \"Program Files"\Greenplum\greenplum-loaders-<version>
dir
Execute the greenplum_loaders_path.bat
program:
greenplum_loaders_path.bat
Verify that you can execute the gpload.py
program:
gpload.py -?
The loader command-line tools also require several connection parameters in order to be able to connect to a Greenplum database. In order to save some typing on the command-line, you can optionally create the following environment variables in your Windows Control Panel.
PGDATABASE
— The name of the default Greenplum database to connect to.PGHOST
— The Greenplum Database master host name or IP address.PGPORT
— The port number that the Greenplum master instance (postmaster process) is running on.PGUSER
— The default database role name to use for login.In Windows Explorer, go to C:\Control Panel
.
Double-click the System icon.
On the Advanced tab, click Environment Variables (bottom).
Click New.
Define the new environment variable. For example:
Click OK.
In order for Greenplum Database to be able to accept remote client connections, you must configure your Greenplum Database master so that connections are allowed from the client hosts and database users that will be connecting to Greenplum Database.
Make sure that the pg_hba.conf
file of the Greenplum Database master is correctly configured to allow connections from the users to the database(s) using the authentication method you want. For details, see "Editing the pg_hba.conf File" in the Greenplum Database Administration Guide, and also see the Greenplum Database Security Configuration Guide.
Make sure the authentication method you choose is supported by the client tool you are using.
If you edited pg_hba.conf
file, the change requires a server reload (using the gpstop -u
command) to take effect.
Make sure that the databases and roles you are using to connect exist in the system and that the roles have the correct priviliges to the database objects.