-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi!
Some time ago I set up nuxeo-ep-5.1.1.GA and did some tests. As my tests were successfull, I then decided to change the persistence layer from using the default DB to use PostgreSQL. I did several additional tests with various test installations which also were successfull. So I then changed both the default-repository configuration as well as all the datasources and additional files as described in various documents on the primary installation. This seemed to work fine: tables were created in the PostgreSQL database automatically and the Nuxeo application did work without problem. Of course my test documents were gone, but that was expected. So the system went into production... But today I found that with this configuration Nuxeo still uses the filesystem-based storage for its documents! Documents are not stored in the database but still in the directory-structure under .../data/NXRuntime/repos/default/ There is some data stored in the database, but not the documents... :-( This of course is a major problem if you want to backup the system, upgrade to a newer nuxeo version, move the application server to a different machine, ... I tried with a fresh installation today and here it works: documents _and_ metadata are stored in the RDBMS, there are only a few index files stored on the filesystem. The fresh installation uses exact the same configuration files for default-repository-config.xml and all the other config files related to persistence as my production installation! So it looks like if you already have some data in a filesystem- based repository you can't switch to a RDBMS based reporitory. Is this true? Now the question arises: How can I get the documents which represent the work of several weeks from the filesystem into the database repository? I don't want to lose all the history, comments, timestamps etc. Any idea? - - andreas - -- Andreas Haumer | mailto:[EMAIL PROTECTED] *x Software + Systeme | http://www.xss.co.at/ Karmarschgasse 51/2/20 | Tel: +43-1-6060114-0 A-1100 Vienna, Austria | Fax: +43-1-6060114-71 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHKHHxxJmyeGcXPhERAt1NAKDBazQ02kp0uMrE7j/uQ129N1QeNgCfbp0S adQaDh8WlWWDsmpkaEj4erU= =velv -----END PGP SIGNATURE----- _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm
