Re: Moving Reviewboard Server

2013-07-03 Thread Peter Snelling
Thanks Christian, that worked. There were a couple of small issues. After importing the database, I initially got a message that they couldn't find the directory: /var/www/OldServer/htdocs/media/uploaded/images on the new server. I fixed this by creating a soft link from OldServer directory

Re: Moving Reviewboard Server

2013-07-03 Thread Peter Snelling
Thanks Christian, that worked. There were a couple of small issues. After importing the database, I initially got a message that they couldn't find the directory: /var/www/OldServer/htdocs/media/uploaded/images on the new server. I fixed this by creating a soft link from OldServer directory to

Moving Reviewboard Server

2013-07-02 Thread Peter Snelling
I been trying out reviewboard for about 6 weeks, and it's working pretty well (only real issue is I haven't been able to get e-mails working properly). Now I've got a new better server to install it on. I'd like to copy the existing review and users from the existing database before I move it

Re: Moving Reviewboard Server

2013-07-02 Thread David Trowbridge
That procedure sounds fine. The dumpdb/loaddb commands are really meant for people who are trying to switch database types (for example, SQLite - MySQL, where the syntax of an SQL dump isn't compatible). If you're sticking with pg, I'd just use pg's dump/load tools, which avoids a lot of

Re: Moving Reviewboard Server

2013-07-02 Thread Christian Hammond
Hi Peter, Your plan sounds about right. Let me give you a few more tidbits of info. First, you don't want to use dumpdb/loaddb. Those are slow, last-resort methods for going in-between database types (and are not guaranteed to be bug-free). Instead, you do want psql's native commands. You