Migrating to new linux VM and DB

Jacob Connelly

Hi all, I'm trying to migrate our confluence server to a new linux VM, as well as a new postgresql DB. The original server is running linux with confluence 5.9.5 and postgresql.

I've gone over the documentation, and still seem to be running into errors. I followed the process at https://confluence.atlassian.com/doc/migrating-confluence-between-servers-184150.html but was unable to get the server started afterwards.

My confluence is too large to do an XML backup (I've tried, and it fails halfway thru), so I am moving the DB using a psql_dump. I'll walk through my process so far, and if anyone can see where I'm going wrong, I would appreciate it.

• Spin up fresh Ubuntu linux VM. 
• Install confluence 5.9.5(x64)
• Stop the confluence service.
• Remove all files in the confluence home directory on the new server.
• Copy the contents of the confluence home directory (/var/atlassian/application-data/confluence/) from the old server to the new server using rsync.
• Restore the Postgresql DB using psql (including creating accounts and setting permissions).
• Start the confluence service.
• Note: I do not move the server.xml file from the old server as it contains the address for our proxy. When I do, it causes my localhost connection to redirect to our production server instead of the localhost.

At this point I am able to "connect" to the server, but I'm always routed to localhost:8090/errors.jsp. No actual error page is shown. I have tried removing my plugin folders to rebuild the cache with no luck. Any advice would be helpful, and I'll happily give any more info I may have forgotten. Thanks!

Sattesh M

Hello Jacob,

It seems like you've followed the right steps to migrate Confluence between servers.

There might have been a couple of things that might have been missed, so do check on the following.

1. After copying the home directory from the old server to the new server, check the confluence.cfg.xml file to see if the hibernate.connection.url is set correctly, and is pointing to the correct database and has the correct username and password as well.
2. Also, if you've used a datasource connection, the database config would be in the server.xml file, so do copy the server.xml file as well, and just edit the connector port section and remove the proxy attributes so that it does not get redirected to the old server's address. If there is a datasource connection, you can also copy over the connection to the new server.xml file instead.
3. There are logs, in the Confluence Installation, and Home directory, in the logs folder, so do check the latest logs in those folders, and scroll all the way to the bottom to see if you notice any errors when we try to start Confluence.
   
   

Hope that helps, and let me know if you have any questions.

Cheers,
Sattesh