• Home
  • Services
    • DBA Support
    • DBA Consultancy Services
    • PostgreSQL Support
    • Website Maintenance
  • Courses

    About Courses

    • List Of Courses
    • Become an Instructor
    Greenplum Database

    Greenplum Database

    $2,000.00 $1,500.00
    Read More
  • Company
    • FAQs
    • About Us
    • Contact
  • Events
  • Portfolio
  • Blogs
    • Blog – RayaFeeL
    • Blog – PostgreSQL Support
    • Blog – PostgreSQL Migration
    • Blog – All DB’s
    • Blog – Linux
    • Blog – Medical Coding
      • Cart

        0

    Have any question?
    (+91)8838953252
    ITsupport@rayafeel.com
    RegisterLogin
    RayaFeeL
    • Home
    • Services
      • DBA Support
      • DBA Consultancy Services
      • PostgreSQL Support
      • Website Maintenance
    • Courses

      About Courses

      • List Of Courses
      • Become an Instructor
      Greenplum Database

      Greenplum Database

      $2,000.00 $1,500.00
      Read More
    • Company
      • FAQs
      • About Us
      • Contact
    • Events
    • Portfolio
    • Blogs
      • Blog – RayaFeeL
      • Blog – PostgreSQL Support
      • Blog – PostgreSQL Migration
      • Blog – All DB’s
      • Blog – Linux
      • Blog – Medical Coding
        • Cart

          0

      Databases

      • Home
      • All courses
      • Databases
      • Greenplum Database
      CoursesIT & SoftwareDatabasesGreenplum Database
      • Greenplum Tutorial
        9
        • Lecture1.1
          Download the Greenplum Sandbox VM 30 min
        • Lecture1.2
          Greenplum Database Architecture 30 min
        • Lecture1.3
          Greenplum Configuration Files ( pg_hba.conf , postgresql.conf ) 30 min
        • Lecture1.4
          Greenplum Database Installation 30 min
        • Lecture1.5
          Greenplum psql Command Line Client 30 min
        • Lecture1.6
          Greenplum Create Users and Roles 30 min
        • Lecture1.7
          Greenplum Create and Prepare Database 30 min
        • Lecture1.8
          Greenplum Create Tables 30 min
        • Lecture1.9
          Greenplum Data Loading 30 min
      • Greenplum Performance Tuning
        7
        • Lecture2.1
          Greenplum Performance Tuning Overview 30 min
        • Lecture2.2
          Greenplum Analyze the tables 30 min
        • Lecture2.3
          Greenplum explain plans 30 min
        • Lecture2.4
          Greenplum Indexes and performance 30 min
        • Lecture2.5
          Greenplum Row vs. column orientation 30 min
        • Lecture2.6
          Greenplum – Check for even data distribution on segments 30 min
        • Lecture2.7
          Greenplum Partitioning 30 min
      • Greenplum Database Analytics
        1
        • Lecture3.1
          Greenplum Database analytics 30 min
      • Greenplum Backup and Recovery Operations
        2
        • Lecture4.1
          Greenplum gpcrondump 30 min
        • Lecture4.2
          Greenplum gpdbrestore 30 min
      • Importing GPDB Sandbox
        1
        • Lecture5.1
          Importing GPDB Sandbox into VMware Fusion 30 min
      • Greenplum Database Books
        1
        • Lecture6.1
          Data Warehousing with Greenplum PDF 30 min
      • Basic Questions and Answer of Greenplum Database
        1
        • Lecture7.1
          Some basic Questions and answer about Greenplum database 30 min

        Greenplum Configuration Files ( pg_hba.conf , postgresql.conf )

        Greenplum is based off of PostgreSQL, thus the way that it looks for configuration information and how to control which connections are allowed to the system should be familiar to those that have worked worked in that environment before.

        pg_hba.conf

        The pg_hba.conf file is located in the base directory of each running Greenplum database process be it the master, primary or mirror segment. In the Sandbox VM the master runs out of the /gpdata/master/gpseg-1/ and this is often captured to the environment variable MASTER_DATA_DIRECTORY and the configuration files can be found there.

        More robust instructions can be found in the Docs under Administrator Guide > Managing Greenplum Database Access > Configuring Client Authentication

        If you look at the entries in this file

        tail /gpdata/master/gpseg-1/pg_hba.conf
        # IPv4 local connections:
        # IPv6 local connections:
        local all gpadmin ident
        host all gpadmin 127.0.0.1/28 trust
        host all gpadmin 172.31.34.119/32 trust
        host all gpadmin ::1/128 trust
        host all gpadmin fe80::80c:b8ff:fe77:f960/128 trust
        local replication gpadmin ident
        host replication gpadmin samenet trust
        local tutorial +users md5

        You will see a set of columns. They correspond to:

        • type of connection
        • database connected to
        • user connecting
        • addresses allowed ( optional depending on type )
        • method of authentication

        For example this line

        local all gpadmin ident

        Indicates that for local connection to all databases the gpadmin will  be authenticated using the identmethodology

        host all gpadmin 172.31.34.119/32 trust

        This rule notes that a host connection to all databases for gpadmin from the 172.31.34.119 IP address will be trusted, thus allowing it to log in without a password.

        If you are using the VM you may need to adjust or add an additional rule if you wish to make a psql connection to the VM. Adding rule such as this one

        host all all 0.0.0.0/0 md5

        Would allow a host connection for all users to connect to all databases originating from any network address ( 0.0.0.0/0 ) to authenticate using the password ( md5 ) the user has been setup within the database.

        This file is only read when the process starts up or is signaled to reread the file. Thus if changes are made the database either needs to be restarted or gpstop can be ran with the -u flag in order to force it to upload changes.

        postgresql.conf

        All of the system setting that can be tweaked and configured as the system comes up are held in the postgresql.conf file. The file is found again in the base directory of each running database process. In the Sandbox VM this is located at /gpdata/master/gpseg-1/postgresql.conf

        There are literally hundreds of different configuration parameters, these are set to default settings that will work for most installations. Adjustment of these parameters is recommend only after you have gained experience working with the database and understand how altering a parameter will change the performance of the database.

        In addition for each segment instance that is running in the cluster they have a postgresql.conf and there are setting that should be kept consistent across all of the hosts in the cluster and others that may be different, depending on if you are on a master or segment system.

        gpconfig is a tool that is packaged with Greenplum and helps alter and maintain postgresql.conf files across and entire Greenplum cluster.

         

        Prev Greenplum Database Architecture
        Next Greenplum Database Installation

        ADVERTISEMENT

        Latest Courses

        PostgreSQL Database

        PostgreSQL Database

        $600.00 $500.00
        Greenplum Database

        Greenplum Database

        $2,000.00 $1,500.00

        Preview Course

        Free

        Latest Posts

        PostgreSQL Patching version 9, 10,11
        10Oct2019
        Tools for PostgreSQL
        16Sep2019
        Postgres user creation and restrict DDL & database access
        13Sep2019

        Recent Forum Topics

        • thought behind whiteboard activity
        • Are you going to take your first ste
        • How to start working on an application?
        • please let me know pre requirements to increase work_mem
        • how to copy some data in one table to another table in postgres

        2ndquadrant.in

        (+91) 8838953252

        ITsupport@rayafeel.com

        Company

        • About Us
        • Contact
        • Our Team
        • Blog

        COURSES

        • List Of Course
        • Become An Instructor
        • Events
        • Postgres Support Blog

        Support

        • DBA Support
        • Consultancy Services
        • Postgres Migration Blogs
        • Forum

        Recommend

        • Groups
        • Login
        • FAQs
        • SignUp

        IT Services by rayafeel.com. Powered by Rayafeel Technologies Pvt Ltd.

        • Privacy
        • Terms

        Become An Instructor?

        Join thousand of instructors and earn money hassle free!

        Get Started Now

        Login with:

        Login with Google Login with Twitter Login with LinkedIn Login with Microsoft

        Login with your site account

        Lost your password?

        Not a member yet? Register now

        Register a new account

        Are you a member? Login now

        Modal title

        Message modal