I tried a PostgreSQL 8.3 beta and Jena had problems with it, as 8.3 is
stricter in the parsing of some prepared statement with respect to
their type (you cannot do "... WHERE ? = 3" if you pass a
ps.setString() to it).
Consequently, at the moment you cannot put relations in PostgreSQL 8.3.
Florent
On 11 Feb 2008, at 11:14, Olivier Grisel wrote:
Haim Ashkenazi a écrit :
Hi
I'm installing Nuxeo EP and want to use postgresql as backend. I've
read the related part of the administrator's guide and the postgresql
section of the "howto's". I have a few questions regarding this
setup:
1. I've used postgresql 8.2 (which is the default for ubuntu). is
it OK?
Yes. 8.3 is now released too, we have not tried it yet but it should
work too
(with a performance improvement as well).
2. I still have 2 files that are not documented in the admin guide:
nxsqldirectory-ds.xml and nxcomment-jena-ds.xml. do I just convert
them like I did the others? do they need other settings?
Yes.
3. The documentations use the "postgres" user as the database user. I
created another user since "postgres" is the admin user and I don't
want applications to use it. is it OK?
Yes + the fact that for security reasons postgres should not be able
to login
remotely (by network connection) but only by the unix socket for
security
reasons (see pg_hba.conf for details). The Nuxeo documentation
should be updated
to fix that issue.
--
Olivier
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
--
Florent Guillaume, Director of R&D, Nuxeo
Open Source Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
