Ticket #475 (closed defect: fixed)

Opened 3 years ago

Last modified 2 years ago

create production database backup script

Reported by: work@… Owned by: work@…
Priority: critical Milestone: 0.8.6
Component: Unknown Version: 0.8.3
Keywords: Cc:
Product: Operating system:
URL: Hardware:

Description

Create a script that dumps the PostgreSQL database and scp's it to an external backup server

Change History

  Changed 3 years ago by work@…

Also include #478 in backup cycle

  Changed 3 years ago by work@…

  • owner changed from work@… to business@…
  • status changed from new to assigned

Resolved, starting working on documentation as well in: ServerAdministration

  Changed 3 years ago by business@…

Works fine, backups are correctly created. However I propose to use --format=c as argument for pg_dump to get compressed backups.

  Changed 3 years ago by business@…

  • owner changed from business@… to work@…

follow-up: ↓ 6   Changed 2 years ago by business@…

  • milestone changed from 0.8.4 to 0.8.6

metabolomicsModule should also be backed up

in reply to: ↑ 5   Changed 2 years ago by business@…

including MongoDB

  Changed 2 years ago by work@…

  • status changed from assigned to closed
  • resolution set to fixed

done

Note: See TracTickets for help on using tickets.