Put up database dump

How to publish a test database dump for Install from database dump.

A published dump saves new installs a lot of setup, but only if it matches the annotation the code defaults to — otherwise restoring it triggers a full re-annotation. So a dump needs regenerating whenever the default columns_version / VEP version moves (see Annotation Column Versions).

Making one

1. Start from a database with migrations run, contigs/transcripts loaded, and ClinVar variants annotated at the current default annotation version.

2. Dump it (see Database backup and restore):

   sudo su postgres
   pg_dump snpdb | gzip > vg_test_dump-$(date --iso).sql.gz
   

3. Publish to https://variantgrid.com/download/.

4. Update Install from database dump with the new filename, date, VEP version and columns version.

Status

The currently published dump is VEP 112 / columns_version 3 (2024-08-06) and is behind the packaged default — it needs regenerating.