Installing Apache Ranger
Also available as:
PDF

Configure a Ranger DB: PostgreSQL

How to configure your PostgreSQL database instance for Ranger.

A MySQL/Oracle/PostgreSQL/Amazon RDS database instance must be running and available to be used by Ranger.

If you are using Amazon RDS, see “Configure an Amazon RDS Database Instance for Ranger: Prerequisites”.

  1. On the PostgreSQL host, install the applicable PostgreSQL connector:
    OptionDescription
    RHEL/CentOS/Oracle Linux yum install postgresql-jdbc*
    SLES zypper install -y postgresql-jdbc
  2. Confirm that the .jar file is in the Java share directory. ls /usr/share/java/postgresql-jdbc.jar.
  3. Change the access mode of the .jar file to 644: chmod 644 /usr/share/java/postgresql-jdbc.jar.
  4. The PostgreSQL database administrator should be used to create the Ranger databases. The following series of commands could be used to create the rangerdba user and grant it adequate privileges:
    echo "CREATE DATABASE $dbname;" | sudo -u $postgres psql -U postgres
    echo "CREATE USER $rangerdba WITH PASSWORD '$passwd';" | sudo -u $postgres psql -U postgres
    echo "GRANT ALL PRIVILEGES ON DATABASE $dbname TO $rangerdba;" | sudo -u $postgres psql -U postgres
    Where:
    • $postgres is the Postgres user.

    • $dbname is the name of your PostgreSQL database.

  5. Set the jdbc/driver/path based on the location of the PostgreSQL JDBC driver .jar file. This command must be run on the server where Ambari server is installed. ambari-server setup --jdbc-db={database-type} --jdbc-driver={/jdbc/driver/path}.
    ambari-server setup --jdbc-db=postgres --jdbc-driver=/usr/share/java/postgresql-jdbc.jar
  6. Run the following command: export HADOOP_CLASSPATH=${HADOOP_CLASSPATH}:${JAVA_JDBC_LIBS}:/connector jar path.
  7. Add Allow Access details for Ranger users:
    1. Change listen_addresses='localhost' to listen_addresses='*' ('*' = any) to listen from all IPs in postgresql.conf.
    2. Make the following changes to the Ranger db user and Ranger audit db user in the pg_hba.conf file. Screenshot of pg_hba.conf file changes.
  8. After editing the pg_hba.conf file, run the following command to refresh the PostgreSQL database configuration: sudo -u postgres /usr/bin/pg_ctl -D $PGDATA reload.
    If the pg_hba.conf file is located in the /var/lib/pgsql/data directory, the value of $PGDATA is /var/lib/pgsql/data.
“Start the Ranger Installation”