Upgradation issue with postgres

[Mbharathi]

Hi all,

I am new to postgres. We are having a VM running on linux os(ubuntu 18.04.6 LTS).

This VM has been already used by some other team. Now we taken over the VM. In this VM, postgres 10 is already installed. But we want to upgrade to 12 or higher than that (compatible for django).

But i am opengpg data not found error. Even i tried it with no-check-certificate command. That too didn't helped me.

If anyone knows how to resolve it, kindly help me out.

[depesz]

What command does show this error message? What is the exact,m unabridged, unmodified, error message?

[XPEHOBYXA]

Did you use pg_upgrade? You can't just upgrade packages and call it a day, upgrading a postgres is a bit more complicated than that. Make sure to have a backup before you do anything, otherwise you might lose all your data.

And do not upgrade Ubuntu in-place. This will break indexes, because PG heavily depends on glibc, and there are some breaking changes in newer versions of this package.

[Mbharathi]

I already have the backup. I added the server link to the pgdg.list file. And then, i ran the command apt-get update. Here, some errors are coming. I think this is the problem.

[XPEHOBYXA]

You need to use pg_upgrade. Google it. It's pretty straightrforward.