Viewing a response to: @emrebeyler/re-tosch-re-emrebeyler-steps-to-restore-a-hivemind-database-snapshot-20190123t131626232z
I guessed so, I think I was at block 5 Million after around 24 hours. And the first 5 Million blocks are probably less filled than what is coming later :D I am in the process of syncing your snapshot now.
| author | tosch |
|---|---|
| permlink | re-emrebeyler-re-tosch-re-emrebeyler-steps-to-restore-a-hivemind-database-snapshot-20190123t134448041z |
| category | hivemind |
| json_metadata | {"tags":["hivemind"],"app":"steemit/0.1"} |
| created | 2019-01-23 13:44:48 |
| last_update | 2019-01-23 13:45:42 |
| depth | 3 |
| children | 10 |
| last_payout | 2019-01-30 13:44:48 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 204 |
| author_reputation | 3,148,075,991,236 |
| root_title | "Steps to restore a Hivemind database snapshot" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 78,814,565 |
| net_rshares | 0 |
Great! Let me know if you encounter any issues. Also, make sure you have PostgreSQL 10.6. This backup is not compatible with other PostgreSQL versions.
| author | emrebeyler |
|---|---|
| permlink | re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-steps-to-restore-a-hivemind-database-snapshot-20190123t134542215z |
| category | hivemind |
| json_metadata | {"tags":["hivemind"],"app":"steemit/0.1"} |
| created | 2019-01-23 13:45:42 |
| last_update | 2019-01-23 13:45:42 |
| depth | 4 |
| children | 9 |
| last_payout | 2019-01-30 13:45:42 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 151 |
| author_reputation | 448,535,049,068,622 |
| root_title | "Steps to restore a Hivemind database snapshot" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 78,814,611 |
| net_rshares | 0 |
So far so good, a couple of minor things. It seems I had PostgreSQL 9.5 on my system. Then installing with your instructions worked fine. And all the continuing step also. Only thing that did not really work was your import command. Due to the password missing. Setting <a href="https://gist.github.com/AtulKsol/4470d377b448e56468baef85af7fd614">md5</a> as method requires the password input. Therefore I used a query like this to import, as you can read in the cited source: ``` psql --host=localhost --dbname=hive --username=hive -f hive_latest.sql ```
| author | tosch |
|---|---|
| permlink | re-emrebeyler-re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-steps-to-restore-a-hivemind-database-snapshot-20190123t140045378z |
| category | hivemind |
| json_metadata | {"tags":["hivemind"],"links":["https://gist.github.com/AtulKsol/4470d377b448e56468baef85af7fd614"],"app":"steemit/0.1"} |
| created | 2019-01-23 14:00:45 |
| last_update | 2019-01-23 14:00:45 |
| depth | 5 |
| children | 5 |
| last_payout | 2019-01-30 14:00:45 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 559 |
| author_reputation | 3,148,075,991,236 |
| root_title | "Steps to restore a Hivemind database snapshot" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 78,815,276 |
| net_rshares | 0 |
it the import (psql..) prints errors while importing the database, what you have is/will be a corrupted database. Somebody tried with 10.5 and failed.
| author | emrebeyler |
|---|---|
| permlink | re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-steps-to-restore-a-hivemind-database-snapshot-20190123t140312865z |
| category | hivemind |
| json_metadata | {"tags":["hivemind"],"app":"steemit/0.1"} |
| created | 2019-01-23 14:03:12 |
| last_update | 2019-01-23 14:06:57 |
| depth | 6 |
| children | 4 |
| last_payout | 2019-01-30 14:03:12 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 151 |
| author_reputation | 448,535,049,068,622 |
| root_title | "Steps to restore a Hivemind database snapshot" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 78,815,421 |
| net_rshares | 0 |
I have confirmed running 10.6 I have the database crashing at 120GB with the following message: ``` psql:hive_latest.sql:345205000: ERROR: missing data for column "img_url" CONTEXT: COPY hive_posts_cache, line 56927356: "57289501 breili magicalliteraturenaturespirits-kcl8bly83b steempress 0 1 60.4199982 0 19 19 Magical ..." ```
| author | tosch |
|---|---|
| permlink | re-emrebeyler-re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-steps-to-restore-a-hivemind-database-snapshot-20190123t164406093z |
| category | hivemind |
| json_metadata | {"tags":["hivemind"],"app":"steemit/0.1"} |
| created | 2019-01-23 16:44:06 |
| last_update | 2019-01-23 16:44:06 |
| depth | 5 |
| children | 2 |
| last_payout | 2019-01-30 16:44:06 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 383 |
| author_reputation | 3,148,075,991,236 |
| root_title | "Steps to restore a Hivemind database snapshot" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 78,822,921 |
| net_rshares | 0 |
You’re importing with -f hive_latest.sql instead of console stream, right?
| author | emrebeyler |
|---|---|
| permlink | re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-steps-to-restore-a-hivemind-database-snapshot-20190123t164914671z |
| category | hivemind |
| json_metadata | {"tags":["hivemind"],"app":"steemit/0.1"} |
| created | 2019-01-23 16:49:15 |
| last_update | 2019-01-23 16:49:15 |
| depth | 6 |
| children | 1 |
| last_payout | 2019-01-30 16:49:15 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 74 |
| author_reputation | 448,535,049,068,622 |
| root_title | "Steps to restore a Hivemind database snapshot" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 78,823,104 |
| net_rshares | 0 |
hiveblocks