How to migrate Confluence from H2 to Postgres

[Steve Kellogg]

Hello,

I have a starter license of Confluence Server.  I had started with a cloud account, but there were a couple of content plugins that I needed that were only available as "server".  This is a one user instance for documentation, so I'm not worried about production performance, but reading some of the posts here, it sounds like Atlassian wants us onto an external database because they aren't confident in the security or recoverability of the built in H2 DB.  

As a result, I'm trying to get setup with a Postgres DB server, but I'm having trouble finding a tutorial on this that walks me through it like the idiot that I obviously am since I've been unable so far to get it all working.

Is anyone here familiar with such a guide that they might be willing to share?

My setup is quite simple.

• I have docker running on a single box.
• I've installed "Atlassian/confluence-server" (the official docker image)
• I've installed "postgreSQL" (the official docker image)

When I run the Confluence instance and get the setup routine, I select External database, and choose "Postgres".

The current problem I'm having is that I can't seem to figure out the connection details. I've tried putting in the docker container name of the db ('confluencepostgres'), and I've tried putting in 'localhost' or '127.0.0.0' or '127.0.0.1'. with the default Postgres port (5432?), but no combination allows the connection test to work

[JP _AC Bielefeld Leader_]

Hi,

this seems to be docker related. As you run two docker images, I would assume they got different docker internal ip addresses. So connecting them via 127.0.0.1 will not work.

Did you do things with docker before? I would check to to retrieve the docker ip address of the postgres box & try to use that one.

Best

JP