Migrating from SQLite to PGSQL
Hello hello!
I followed the guide to migrate from SQLite to PGSQL as defined in the docs, and used pgloader to migrate the database. The migration goes well with 0 errors, however, when I restart the NetBird services, and go through authentication via Zitadel, I’m stuck on NetBirds loading screen. Logs for PGSQL only show the container for Postgres is open for connections but no connection attempts made. And I’m unable to find anything particularly interesting in NB management logs - simply info logs.
I figured I’d start with an empty PG database, which allows me into the NetBird UI. Then I do the database migration again and all my tables move over successfully again and I’m in the UI finally without issues and my peers have to be reconnected but that’s a non-issue. Everything works well until I have to restart my NetBird services, and I’m stuck on the NetBird loading screen again after the container restart. I’m a little lost on why this happens.
Does anyone have any ideas on how I could debug this further?
I’m running:
NetBird management - 0.59.13
Postgres - 17-alpine
Zitadel for authentication
Self hosted everything
I followed the guide to migrate from SQLite to PGSQL as defined in the docs, and used pgloader to migrate the database. The migration goes well with 0 errors, however, when I restart the NetBird services, and go through authentication via Zitadel, I’m stuck on NetBirds loading screen. Logs for PGSQL only show the container for Postgres is open for connections but no connection attempts made. And I’m unable to find anything particularly interesting in NB management logs - simply info logs.
I figured I’d start with an empty PG database, which allows me into the NetBird UI. Then I do the database migration again and all my tables move over successfully again and I’m in the UI finally without issues and my peers have to be reconnected but that’s a non-issue. Everything works well until I have to restart my NetBird services, and I’m stuck on the NetBird loading screen again after the container restart. I’m a little lost on why this happens.
Does anyone have any ideas on how I could debug this further?
I’m running:
NetBird management - 0.59.13
Postgres - 17-alpine
Zitadel for authentication
Self hosted everything
