From: Ian Stuart <Ian.Stuart AT ed.ac.uk>
Date: Mon, 15 Mar 2010 10:35:25 +0000
| Threading: | ↑ [EP-tech] Re: DB support in EPrints 3.2 from mark.gregson AT qut.edu.au • This Message |
Tim Brody wrote: > On Mon, 2010-03-15 at 11:20 +1000, Mark Gregson wrote: >> Thanks Tim. >> >> I assume from this that there are no known differences in the support >> (I'm thinking of EPrints straight out of the box) compared to MySQL >> and the only EPrints related reasons (ie, excluding issues about QUT >> expertise and other organisational-related things) I would want to go >> with Oracle or PostgreSQL is they have had less testing and that any >> additional development we do might be constrained by the annoyances >> listed on the wiki. Does that sound about right? > > The epadmin tool is still MySQL-centric i.e. you have to do some > configuration by hand to talk to Oracle or PostgreSQL. To do anything > with Oracle requires some hackery of environment variables. > > The principle is EPrints should work as well with any of the three > supported DBs. The search code is completely new in 3.2 so is subject to > teething troubles regardless of DB backend (in most cases cachemap > tables are no longer used). From a practical experience: I've just installed an EP3.2.0-rc2 system, and I'm using a Postgres database. To install the Apache, mod-perl & eprints - the database technology is moot (it doesn't care) To install an actual "archive" in the eprints application, you need ↵ the mysql libraries installed. There are no docs in the EPrints postgres package, however the Oracle one has sufficient info to be able to set up postgres with ease.... Deposits are fine, and I've just found a bug in the name lookup tool.... but it works fine having fixed it :) Not tried searching yet ;-) -- Ian Stuart. Bibliographics and Multimedia Service Delivery team, EDINA, The University of Edinburgh. http://edina.ac.uk/ This email was sent via the University of Edinburgh. The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336. *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech *** Archive: http://www.eprints.org/tech.php/ *** EPrints community wiki: http://wiki.eprints.org/