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]> 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]> > Reply-To: <[email protected]> > Date: Sunday, November 22, 2015 at 12:51 AM > To: <[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 > >
