run icon indicating copy to clipboard operation
run copied to clipboard

Add instructions for using MySQL

Open deso2021 opened this issue 4 years ago • 4 comments

data is stored in /db/badgerdb by default? how to enable store in postgres

deso2021 avatar Nov 11 '21 02:11 deso2021

i have a postgres run setup here

https://github.com/tijno/bitclout-run

check the progres branch of that repo

tijno avatar Nov 11 '21 07:11 tijno

Use the --postgres-uri flag or POSTGRES_URI environment variable. FYI Postgres is deprecated in favor of MySQL

maebeam avatar Nov 11 '21 16:11 maebeam

The data in the pg_balances table looks incomplete. After the synchronization is completed, sum is 5786567.577867775,should be 10.8M ?

select sum(balance_nanos)/1000000000 from pg_balances;

deso2021 avatar Nov 25 '21 06:11 deso2021

@deso2021 there's a remaining issue with negative balances @maebeam is aware off

tijno avatar Nov 25 '21 08:11 tijno