[users at bb.net] Convert buildbot 0.8 sqlite database to postgresql

[Pierre Tardy]

Hello.
On buildbot eight, the database only store information of the build
requests before the build is started.

Switching to a new database you will only lose the buildrequests and not
the builds which are stored in pickle files.

There is no tool to migrate data from db to db except what you may find on
the internet with pure SQL dumps. That should work as the database model is
exactly the same.

For your scaling problems i fear there are few hopes that switching db will
help a lot as the db is not used that much in eight. Multimaster is the
usual solution to scaling. buildbot nine helps a lot to simplify the setup
for multimaster config.

Hth

Le lun. 17 oct. 2016 05:36, Ryan Schmidt <buildbot at ryandesign.com> a écrit :

> Our buildbot 0.8 installation uses sqlite, because that was the default
> and the easiest thing to do.
>
> I now have a feeling that some of the performance problems we see from
> time to time -- such as the web interface timing out during those unusual
> instances when several thousand builds are getting scheduled at once --
> might be due to that.
>
> I'd like to move the database to postgresql. I couldn't find any
> buildbot-specific advice about how to import the sqlite information into
> postgres. Does documentation exist on how to do that?
>
> http://docs.buildbot.net/current/manual/cfg-global.html#postgres
>
> doesn't say anything other than "PosgreSQL requires no special
> configuration."
>
> _______________________________________________
> users mailing list
> users at buildbot.net
> https://lists.buildbot.net/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.buildbot.net/pipermail/users/attachments/20161017/4f1b087c/attachment.html>