Re: Docker Container 2.5.0 / UniqueViolation: duplicate key value violates unique constraint "_issue_pkey"

On Wed, Oct 29, 2025 at 08:59:46AM +0000, SCHLEMMER Norbert wrote:
> Hi Ralf
> 
> What is the recommended upgrade path from Docker "2.3.0 / PostgreSQL 17" to "2.5.0 / PostgreSQL 18" and for migrating to a different host with Debian 13 / Trixie?
> 
> Can the Docker image simply be changed from roundup:2.3.1a0 to roundup:2.5.0-1?
> I did this and didn't find any problems during testing. Is this
> procedure permissible and recommended?

Yes, this should work. Note that the postgres version is of minor
concern.

> If so, I can then upgrade to PostgreSQL 18 in the next step using SQL
> dump/restore.

Yes, if you're installing postgres on the same machine postgres comes
with a pg_upgradecluster command that should be even faster than
dump/restore (and it is much easier if you have several databases), but
it needs both postgres versions to be installed at the same time (then
next you would pg_dropcluster the old cluster after having verified that
everything is in the new cluster and then you can uninstall the old
postgres version).

Thanks + kind regards
Ralf
-- 
Dr. Ralf Schlatterbeck                  Tel:   +43/2243/26465-16
Open Source Consulting                  www:   www.runtux.com
Reichergasse 131, A-3411 Weidling       email: [email protected]