We have installed HDP 18.104.22.168 (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?
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
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!
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-22.214.171.124/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:
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.