Postgresql setup for HA

Question

I was wondering if any of you guys run a Data Center deployment with a Postqresql database in HA? Looking to move a client from Server into DC, due to policy they don't want to use any Oracle products and since MariaDB isn't supported they are kinda limited to Postgresql. They are also not looking at any of the cloud providers (AWS, GCP etc) today.

Databases are not my forte. How would you go about setting up Postgresql for HA with Jira and Confluence? What are the potential pitfalls? Which framework do you use? Do you use warm or cold standby?

Tim Perrault · Answer

Whoops totally misread that :)  Amazon RDS Multi-AZ and Amazon PostgreSQL-Compatible Aurora DB HA are available. There isn't any specific Atlassian documentation that I can find, but it does look like there id a request to get that documentation setup gathering interest.

https://aws.amazon.com/rds/aurora/postgresql-features/

Daniel Törnqvist · Answer

Thanks for taking the time to write an answer. My question was basically how to achieve High Availability for Postgresql and the best approach for that.
Migrating the data is not an issue.

Tim Perrault · Answer

Hi @Daniel Törnqvist

This might not be the best approach, but when I had to change from Oracle to Postgresql, I actually stood up a vanilla Jira server with a new Postgresql DB and just had to make sure the Jira server versions matched. I used the backup system under Import and Export and then restored that xml file on the new server using the Restore system under Import and Export.

I didn't have any issues with that approach, but you will have to remember to sync your attachments to the new server. I just let rsync run over night and we were good.

Thanks,

Tim