Forum .LRN Q&A: Re: changing machines

Collapse
3: Re: changing machines (response to 1)
Posted by Dave Bauer on
Here is what I suggest.

1) Make a copy of the entire openacs directory from the current machine.

2) Move that to the new server.

3) Dump the database from the current machine

4) Reload that into an empty database on the new server.

Don't try to change the code base at the same time you are changing the server.

If tsearch2 is installed on there make sure this http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/regprocedure_update.sql is applied to the database before dumping it.

"If you have a working version of tsearch2 in your database, you do not need to re-install the tsearch2 module. Just apply the patch and run make. This patch only affects the tsearch2.sql file. You can run the SQL script found : [right here] This script will make the modifications found in the patch, and update the fields from the existing data. From this point on, you can dump and restore the database in a normal fashion. Without this patch, you must follow the instructions later in this document for backup and restore." see http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html