Lune - postgres 9.3.5 should work fine. From: Lune Silver <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Monday, November 23, 2015 at 1:00 PM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: Re: Question regarding postgresql pre-requisite
Hello. Indeed I wanted to use postgresql because I am already using postgresql for other components like hive, oozie and ambari. I prefer to have not too many technologies in my cluster. I plan on using postgresql 9.3.5 because this is already the version I am using. For auditing, is it ok to store the data in the hdfs on the audited cluster ? Best regards. Lune Le 23 nov. 2015 18:54, "Don Bosco Durai" <[email protected]<mailto:[email protected]>> a écrit : >I sent this mail regarding to the postgresql pre-requisites in the >documentation. Which database are you planing to use? If it is MySQL or others, then you don't need postgresql. Probably Ranger team needs to update the document to make sure users don't assume that postgres is pre-requisite. If you are starting fresh and don't have any specific preference for database, then I would suggest to use MySQL. It is easy to start and widely used in the Ranger community. Saying, I don't think Postgress shouldn't be an issue. But I have not used it. So someone else will have to answer your questions regarding versions supported. For storing auditing, I would strongly recommend Solr and HDFS. HDFS for long term archival and Solr real-time querying. Thanks Bosco From: Lune Silver <[email protected]<mailto:[email protected]>> Reply-To: <[email protected]<mailto:[email protected]>> Date: Sunday, November 22, 2015 at 12:51 AM To: <[email protected]<mailto:[email protected]>> Subject: Fwd: Question regarding postgresql pre-requisite Hello everyone. I sent this mail regarding to the postgresql pre-requisites in the documentation. Here is the concerned part : RDBMS MySQL 5.7+ Oracle - latest Postgres - latest SQL Server - latest 1. Storing policies 2. Storing Ranger Users and Groups 3. Storing Audit Logs (Optional) My questions are the following : Q1 - I don't have the latest postgresql version on the server hosting the postgresql server and database. I have postgresql 9.3.5. Will I encounter problem ? Q2 - The postgresql database will be hosted on another host than the one hosting ranger components. I read this is possible from Ranger 0.5.0. Mayyou just confirm this please ? Best regards. Lune
