How to replace the database backend of an existing node?

[SevenLiquor]

Just as the title describes,I want to replace the database of a certain node with PostgreSQL.
And there are multiple channels at this node, including the BTC channel and the traproot asset channel.
Is there such a method?

[guggero]

What is your current database backend? Is it SQLite or bbolt? There is lndinit that allows you to migrate from bbolt to any SQL database (in your case Postgres). But there currently is no way to migrate from SQLite to Postgres (and just exporting and re-importing the schema will definitely break things, don't do it!), but we're working on that.

[SevenLiquor]

Thank you very much. I'm using bbolt. I'm going to try this it.

[ellemouton]

@SevenLiquor - I assume you are sorted now? I'll close the discussion in the mean time but feel free to re-open if you need to