#gotosocialadmin
I'm looking for people who have successfully migrated from SQLite to PostgreSQL for #GotoSocial. I did some tinkering using PgLoader and wasn't able to migrate the schema without dropping default values and indexes.
The next step would be to take the database structure from a clean PostgreSQL installation and migrate just the data using PgLoader, but I haven't attempted that yet.
Please share your experiences :-)