How to move your hosted data to your local server

Complete your local installation. Verify that you are able to login. This will mean that the application is able to connect to the database.

You will be provided with a FTP link to download the database and the documents. You will see two files:

Download the two files and unzip them. You should now have 2 directories :

A database.backup directory
A directory called data. Verify that the data directory has two sub-directories indices and documents.

Stop Celoxis - run shutdown.bat (or .sh on unix) from psa_x.y.z/bin
Drop the existing database.
Recreate the database using the same database user that Celoxis will use to connect to the database.
Restore the database.backup (or database.bak in case of SQL Server versions) file (On how to restore, see below.)
Delete your existing data directory. To know your data directory, go to Administration from the user icon menu and click on Site Settings > Edit Site Settings. Check the "Data Directory Path" attribute under the "Basic" tab.
Copy the data directory to that location.
Run the following sql: update db_config set value='C:\data' where name='local_storage_root';
Substitute the C:\data with the path where your data directory resides.
Run the following sql: update db_company set server_name='yourservername:8888';
The 'yourservername' should be the same as what you would like your users to access Celoxis. For example if you would like users to access Celoxis as http://projects.mycompany.com:8888, then run: update db_company set server_name='projects.mycompany.com:8888';
Start Celoxis - run startup.bat (or .sh on unix) in psa_x.y.z/bin
Goto the "Edit Settings" (From toolbar Setup->Site) and re-enter your Settings

pg_restore -Fc -d <dbname> -O -U <username> database.backup

Using Enterprise Manager, right click on the database node and choose "Restore" from "All Tasks"