search

helium / blockchain-etl

Blockchain follower that follows and stores the Helium blockchain
Apache License 2.0
64 stars 37 forks source link

postgis is more-or-less required now #139

Closed jamiew closed 3 years ago

jamiew commented 3 years ago

The latest migration will fail to run without postgis.

If you start your ETL anyway, like a madlad, you'll see:

2021-03-23 12:12:20.945 [info] <0.1003.0> Application blockchain_etl exited with reason: {{shutdown,{failed_to_start_child,db_pool,{{badmatch,{error,{{badmatch,{error,{error,error,<<"42703">>,undefined_column,<<"column \"geometry\" of relation \"locations\" does not exist">>,[{file,<<"parse_target.c">>},{line,<<"1005">>},{position,<<"166">>},{routine,<<"checkInsertTargets">>},{severity,<<"ERROR">>}]}}},[{be_db_geocoder,prepare_conn,1,[{file,"/root/blockchain-etl/src/be_db_geocoder.erl"},{line,37}]},{be_db_worker,'-init/1-fun-1-',3,[{file,"/root/blockchain-etl/src/be_db_worker..."},...]},...]}}},...}}},...}

Just install postgis and you'll be fine. OK thanks Marc bye!

madninja commented 3 years ago

LOL! Ok closing thx bye! Unless you want to add something to the README?

jamiew commented 3 years ago

Yeah filed this as reminder to clarify README. PR incoming