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