Upgrade from 9.6 is dead

[dfeyer]

I'm trying to upgrade an old project from 9.6 and I get the following error:

 Initializing datadir...
 Initializing certdir...
 Initializing logdir...
 Initializing rundir...
 Setting resolv.conf ACLs...
 Initializing database...
 ‣ Migrating PostgreSQL 9.6 data to 10...
 ‣ Installing PostgreSQL 9.6...
 E: The repository 'http://apt.postgresql.org/pub/repos/apt bionic-pgdg Release' does not have a Release file.
 ERROR! Failed to install PostgreSQL 9.6. Exiting...

The packages have been moved to apt-archive.

Point your sources.list entry to

deb https://apt-archive.postgresql.org/pub/repos/apt bionic-pgdg main

Offical announcement:
https://www.postgresql.org/message-id/ZN4OigxPJA236qlg%40msg.df7cb.de

Do you think you support that in the current version of the image ? If not I can upgrade outside of docker without too much trouble.

[xifengzhu]

I attempted to upgrade from version 11-20200524 to version 12-20200524 and encountered the following issue. How can I resolve this?

postgresql-1  | ‣ Migrating PostgreSQL 11 data to 12...
postgresql-1  | ‣ Installing PostgreSQL 11...
postgresql-1  | E: The repository 'http://apt.postgresql.org/pub/repos/apt bionic-pgdg Release' does not have a Release file.
postgresql-1  | ERROR! Failed to install PostgreSQL 11. Exiting...

[MRwangyd]

form 10-2 to 11-20200524 Encountered the same problem, whether it has been solved
Initializing datadir... Initializing certdir... Initializing logdir... Initializing rundir... Setting resolv.conf ACLs... Initializing database... ‣ Migrating PostgreSQL 10 data to 11... ‣ Installing PostgreSQL 10... E: The repository 'http://apt.postgresql.org/pub/repos/apt bionic-pgdg Release' does not have a Release file. ERROR! Failed to install PostgreSQL 10. Exiting...

[MRwangyd]

I solved the problem, using the 10-2 version of the Dockerfile, Upgrade base ubuntu to jammy-20230605
Then repackage the image and you can use it

[duongmn89]

I solved the problem, using the 10-2 version of the Dockerfile, Upgrade base ubuntu to jammy-20230605 Then repackage the image and you can use it

Thanks, your solution worked for me