Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Ranger set up on Postgres

Highlighted

Ranger set up on Postgres

Contributor

Hi,

We have installed HDP 2.3.4.0 (without Ranger) using Ambari over CentOS 6.4 where Ambari is configured over postgres.

We now want to set up Ranger over postgres database on same cluster. Can you please provide us with the steps to configure Ranger on postgres?

3 REPLIES 3

Re: Ranger set up on Postgres

Mentor

Please refer to this security guide in our documentation http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.4.0/bk_Ranger_Install_Guide/content/configuring_...

If you go to the documentation tab of our site, we have a dedicated security section

Re: Ranger set up on Postgres

Contributor

Hi @Artem Ervits, Ambari server is already set up with postgres as the database. As per the link provided above, we have some queries as below : 1) If Amabari server is set up with postgres do we have to follow the steps under http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.4.0/bk_Ranger_Install_Guide/content/configuring_...

2) For Ranger admin setup we will be using postgres and this step requires the DBA password for the DBA user postgres. How can we get the password for postgres user? Link followed is http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.4.0/bk_Ranger_Install_Guide/content/ranger_admin... Looking for your help!

Re: Ranger set up on Postgres

Contributor

@rajdip chaudhuri

Hi, if you want to use PostgreSQL as a repository for both Ambari and Ranger gaining full control over the deployment I suggest to deploy a standalone instance of PostgreSQL (refer to this link for the supported version http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.1.0/bk_Installing_HDP_AMB/content/_database_requ...

) and then use this instance for both. If you have already deployed Ambari with it's own PostgreSQL installation you can easily migrate ambari DB to the new instance. After you moved the DB run the following command:

ambari-server setup

to reconfigure Ambari.

One last thing: Ranger could generate a huge amounts of logs so do not use the DB as landing area of audis if you don't know exactly how much audits you'll have.

Don't have an account?
Coming from Hortonworks? Activate your account here