hurdles restoring from snapshot via dockerized cardano-db-sync

[edwmurph]

• cardano-db-tool is not currently baked into the image but it's necessary for doing snapshot restores. can cardano-db-tool be baked into the docker image going forward?
• postgresql-setup.sh is required for restoring from the snapshot but i can't find it on the cardano-db-sync image. i could manually copy it over but it would be ideal if it was also baked into the image to facilitate setting up automation on my end for restoring from snapshots

[erikd]

cardano-db-tool is needed for snapshot creation, but not restoration.

[edwmurph]

@erikd oh great! it would still be helpful though if cardano-db-tool was baked into the docker image for creating custom snapshots going forward but for the near term, just baking the postgresql-setup.sh script into the docker image would help a lot

[erikd]

I know close to zero about Docker, so I would love to get a fix for this (and instructions on how to test it). PRs gladly accepted.

[edwmurph]

looks like you guys use nix so im not exactly sure how to implement this

[erikd]

OK, we have someone on it, but they may not get to it immediately.

[jbgi]

initial implementation in #712
(still need some testing)

[erikd]

#712 has been merged to master and cherry picked into the release/10.0.x branch which will be released as 10.0.2.