Data gone after upgrade to Chirpstack

Hi

How do i get my data from my old databases loraserver_as, loraserver_ns to the new onces, chirpstack_as, chirpstack_ns

I managed to get my data back by using my old databases in the conf files.

NS Server
dsn=ā€œpostgres://loraserver_ns:xxxxxx@localhost/loraserver_ns?sslmode=disableā€

AS Server
dsn=ā€œpostgres://loraserver_as:xxxxxx@localhost/loraserver_as?sslmode=disableā€
automigrate=true

but then i had and error with the hstore in Postgres,

setup storage error: storage: applying PostgreSQL data migrations error: pq: type ā€œhstoreā€

To fix this i did the following

sudo -u postgres psql
\c loraserver_as
create extension hstore;
\q

So far all the GWā€™s are connected and the nodes are sending data.

holding thumbs!!!

1 Like