We are trying to integrate chirpstack with and existing postgres instance on lightsail. We have enabled all the extensions and checked all permissions as well. We are getting this error:
Setting up PostgreSQL connection pool
2026-03-12T15:42:57.071824Z INFO chirpstack::storage::postgres: Using Verified connection recycling method (SELECT 1 validation query)
2026-03-12T15:42:57.072109Z INFO chirpstack::storage: Applying schema migrations
Error: Error occurred while creating a new object: db error
Caused by:
db error
Has anyone else experinced this issue? What is it caused by?