Add section: How to restore snapshots

[a1300]

Related: #89

TODO

• Under run-node/upgrade-node (docker)
  • Please add a section Restore from snapshot. Which uses this script (posted below)
  • Link to testnet.snapshots.gny.io or to mainnet.snapshots.gny.io like in Add tabbed component that switches between mainnet/testnet/localnet #89
• Under run-bare-metal-node/upgrade-node (bare-metal)
  • Please write a new script that restores the snapshots on the local database
  • Link to testnet.snapshots.gny.io or to mainnet.snapshots.gny.io like in Add tabbed component that switches between mainnet/testnet/localnet #89

Restore snapshot with docker (script):

# If you run your node with docker, please follow the statements below.

#You need ~ 10GB of free space for this
sudo apt-get install zip unzip

# download
wget http://testnet.snapshots.gny.io/v2_height_2134447_09-01-2021_19_00_13.zip
unzip v2_height_2134447_09-01-2021_19_00_13.zip


sudo docker-compose --file docker-compose.yml down


# make space
sudo docker volume prune --force


# get newest image (1.0.55)
sudo docker-compose --file docker-compose.yml pull


# restore
sudo docker-compose --file docker-compose.yml up --no-start
sudo docker-compose --file docker-compose.yml start db1


sleep 10s
cat v2_height_2134447_09-01-2021_19_00_13.sql | sudo docker exec -i db1 psql -U postgres


# start again
sudo docker-compose --file docker-compose.yml up --detach

[xpgeng]

@a1300

For restoring the snapshots on the local database, I think the current snapshots on the sites (mainnet.snapshots.gny.io or testnet.snapshots.gny.io) is not the right version. They seem to be the docker version. Because in the local database for the bare metal node, the DB_user is postgres2 with the password docker. However the snapshots are all postgres with a md5 password. So should we provide both versions of the snapshots?

[a1300]

@xpgeng thanks for the summary

The problem with db user postgres2 is now fixed with the closing of ticket #94 . Now we only have one postgres user postgres