Install from database dump - SACGF/variantgrid GitHub Wiki

VG GRCh37/GRCh38 VEP version 112 (RefSeq) on 2024-08-06

Download dump

Data has been installed, migrations run and annotation performed (on ClinVar variants), which reduces the amount of work needed to install

Setting up database

You need to have created a database - see Install step "Create DB" ie:

sudo su postgres -c "psql < variantgrid/scripts/dbscripts/pgsql_database_create.sql"

Restoring dump

# You need to run this as postgres user to have permissions
wget https://variantgrid.com/download/vg_test_dump-2024-08-06.sql.gz
zcat vg_test_dump-2024-08-06.sql.gz | psql -d snpdb

Annotation Versions

Annotations used correspond to:

https://ftp.ensembl.org/pub/release-112/variation/indexed_vep_cache/homo_sapiens_refseq_vep_112_GRCh37.tar.gz https://ftp.ensembl.org/pub/release-112/variation/indexed_vep_cache/homo_sapiens_refseq_vep_112_GRCh38.tar.gz