nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need to upgrade postgres from 13 to 15

Jesus Ramirez Castro

we have upgraded confluence to version 9.2.2 and we have started to see instability on our site, we have seen Java Heap memory issues, this java thing we have bumped the value to 2048, but we need to upgrade our database from version 13.8 to version 15 at least, we have tried to do this on our testing environment but failed many times we had to restore our test machine from backups, any help would be very good, thanks in advance.

Accepted answers

All comments

Fabio Racobaldo _Catworkx_

Hi @Jesus Ramirez Castro and welcome,

please could you specify what is your issue with restore?

Fabio

Jesus Ramirez Castro

so I am trying different things from different sources, so far this what I have done, if needed I can restore from backups and star over I am just not getting the grasp of it, last error I got is this one

New cluster data and binary directories are from different major versions

this came up after I executed this command

sudo -iu postgres /usr/lib/postgresql/13/bin/pg_upgrade -o "-c config_file=/etc/postgresql/13/main/postgresql.conf" --old-datadir=/var/lib/postgresql/13/main -O "-c config_file=/etc/postgresql/15/main/postgresql.conf" --new-datadir=/var/lib/postgresql/15/main/ --old-bindir=/usr/lib/postgresql/13/bin/ --new-bindir=/usr/lib/postgresql/15/bin/ --check

thanks for your response

Fabio Racobaldo _Catworkx_

hey @Jesus Ramirez Castro did you try to start application after DB upgrade? Do you have some error at atlassian-confluence.log level?

Jesus Ramirez Castro

I am seeing this, I have not even tried to login to jira this is just confluence Screenshot 2025-04-10 111137.png

Jesus Ramirez Castro

which one is it?

Screenshot 2025-04-10 121723.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

data-center

confluence-data-center