[Buildbot-devel] Switching databases

[Dustin J. Mitchell]

On Mon, Jun 25, 2012 at 1:27 AM, "Martin v. Löwis" <martin at v.loewis.de> wrote:
> I'd like to switch from sqlite to postgres for the build master,
> and migrate all state in the process. What's the best way to do
> that?

We don't have a good story for supporting migration from one DB engine
to another.

Your best bet is to dump the db from sqlite, use regexps to apply any
transformations to create SQL that postgres will tolerate, and load it
into postgres.

Dustin