>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 Storing policies Storing Ranger Users and Groups 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
