Lester,

I did the same migration about a year ago. After much searching and
experimentation, I went with this script:

http://www.djangosnippets.org/snippets/167/

It took a while to dump out the database, but it worked without issues
for our setup.

Good Luck,
Andy

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.
>
> Lester
>
> 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 
"reviewboard" group.
To post to this group, send email to reviewboard@googlegroups.com
To unsubscribe from this group, send email to 
reviewboard+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/reviewboard?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to