Notable configuration options:
| Option | Default | Description |
|---|---|---|
| --host | localhost | state-history-plugin host to connect to |
| --port | 8080 | state-history-plugin port to connect to |
| --schema | chain | Database schema to fill |
When running it for the first time, use the --create option to create the schema and tables.
To wipe the schema and start over, run with --drop --create.
fill-postgresql will start filling the database. It will track real-time updates from snaxnode after it catches up.
Use SIGINT or SIGTERM to stop.
Install the following:
- cmake
- A C++17 compiler
- Boost 1.58
- libpqxx
- libpq
Run the following.
git submodule update --init --recursive
mkdir build
cd build
cmake ..
make -j
Run the following on a fresh Ubuntu 18.10 image:
sudo apt update
sudo apt upgrade
sudo apt install build-essential cmake libboost-all-dev git libpq-dev libpqxx-dev
git clone [email protected]:SNAX/fill-postgresql.git
cd fill-postgresql
git submodule update --init --recursive
mkdir build
cd build
cmake ..
make -j
| Option | When to use |
|---|---|
--plugin snax::state_history_plugin |
always |
--state-history-endpoint |
optional; defaults to 0.0.0.0:8080 |
--trace-history |
optional; enable to collect transaction and action traces |
--chain-state-history |
optional; enable to collect state (tables) |
fill-postgresql relies on postgresql environment variables to establish connections; see the postgresql manual.
A quick-and-dirty way to connect to postgresql server running on another machine is to set these:
- PGUSER
- PGPASSWORD
- PGDATABASE
- PGHOST
Use the psql utility to verify your connection.