Ok I find a solution.
I drop the chirpstack_ns and chirpstack_as databases and created them again.
Here I report the cmd line procedure for other users:
sudo -u postgres psql
drop database chirpstack_ns;
drop database chirpstack_as;
create database chirpstack_ns with owner chirpstack_ns;
create database chirpstack_as with owner chirpstack_as;
\c chirpstack_as;
create extension pg_trgm;
create extension hstore;
\q