Information and Links on this page is available to registered user only.  
GP_Toolkit Schema Greenplum Database Quick Facts Greenplum Books Greenplum Database - Common Terminology Join our Linkedin Group

Greenplum Database Utilities
Book Preview

Greenplum Database Beginners Guide
Book Preview

Greenplum DBA Handbook
Book Preview

What's new in Greenplum database 4.3?

Greenplum Database 4.3 Supported Platforms

Deprecated feature in Greenplum database 4.3

Changed Features in Greenplum Database 3.0

Greenplum Database 4.3 Upgrade Checklist

Upgrading Greenplum Database to 4.3

Troubleshooting a Failed Upgrade

Greenplum Database System Catalog
Tables and Views

Greenplum Database Supported
Data Types

Greenplum Database Supported
Character Set

Investigating Error Messages in Greenplum

Gathering Information for Greenplum Support

Known Issues in Greenplum Database

Resolved Issues in Greenplum Database 4.3

Greenplum Database Pocket Reference
Coming soon!

Greenplum Database Performance Tuning
Coming soon!

Greenplum Database Backup and Restore
Coming soon!
Auditing and reporting: enabling audit log | enable/disable user connection log | audit log views | configuring audit logs
Migrating to Greenplum: Oracle to greenplum | DCA to DCA Transfer of Data 
Greenplum database tools and utilities: gpfdist | gpload | pgadmin3
Greenplum database troubleshooting: connection problem | database locks | long running SQL | resource utilization 
Greenplum database logs: Log locations | reading the log | log parameters | archiving log files
Greenplum database environment building blocks: 
DCA | DIA | Data Domain | Greenplum HD | Command Center
System Level schemas in Greenplum: information_schema | pg_catalog | gp_toolkit | pg_toast | pg_bitmapindex | pg_aoseg
Greenplum database FAQ: Greenplum DBA FAQ | Database Users FAQ|Performance Issues FAQ
Greenplum database best practices: 
Greenplum Database Env - Best Practices | DCA/Greenplum Database Security- Best practice
Managing workload and resources: Enable workload management | Configure workload management | Resource Queues
Greenplum database performance: Query Performance in Greenplum 
| Greenplum database optimization - tips and tricks
Configuration Parameters: pg_hba.conf configuration param | View settings of configuration param | Setting Configuration parameter
Managing workload and resources: enable workload management | configure workload management | Resource Queues
Backup and Restore: Backup Greenplum database | Restore Greenplum Database | Backup a single table/schema in Greenplum | Restore a single table/schema in Greenplum 
Data Domain command reference | Greenplum Database Compatibility Matrix

Hostfiles created by the DCA Setup utility 
Configuration files are text files that contain the hostnames of servers that occupy quarter,
half, or full rack configurations. The file used depends on the desired function. See below for a description of each configuration and host file.
The hostfiles are located at $ /home/gpadmin/gpconfigs
1. gpexpand_map : Expansion MAP file created during the dca_setup option Expand the DCA. It’s purpose is to during GPDB reallocate primary and mirror instances on the new hardware.
2. gpinitsystem_map : MAP file used during installation of GPDB blocks to assign primary and mirror segments to each server.
3. hostfile : Contains one hostname per server for ALL servers in the system. Includes GPDB, DIA and HD (if present).
4. hostfile_segments : Contains the hostnames of the segment servers of all GPDB blocks.
5. hostfile_gpdb : Contains the hostnames for GPDB servers.
6. hostfile_dia : Contains the hostnames of the DIA servers.
7. hostfile_hadoop : Contains the hostnames of the Hadoop servers.
8. hostfile_hdm : Contains the hostnames of all Hadoop Master servers.
9. hostfile_hdw : Contains the hostnames of all Hadoop Worker servers.
10. hostfile_hdc : Contains the hostnames of all Hadoop Compute servers.

Default Ports for Customer Networks
Port Application
22 SSH
5432 The default port number of the Greenplum Database server running on the master host.
28080 Command Center / GP Performance Manager
8080 The default HTTP port for Greenplum Chorus

DCA utilities
1. dca_setup
2. dca_shutdown
3. dca_check
4. dca_healthmon_ctl
5. dca_blinker
6. gppkg

Default user names and passwords: 
component user password
Master Servers BMC root user For a new unconfigured server: password

For an existing configured server:sephiroth
root changeme
gpadmin changeme

Interconnect, admin changeme
Greenplum DCA
Greenplum DIA 
Data Domain
Helpful UNIX Commands for Greenplum DBA's
Helpful SQL queries for Greenplum DBA's
Helpful commands and utilities for Greenplum DBA's
Greenplum Database Management Utilities
Greenplum Database Client Utility
Greenplum Database 
Release Notes
Quick Reference
Tools and Utilities

Greenplum Chorus

Installing the greenplum database

Installation Management Utilities

Common Terminology in Greenplum Database

Greenplum Database Maximum Limits

SQL Command Reference

Management Utility Reference

Client Utility Reference

Environment Variables

Expanding a Greenplum System

Routine System Maintenance Tasks

External Tables for data loading and unloading

Greenplum Configuration Parameters

Greenplum Oracle Compatibility

Checking database activity

Greenplum Workload Management

Greenplum Command Center

Transforming XML Data

Partitioning in Greenplum

Troubleshooting DCA issues