Information and Links on this page is available to DBAref.com 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 Administration, and Aggregation switches ========================================================================= | 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 PSQL |
