A Web Portal for Greenplum Database Professionals!

Search this site
  • GreenplumDBA Home
  • GreenplumDBA Members Club
  • GreenplumDBA LinkedIn Group
  • DBARef.com
  • Liability Disclaimer
  • Pivotal GPDB Documents
  • DBA Scripts Download - Members Only

    Getting Started with Greenplum Database
    Installing Greenplum Database
    Configuring Greenplum Database


    Securing your database
    Allowing Connections to Greenplum Database
    Securing Greenplum Database


    MPP Data Models 
    Greenplum Database Quick Facts
    Gpfdist 


    Set Database Environment 
    Set Environment variables and Path  
    Create Database 
    Create Roles (users and group roles)  
    Create Resource Queues  
    Granting Privilege and Role


    Schema Development 
    Schema
    Tables/External Tables
    Views
    Functions
    PSQL


    Migrating to Greenplum
    Oracle to Greenplum
    PostgreSQL to Greenplum


    Monitoring and Maintenance
    gp_toolkit Schema
    pg_catalog schema


    Reporting
    Sachi's AWR Report for Greenplum Database
    Schema Size

    Greenplum database performance tuning
    Best practice
    Tuning the environment
    Tuning configuration parameters
    Tuning SQL
    Tuning data models

    Installing Greenplum Tools and Utilities


    1. Installing Greenplum Connectivity Tools 
    2. Installing Greenplum Load Tools
    3. Installing Greenplum Client Tools
    4. Installing Greenplum Command Center
    5. Installing PgAdmin3
    6. Installing Greenplum Chorus



    Comments
    Copyright©2012-18 http://www.greenplumdba.com/ All rights reserved. 
    Contact us. Email: gpdba@greenplumdba.com
    First they ignore you, then they laugh at you, then they fight you, then you win! - Mahatma Gandhi
    QUICK REFERENCES: 
    DCA  | DIA  |  DATA DOMAIN  | GPDB |  COMMAND CENTER  | PGADMIN3  | GEMFIRE  | GREENPLUM CHORUS | PIVOTAL VRP | GPDB ADMIN UTILITIES

    Sign in|Recent Site Activity|Report Abuse|Print Page|Powered By Google Sites