Update to daily Hivemind snapshots

in #hivemind6 years ago

I distribute daily Hivemind database dumps in the last 5 months. The format of the dump was traditional in that timeframe. In order to optimize restoring time on fresh installs, I have switched it to the custom dump format.

This format is compressed by default and allows concurrent dump/restore actions. On my tests, rebuilding a fresh Hivemind into the latest head block took me 2.5 hours. (Including the download time.)

Steps to restore the database are the same except the restoring command.

Now, you can restore the database with


pg_restore -j 8 -U <db_user> -d <db_dump> hive_latest.dump

-j stands for thread count. I have aligned it with my core count in my test.

Also, worth noting that the dump is taken from a PostgreSQL 10.8 server. It may not be compatible with other PostgreSQL versions.

Sort:  

Nice work, @emrebeyler, to support your work we upvoted your content and gifted you 5000 HBO tokens.

You can find your tokens at steem-engine.com or in the Keychain wallet (its a browser wallet much like Ethereum's Metamask) in the token area.

Coin Marketplace

STEEM 0.13
TRX 0.34
JST 0.033
BTC 115309.22
ETH 4451.94
SBD 0.86