RE: Steps to restore a Hivemind database snapshot by emrebeyler

View this thread on: hive.blog | peakd.com | ecency.com

hivemind · @emrebeyler · Jan 23 '19

Yeah, you need postgresql 10.6 :)

`author`	emrebeyler
`permlink`	re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-steps-to-restore-a-hivemind-database-snapshot-20190123t140503287z
`category`	hivemind
`json_metadata`	{"tags":["hivemind"],"app":"steemit/0.1"}
`created`	2019-01-23 14:05:03
`last_update`	2019-01-23 14:05:03
`depth`	8
`children`	2
`last_payout`	2019-01-30 14:05:03
`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`	33
`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,524
`net_rshares`	0

Seems like it. I was running 11.1 and hoped it would work out fine. But then it aborted with an error at 120GB size.

`author`	tosch
`permlink`	re-emrebeyler-re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-re-tosch-re-emrebeyler-steps-to-restore-a-hivemind-database-snapshot-20190123t154945238z
`category`	hivemind
`json_metadata`	{"tags":["hivemind"],"app":"steemit/0.1"}
`created`	2019-01-23 15:49:45
`last_update`	2019-01-23 15:49:45
`depth`	9
`children`	1
`last_payout`	2019-01-30 15:49: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`	116
`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,820,645
`net_rshares`	0

For everyone looking at the same, verifying by running
```
SELECT version();
```
helps to see which version is currently in use