Dolibarr v16 PostgreSQL Table Restore

Job ID: 39771759

Budget: $30 – $250 USD

I’m running Dolibarr ERP v16 on a PostgreSQL back end and only a handful of tables were affected by a recent issue. I have fresh pg_dump backups and filesystem snapshots; I now need those specific tables extracted from backup and cleanly re-introduced into the live database without touching anything else.

Here’s what I need done:
• Examine the available dumps to confirm they’re intact.
• Extract the tables I’ll specify at the start of the job (most likely invoices, customers, products).
• Restore them into the production database, ensuring constraints, indexes, and sequences remain consistent.
• Validate that Dolibarr starts normally and the restored data appears correctly.

Acceptance criteria:
• Only the chosen tables are rolled back; all other data stays untouched.
• Dolibarr opens with zero SQL or PHP errors.
• Sequences and foreign-key relationships are in sync.
• A concise shell-command log and notes on any config changes are provided.

You should be comfortable with PostgreSQL (pg_dump/psql), transactional restores, and ideally have experience with Dolibarr’s schema. Access will be via SSH on a staging copy first, then production once verified. Please tell me your turnaround time and any questions.