How to change database

[jurgenhaas]

We do have a small instance of Kutt and both PG and MySQL seem to be overkill. So, I wonder how we could migrate from the PG database to SQLite. Can somebody give me some hints on how to go about that? Note: I'm not a PG expert.

[trgwii]

There's not database-to-database migration tooling yet.

[jurgenhaas]

@trgwii yeah, but if there were a command to dump the PG database and then import that dump into SQLite, that would already do. I'm happy to perform a number of commands on the command line for that, if I only knew which commands were required.

[poeti8]

Let's make a discussion for this if it's necessary, however, I think this is a general question for Postgres and SQLite and there should be answers for it all over the internet.