Zoomdata Version

Install and Set Up Zoomdata's Metadata Store

This article supports the alternative installation options and should be followed after starting the installation process from one of the following articles:

Before the Zoomdata components can be installed in the target server, you first need to install and set up the metadata store that is used in the Zoomdata environment. Zoomdata uses PostgreSQL v9.5 to store its metadata.

Zoomdata uses a packaged PostgreSQL v9.5 database instance to store its metadata and strongly recommends using this instance due to the specific configuration and version employed. If you would like to use another PostgreSQL instance, contact for further guidance.

Optionally, if the target server where Zoomdata is to be installed does not have Internet access, refer to the article Obtaining the PostgreSQL Installation Package for Servers Without Internet Access .

Preparation

Setting up Zoomdata's metadata store entails completing the following steps:

  • Install PostgreSQL and the PostgreSQL server
  • Create the PostgreSQL database cluster
  • Initialize the PostgreSQL database
  • Enable automatic PostgreSQL server startup
  • Start PostgreSQL
  • Configure PostgreSQL, which includes:
    • Setting authentication and connection parameters
    • Restarting PostgreSQL
    • Establishing credentials for the Zoomdata user
    • Creating (metadata) space for the Zoomdata Server and Scheduler service

Setup Instructions

The instructions to set up PostgreSQL as Zoomdata's metadata store differs depending on the Linux OS used by the target server. As such, the guidance in this article is broken out based on the supported operating system. Select from the list of the supported OS options below:

PostgreSQL Setup for CentOS v6

  1. Install PostgreSQL repository and the PostgreSQL server by running the following:
    sudo yum install https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6-x86_64/pgdg-centos95-9.5-2.noarch.rpm

    sudo yum install postgresql95-server
  2. Create the PostgreSQL database cluster.
    sudo service postgresql-9.5 initdb
  3. Initialize the PostgreSQL database.
    /usr/pgsql-9.5/bin/postgresql95-setup initdb
  4. Enable automatic Postgres server startup.
    sudo chkconfig postgresql-9.5 on
  5. Start the PostgreSQL server.
    sudo service postgresql-9.5 start

Complete the setup process by using the Configure PostgreSQL topic below.

PostgreSQL Setup for CentOS v7

  1. Install PostgreSQL repository and the PostgreSQL server by running the following:
    sudo yum install https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-2.noarch.rpm

    sudo yum install postgresql95-server
  2. Create the PostgreSQL database cluster.
    sudo /usr/pgsql-9.5/bin/postgresql95-setup initdb
  3. Enable automatic Postgres server startup.
    sudo systemctl enable postgresql-9.5
  4. Start the PostgreSQL server.
    sudo systemctl start postgresql-9.5

Complete the setup process by using the Configure PostgreSQL topic below.

PostgreSQL Setup for Ubuntu v14 and v16

  1. Install PostgreSQL repository and the PostgreSQL server by running the following:
    sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

    wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

    sudo apt-get update

    sudo apt-get install postgresql-9.5

    sudo /usr/pgsql-9.5/bin/postgresql95-setup initdb

Running the above command lines will also (1) create the PostgreSQL database cluster; (2) enable automatic PostgreSQL server startup; and (3) start PostgreSQL. Complete the setup process by following the Create Zoomdata User instructions below.

Configure PostgreSQL

If you installed Zoomdata's metadata store on a server running CentOS, refer to the configuration steps as provided below. If the server is running Ubuntu, then jump to Configurations for All Linux OS .

Configurations for CentOS

When installing in CentOS environments, you also need to make the following configurations:

Change authentication to md5.

sudo vi /var/lib/pgsql/9.5/data/pg_hba.conf

Change METHOD to md5.

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5

# IPv6 local connections:
host    all             all             ::1/128                 md5

Next, restart PostgreSQL.

For CentOS v6, run:

sudo service postgresql-9.5 restart

For CentOS v7, run:

sudo systemctl restart postgresql-9.5

Configurations for all Linux OS

For all Linux OS, create the Zoomdata user in PostgreSQL:

sudo -u postgres -H psql -c "CREATE USER db_username WITH PASSWORD ' db_password '"

Finally, you create the metadata store for both the Zoomdata Server and the Scheduler service.

sudo -u postgres -H psql -c "CREATE DATABASE \"zoomdata\" WITH OWNER db_username "
sudo -u postgres -H psql -c "CREATE DATABASE \"zoomdata-scheduler\" WITH OWNER db_username "


With Zoomdata's metadata store created and set up, return to the installation article you are using to continue the installation process: