You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@manifoldcf.apache.org by Mark Libucha <ml...@gmail.com> on 2013/10/31 20:30:03 UTC

Postgres example?

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...

Re: Postgres example?

Posted by Mark Libucha <ml...@gmail.com>.

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 <da...@gmail.com> 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 <ml...@gmail.com> 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...
>>
>
>

Re: Postgres example?

Posted by Karl Wright <da...@gmail.com>.

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 <ml...@gmail.com> 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...
>