I did the same migration about a year ago. After much searching and
experimentation, I went with this script:
It took a while to dump out the database, but it worked without issues
for our setup.
On May 26, 2:27 am, Lester Cheung <13z73rch3...@gmail.com> wrote:
> Hi Christian,
> Thanks for the quick response! I just tried it and I got a problem:
> # rb-site manage /srv/reviewboard dumpdata > /rb-dbdump.json
> Error: Unable to serialize database: 'utf8' codec can't decode byte
> 0xb6 in position 1205: unexpected code byte. You passed in 'diff -r
> d5d320fdb5dc -r f481747c8c97 (a lot more stuff removed).
> Guess the export code expect all strings in unicode? Did I found a
> bug? :)
> That was run on a r1772 build.
> On 26/05/2009, at 5:51 PM, Christian Hammond wrote:
> > It's possible that you can use Django's built-in loaddata/dumpdata
> > commands, but it's not supported, may not work perfectly, and may
> > require a lot of RAM, depending on database size.
> > You can try using:
> > rb-site manage /path/to/site dumpdata > dbdump.json
> > Then on the new database settings:
> > rb-site manage /path/to/site loaddata dbdump.json
> > Hope it works.
> > Christian
> > --
> > Christian Hammond - chip...@chipx86.com
> > Review Board -http://www.review-board.org
> > VMware, Inc. -http://www.vmware.com
> > On Tue, May 26, 2009 at 12:29 AM, Lester Cheung <13z73rch3...@gmail.com
> > > wrote:
> > Hi all,
> > Have been using reviewboard at work and every likes it. Now that I
> > have a proper machine to run reviewboard on I'd like to switch from
> > the original sqlite db to a postgres so my question is:-
> > How do one export and import a reviewboard database properly?
> > I tried to do a dump with "sqlite <file> .dump" but postgres doesn't
> > like the output. I guess it has something to do with the data type
> > names not being the same but before I dig into that I'd like to know
> > if this has been done and how hard it will be. :)
> > Cheers,
> > Lester Cheung
You received this message because you are subscribed to the Google Groups
To post to this group, send email to email@example.com
To unsubscribe from this group, send email to
For more options, visit this group at