Ticket #475 (closed defect: fixed)

Opened 5 years ago

Last modified 5 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:
Hardware: Operating system:
Product: URL:

Description

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

Change History

comment:1 Changed 5 years ago by work@…

Also include #478 in backup cycle

comment:2 Changed 5 years ago by work@…

  • Status changed from new to assigned
  • Owner changed from work@… to business@…

Resolved, starting working on documentation as well in: ServerAdministration

comment:3 Changed 5 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.

comment:4 Changed 5 years ago by business@…

  • Owner changed from business@… to work@…

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

  • Milestone changed from 0.8.4 to 0.8.6

metabolomicsModule should also be backed up

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

including MongoDB

comment:7 Changed 5 years ago by work@…

  • Status changed from assigned to closed
  • Resolution set to fixed

done

Note: See TracTickets for help on using tickets.