Amur blockchain — PostgreSQL sync scripts

A set of scripts to download and update Amur blockchain history data into a PostgreSQL 10.x database.

Usage

1. Clone the repository, install dependencies.

   npm install

2. Create config.yml file in the project, using config.example.yml for reference.

3. In PostgreSQL, create empty database, initialize it using schema.sql in the project root

4. ⬇️ To download a range of blocks to database:

   npm run download {start} {end},
   # for example
   npm run download 1 100000

   Blocks from the range get inserted in a single transaction, so either all get inserted, or none. In our experience ranges of 10000—100000 work best.

5. 🔄 To keep your database up-to-date:

   npm run update

   This is a continuous script, so you may want to run it in the background. We recommend using some kind of process manager (e.g. pm2) to restart the process on crash.