Awesome!
I was just in the process of syncing and knew it would take at least 3 more days. I have downloaded your snapshot and will give it a try. This could reduce the syncing time by so much!
You are viewing a single comment's thread from:
Awesome!
I was just in the process of syncing and knew it would take at least 3 more days. I have downloaded your snapshot and will give it a try. This could reduce the syncing time by so much!
It takes 6-7 days at best. The progress bar is misleading :)
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.
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.
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 md5 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.sqlit 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.
That is also something I noticed. I dumped my previously synced database before importing.
Yeah, you need postgresql 10.6 :)
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 ..."You’re importing with -f hive_latest.sql instead of console stream, right?
btw, my id is emrebeyler#9263 on discord. Shoot a dm :)