How to run an indexer node?
Running an indexer node is another option outside of using Docker or having a project hosted for you at SubQuery Projects. It requires more time and effort but will enhance your understanding of how SubQuery works under the covers.
Running an indexer node on your infrastructure will require the setup of a Postgres database. You can install Postgres from here and ensure the version is 12 or greater.
Then to run a SubQuery node, run the following command:
npm install -g @subql/node
-g flag means to install it globally which means on OSX, the location will be
Once installed, you can check the version by running:
> subql-node --version 0.19.1
Setting DB configs
Next, you need to set the following environmental variables:
export DB_USER=postgres export DB_PASS=postgres export DB_DATABASE=postgres export DB_HOST=localhost export DB_PORT=5432
Of course, if you have different values for the above keys, please adjust accordingly. Note that the
env command will display the current environment variables and that this process only sets these values temporarily. That is, they are only valid for the duration of the terminal session. To set them permanently, store them in your
Indexing a project
To start indexing a project, navigate into your project folder and run the following command:
subql-node -f .
If you do not have a project handy,
git clone https://github.com/subquery/subql-helloworld. You should see the indexer node kick into life and start indexing blocks.
If you navigate to Postgres, you should see two tables created.
public.subqueries only contains 1 row which the indexer checks upon start up to “understand the current state” so it knows where to continue from. The
starter_entities table contains the indexes. To view the data, run
select (*) from subquery_1.starter_entities.