Snapshots

Namada Indexer Database Snapshot

We take daily snapshots of the Namada Indexer Database and try to keep the last 3 snapshots. All snapshots are uploaded to Hetzner Object Storage.

Choose one snapshot from the list in the table above and assign it to the variable DB_SNAPSHOT.

change the working directory to the namada-indexer directory, then run the following commands:

wget -O dump.sql $DB_SNAPSHOT

docker compose down

docker compose up -d postgres

docker compose cp dump.sql postgres:/tmp/dump.sql

docker compose exec postgres pg_restore -d namada-indexer --clean tmp/dump.sql --verbose

docker compose exec postgres rm tmp/dump.sql

docker compose up -d

Namada MASP Indexer Database Snapshot

We take daily snapshots of the Namada MASP Indexer Database and try to keep the last 3 snapshots. All snapshots are uploaded to Hetzner Object Storage.

Choose one snapshot from the list in the table above and assign it to the variable DB_SNAPSHOT.

change the working directory to the namada-masp-indexer directory, then run the following commands:

wget -O dump.sql $DB_SNAPSHOT

docker compose down

docker compose up -d postgres

docker compose cp dump.sql postgres:/tmp/dump.sql

docker compose exec postgres pg_restore -d masp_indexer_local --clean tmp/dump.sql --verbose

docker compose exec postgres rm tmp/dump.sql

docker compose up -d