Thanks Karl. For the record, here's what did it for me: <property name="org.apache.manifoldcf.databaseimplementationclass" value="org.apache.manifoldcf.core.database.DBInterfacePostgreSQL"/> <property name="org.apache.manifoldcf.postgresql.hostname" value="localhost" /> <property name="org.apache.manifoldcf.postgresql.port" value="5432" /> <property name="org.apache.manifoldcf.dbsuperusername" value="myusername"/> <property name="org.apache.manifoldcf.dbsuperuserpassword" value="mypassword"/>
On Thu, Oct 31, 2013 at 12:37 PM, Karl Wright <[email protected]> wrote: > Hi Mark, > > (1) The reason the examples use embeddable databases is because > installation of postgresql is not trivial and varies from platform to > platform. However, converting them to use postgresql is trivial; you need > to set three properties.xml parameters: the database implementation needs > to be org.apache.manifoldcf.core.database.DBInterfacePostgreSQL, and you > need a dbsuperusername and dbsuperuserpassword. The How To Build And > Deploy page describes this. > > (2) As for the proper version of postgresql, we've tested with 9.2 I > believe, but since I'm primarily a windows user and postgresql's windows > install bricked one of my machines, I've been leery of trying that lately. > ;-) Hopefully someone else can let you know whether 9.3 has been tested or > not. OR, you can try it and run the tests yourself: ant test-pg is the > invocation. > > Thanks! > Karl > > > > On Thu, Oct 31, 2013 at 3:30 PM, Mark Libucha <[email protected]> wrote: > >> Hi there, >> >> I'm trying to put together a "Command-driven multi-process model" using >> PostgreSQL (on CentOS). >> >> All the (very nice) examples use other databases, even though PostgreSQL >> is the recommended DB? >> >> Am I missing something, or is there a place I can get an example >> properties.xml and maybe some scripts? If these things are not available, >> that's perfectly OK, but where can I find the names of the properties I >> need to set in properties.xml? >> >> Thanks! >> >> Mark >> >> P.S. One other minor PostgreSQL question. Is 9.1 still the recommended >> version? 9.3 is now available... >> > >
