Skip to content
This repository was archived by the owner on Feb 25, 2026. It is now read-only.

Archive bootstrap ordinals pg dump not restoring #576

@tegaget

Description

@tegaget

I am following the instructions on your archive bootstrap instructions.
I downloaded the ordinals-pg-17-latest.tar

I successfully untared it and made the correct permissions for my postgres. I created the db ordinals as well.
When I do the line:

sudo -u postgres pg_restore --verbose --jobs=6 -d ordinals -c --if-exists ./hirosystems/ordhook-staging-data/ordinals-pg-17-17.0.0-debian-12-r9-20251103.dump

It works importing something very briefly, then it gives an error:

pg_restore: error: could not open input file "hirosystems/ordhook-staging-data/ordinals-pg-17-17.0.0-debian-12-r9-20251103.dump/3480.dat": No such file or directory

I looked inside the directory and the archive dump has only the following:

3488.dat.gz
3490.dat.gz
3491.dat.gz
3492.dat.gz
toc.dat

It seems to be missing some dump files. I tried other archives and same issue. Is there an effective way of restoring the postgres so I can start running the bitcoin-indexer and catch up? I am just caught at this db restore so far.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions