Zoomdata Version

Installing and Setting Up Zoomdata's Metadata Store

You install and set up Zoomdata's metadata store before you install Zoomdata components, regardless of the technique used to install the components (using the installation script or an alternative installation method).

Before the Zoomdata components can be installed in the target server, you must 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, click to contact Technical Support for further guidance.

Optionally, if the target server on which Zoomdata will be installed does not have Internet access, read Obtaining the Installation Package Without Internet Access .

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

Configuring PostgreSQL involves defining authentication and connection parameters, restarting PostgreSQL, establishing login credentials for the Zoomdata user, and creating metadata space for the Zoomdata server and services.

Setting up PostgreSQL

The instructions to set up PostgreSQL as Zoomdata's metadata store differs depending on the Linux operating system used by the target server. Select a topic below:

PostgreSQL Setup for CentOS v6

  1. Install the PostgreSQL repository and the PostgreSQL server by running the following commands:

    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. Enable automatic Postgres server startup.

    sudo chkconfig postgresql-9.5 on
  4. Start the PostgreSQL server.

    sudo service postgresql-9.5 start
  5. Complete the steps described in Configuring PostgreSQL to complete the setup process.

PostgreSQL Setup for CentOS v7

  1. Install the PostgreSQL repository and the PostgreSQL server by running the following commands:

    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
  5. Complete the steps described in Configuring PostgreSQL to complete the setup process.

PostgreSQL Setup for Ubuntu v14 and v16

  1. Install the PostgreSQL repository and the PostgreSQL server by running the following series of commands:

    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 these commands will also create the PostgreSQL database cluster, enable automatic PostgreSQL server startup; and start PostgreSQL.

  2. Complete the steps described in Creating the Zoomdata User to complete the setup.

Configuring PostgreSQL

If you installed Zoomdata's metadata store on a server running CentOS, complete the configuration steps below. If the server is running Ubuntu, ignore these instructions and skip to Creating the Zoomdata User.

Configuring CentOS

If you install Zoomdata in a CentOS environment, make the following configuration changes.

  1. Change authentication to MD5.

    sudo vi /var/lib/pgsql/9.5/data/pg_hba.conf
  2. 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
  3. Restart PostgreSQL.

    In CentOS v6 environments, run:

    sudo service postgresql-9.5 restart

    In CentOS v7 environments, run:

    sudo systemctl restart postgresql-9.5

Creating the Zoomdata User

  1. For all Linux operating systems, create the Zoomdata user in PostgreSQL. Run the following command:

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

    Substitute the user name and password for <db_username> and <db_password>.

  2. Create the stores that will hold the Zoomdata metadata, scheduler data, upload data, and keyset data. Run the following series of commands, substituting the user name for <db_username>:

    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>
    sudo -u postgres -H psql -c "CREATE DATABASE\"zoomdata-upload\" WITH OWNER <db_username>
    sudo -u postgres -H psql -c "CREATE DATABASE\"zoomdata-keyset\" WITH OWNER <db_username>

Was this topic helpful?