Confluence dc roll back to the previous version

[testcase1062]

We are recently upgraded the confluence UAT dc version from 8.5.4 to 9.2.0.

Now, I want to roll back to the previous version.

While that time I took the db backup, home and application-data backup.

Now, i tried to roll back, create the temp db and tried to dump the postgresql previous db backup. But, it says error: could not open large object 101718: error: permission denied for large object 101718. Even we provided the necessary permission also it came like this. Now how to roll back to previous version any idea. My instance is in AWS CLOUD. I have only AMI backup. I Don't have the RDS backup.

[testcase1062]

Yes.

[Fabio Racobaldo _Herzum_]

Hi @testcase1062 and welcome,

rollback is not so easy and, for my experience, I usually do that using backups items (home/inst/shared/db). There is an how to article that can help you on that https://confluence.atlassian.com/conf85/roll-back-a-rolling-upgrade-1283361426.html

Hope this helps,

Fabio

[testcase1062]

Hi @Fabio Racobaldo _Herzum_ 

We didn't use the nodes or clusters.

[Fabio Racobaldo _Herzum_]

Hi @testcase1062 ,

did you have a backup of your node before the upgrade?

Fabio

[testcase1062]

Yes, I took the db schema backup, home and application- data backup.

[Fabio Racobaldo _Herzum_]

@testcase1062 so you need just to set the old inst/home/data folders in your server, restore the db and start the application. Let me know!

[testcase1062]

Yes

[testcase1062]

While restoring the db, it shows could not open large objects 101718. We are giving the permission also again same error appears. We are using the postgresql 15.7 version.

[Fabio Racobaldo _Herzum_]

This is an error at db level and not at application side. Try the following https://stackoverflow.com/questions/15765606/postgresql-how-to-restore-very-large-database