JsInfo

Generate migrations

If you make changes to the schema, make migrations:

make create_migrations

Create db

sudo -u postgres dropdb jsinfo
sudo -u postgres createdb jsinfo

sudo -u jsinfo psql

Backup

# Dump
sudo -u jsinfo pg_dump -Fc > db.dump

# Recover
pg_restore -d postgres://localhost:5432/jsinfo jsinfo_db.dump

# Dump for GCP import
sudo -u jsinfo pg_dump --format=p --no-owner --no-acl jsinfo > dump.sql

Run

make run_indexer
make run_query

Docker

make docker_build
make docker_compose