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.

[Jesus Ramirez Castro]

which one is it?

[Fabio Racobaldo _Herzum_]

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 _Herzum_]

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

[Fabio Racobaldo _Herzum_]

please go on the server in your CONFLUENCE_HOME_FOLDER/log/atlassian-confluence.log and check the error message.

[Jesus Ramirez Castro]

which file is it?

[Fabio Racobaldo _Herzum_]

hey @Jesus Ramirez Castro , this is INST folder. Usually HOME folder is under /var/atlassian... but it depends how you setup instance. Go to Server info menu on the administration section to retrieve home folder location

[Jesus Ramirez Castro]

2025-04-10 10:25:34,057 ERROR [http-nio-8090-exec-9] [[Standalone].[localhost].[/].[noop]] log Servlet.service() for servlet [noop] in context with path [] threw exception
2025-04-10 10:25:34,058 ERROR [http-nio-8090-exec-9] [[Standalone].[localhost].[/].[system-error]] log Servlet.service() for servlet [system-error] threw exception
2025-04-10 10:26:44,054 ERROR [http-nio-8090-exec-10] [atlassian.confluence.util.AbstractBootstrapHotSwappingFilter] doFilter Could not get swap target filter
-- url: /rest/capabilities | traceId: 0086fca6f69cbd49
2025-04-10 10:26:44,055 ERROR [http-nio-8090-exec-10] [[Standalone].[localhost].[/].[noop]] log Servlet.service() for servlet [noop] in context with path [] threw exception
2025-04-10 10:26:44,056 ERROR [http-nio-8090-exec-10] [[Standalone].[localhost].[/].[system-error]] log Servlet.service() for servlet [system-error] threw exception
2025-04-10 10:27:54,052 ERROR [http-nio-8090-exec-1] [atlassian.confluence.util.AbstractBootstrapHotSwappingFilter] doFilter Could not get swap target filter
-- url: /rest/capabilities | traceId: 007306b847e3457c
2025-04-10 10:27:54,054 ERROR [http-nio-8090-exec-1] [[Standalone].[localhost].[/].[noop]] log Servlet.service() for servlet [noop] in context with path [] threw exception
2025-04-10 10:27:54,054 ERROR [http-nio-8090-exec-1] [[Standalone].[localhost].[/].[system-error]] log Servlet.service() for servlet [system-error] threw exception

[Fabio Racobaldo _Herzum_]

@Jesus Ramirez Castro , that log seems to not contain the real issue. Try to restart and check the log

[Jesus Ramirez Castro]

@Fabio Racobaldo _Herzum_  thanks for your response, yesterday I had to restore from backup cause today we are upgrading our jira instance, but I still have to upgrade after the jira thing so I will try again during the day to do this upgrade if not I will have to open a support ticket to get help, which btw I have not found any way of doing it, do yo know how can I reach support and get assistance?

[Fabio Racobaldo _Herzum_]

You can try to reach support here https://support.atlassian.com/contact/#/