Data Lake for Enterprises

Step 5 - Installing and verifying PostgreSQL (RDBMS)

We have selected PostgreSQL as our relational database, which we would be using both as a metastore as well as a data store for relational information. While the sample described in this chapter may correspond to Sqoop, the installation will be reused across the chapter.

PostgreSQL provides ready packages for almost all the common operating systems. For Linux, the PostgreSQL is available as a standard package that can be installed using native package installer. On CentOS 7, we followed the following steps.

1. Run the following command in terminal:

sudo yum install postgresql-server*

2. Once the database is installed, please initialize the database by running the following:

sudo service ...