Hi,
I installed a new server to test the production server backup following this instructions http://doc.nuxeo.com/display/public/ADMINDOC/Backup+and+Restore
The new server is identical to the primary server:
- Ubuntu 10.04 LTS 64 bits
- Nuxeo 5.4.2 from Ubuntu nuxeo-dm package
- PostgreSQL 8.4
After the new nuxeo-dm package installation we have a fresh new PostgreSQL database with Administrator user and fresh new data directory under /var/lib/
In order to recover production server to new server:
- Stopped Nuxeo server.
- Data directory (/var/lib/nuxeo-dm) replaced: Deleted and restored a copy from the production server to the same location.
- Restored the SQL dump from the production server: # psql -h localhost -p 5433 -U nuxeodm nuxeodm < nuxeodm-production.sql
- Server started.
SQL dump made in the production server with:
pg_dump -h localhost -p 5433 -U nuxeodm nuxeodm > nuxeodm-production.sql
After the restore, the problem is that I can't login with a production user and password. The error is Too Many Redirects after login.
Maybe the problem is due a bad restore of the SQL dump? I receive a lot of errors like these:
ERROR: relation "rel_srch_ecm_path" already exists
ERROR: insert or update on table "acls" violates foreign key constraint "acls_id_hierarchy_fk"
DETAIL: Key (id)=(14acc6c6-4f95-4865-864d-6a6e25270446) is not present in table "hierarchy".
The solution is to dump into an empty Nuxeo database? Any workaround? 🙂
Thanks!
Regards,
Benjamí
