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:

1. Stopped Nuxeo server.
2. Data directory (/var/lib/nuxeo-dm) replaced: Deleted and restored a copy from the production server to the same location.
3. Restored the SQL dump from the production server: # psql -h localhost -p 5433 -U nuxeodm nuxeodm < nuxeodm-production.sql
4. 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í