Error migrating postgres

[gvrodrigueznetlabs]

Problem description

Hi guys, I have a problem migrate uyuni from bare metal to podman,

After the copy of database mgradm start to convert my database postgres 14, to postgres 16, but appear this error on log

{"time":"2025-02-13T15:44:22-03:00","caller":"Cmd output","message":"Successfully initialized new postgresql 16 database.\nTemporarily disable SSL in the old posgresql configuration"}

{"time":"2025-02-13T15:44:22-03:00","caller":"Cmd output","message":"\nThere seems to be a postmaster servicing the old cluster.\nPlease shutdown that postmaster and try again.\nFailure, exiting"}

Steps to reproduce

1.mgradm migrate podman --logLevel debug uyuni.old

Uyuni version

Información para paquete Uyuni-Server-release:
----------------------------------------------
Repositorio           : Uyuni Server Stable
Nombre                : Uyuni-Server-release
Versión               : 2024.08-230900.221.1.uyuni3
Arquitectura          : x86_64
Proveedor             : obs://build.opensuse.org/systemsmanagement:Uyuni
Nivel de asistencia   : Nivel 3
Tamaño de instalación : 1,4 KiB
Instalado             : Sí
Estado                : actualizado
Paquete de fuentes    : Uyuni-Server-release-2024.08-230900.221.1.uyuni3.src
URL ascendente        : https://www.uyuni-project.org/
Resumen               : Uyuni Server
Descripción           :
    Uyuni lets you efficiently manage physical, virtual,
    and cloud-based Linux systems. It provides automated and cost-effective
    configuration and software management, asset management, and system
    provisioning.

Uyuni proxy version (if used)

Useful logs

{"level":"debug","time":"2025-02-13T15:44:00-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} var-cobbler"}

{"level":"debug","time":"2025-02-13T15:44:00-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/var-cobbler/_data"}

{"level":"debug","time":"2025-02-13T15:44:00-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} var-search"}

{"level":"debug","time":"2025-02-13T15:44:00-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/var-search/_data"}

{"level":"debug","time":"2025-02-13T15:44:00-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} var-salt"}

{"level":"debug","time":"2025-02-13T15:44:00-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/var-salt/_data"}

{"level":"debug","time":"2025-02-13T15:44:00-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} var-cache"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/var-cache/_data"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} var-spacewalk"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/var-spacewalk/_data"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} var-log"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/var-log/_data"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} srv-salt"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/srv-salt/_data"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} srv-www"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/srv-www/_data"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} srv-tftpboot"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/srv-tftpboot/_data"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} srv-formulametadata"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/srv-formulametadata/_data"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} srv-pillar"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/srv-pillar/_data"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} srv-susemanager"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/srv-susemanager/_data"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} srv-spacewalk"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/srv-spacewalk/_data"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} root"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/root/_data"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} ca-cert"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/ca-cert/_data"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} run-salt-master"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/run-salt-master/_data"}

{"level":"debug","time":"2025-02-13T15:44:01-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} etc-tls"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/etc-tls/_data"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} var-pgsql"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/var-pgsql/_data"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} etc-rhn"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/etc-rhn/_data"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} tls-key"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/tls-key/_data"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} etc-apache2"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/etc-apache2/_data"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} etc-systemd-multi"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/etc-systemd-multi/_data"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} etc-systemd-sockets"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/etc-systemd-sockets/_data"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} etc-salt"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/etc-salt/_data"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} etc-tomcat"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/etc-tomcat/_data"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} etc-cobbler"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/etc-cobbler/_data"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} etc-sysconfig"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/etc-sysconfig/_data"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} etc-postfix"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/etc-postfix/_data"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:68","message":"Running: podman volume inspect --format {{.Mountpoint}} etc-sssd"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:51","message":"Running: restorecon -F -r -v /var/lib/containers/storage/volumes/volumes/etc-sssd/_data"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/inspector.go:96","message":"Trying to read /tmp/mgradm-3419665306/data"}

{"level":"info","time":"2025-02-13T15:44:02-03:00","caller":"mgradm/shared/podman/podman.go:246","message":"Previous PostgreSQL is 14, new one is 16. Performing a DB version upgrade…"}

{"level":"info","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/utils.go:235","message":"Computed image name is registry.opensuse.org/uyuni/server-migration-14-16:latest"}

{"level":"info","time":"2025-02-13T15:44:02-03:00","caller":"shared/podman/images.go:45","message":"Pull Policy is always. Presence of RPM image will be checked and pulled from registry if not present"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/podman/images.go:119","message":"Looking for installed RPM package containing registry.opensuse.org/uyuni/server-migration-14-16:latest image"}

{"level":"debug","error":"open /usr/share/suse-docker-images/native/: no such file or directory","time":"2025-02-13T15:44:02-03:00","caller":"shared/podman/images.go:125","message":"Cannot read directory /usr/share/suse-docker-images/native/"}

{"level":"info","time":"2025-02-13T15:44:02-03:00","caller":"shared/podman/images.go:63","message":"Cannot find RPM image for registry.opensuse.org/uyuni/server-migration-14-16:latest"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/podman/images.go:68","message":"Pulling image registry.opensuse.org/uyuni/server-migration-14-16:latest because it is missing and pull policy is not 'never'"}

{"level":"info","time":"2025-02-13T15:44:02-03:00","caller":"shared/podman/images.go:217","message":"Running podman pull registry.opensuse.org/uyuni/server-migration-14-16:latest"}

{"level":"debug","time":"2025-02-13T15:44:02-03:00","caller":"shared/utils/exec.go:51","message":"Running: podman pull registry.opensuse.org/uyuni/server-migration-14-16:latest"}

{"time":"2025-02-13T15:44:02-03:00","caller":"Cmd output","message":"Trying to pull registry.opensuse.org/uyuni/server-migration-14-16:latest..."}

{"time":"2025-02-13T15:44:04-03:00","caller":"Cmd output","message":"Getting image source signatures"}

{"time":"2025-02-13T15:44:04-03:00","caller":"Cmd output","message":"Copying blob sha256:f7020179dccd1d63ec3e3fcb5eacdefda0a18ed55c82507fd10d3da333c1a0d4\nCopying blob sha256:b4e9df5b5dd944f8e4742c1834092c1134d7216213db1b8d37cf9ca1d70935d9"}

{"time":"2025-02-13T15:44:04-03:00","caller":"Cmd output","message":"Copying blob sha256:9afe500595cdaa81a0616cfa420c0899288ba65a019619245cd23d207d2a735b"}

{"time":"2025-02-13T15:44:18-03:00","caller":"Cmd output","message":"Copying config sha256:535a7739adf35de390f53bdf624ac12cc41160b2a82a6556458760f1d9852944"}

{"time":"2025-02-13T15:44:18-03:00","caller":"Cmd output","message":"Writing manifest to image destination"}

{"time":"2025-02-13T15:44:18-03:00","caller":"Cmd output","message":"535a7739adf35de390f53bdf624ac12cc41160b2a82a6556458760f1d9852944"}

{"level":"info","time":"2025-02-13T15:44:18-03:00","caller":"mgradm/shared/podman/podman.go:281","message":"Using database upgrade image registry.opensuse.org/uyuni/server-migration-14-16:latest"}

{"level":"debug","time":"2025-02-13T15:44:18-03:00","caller":"shared/utils/exec.go:51","message":"Running: podman run --name uyuni-upgrade-pgsql --rm --cap-add NET_RAW --tmpfs /run -v cgroup:/sys/fs/cgroup:rw -v /tmp/mgradm-23507404:/var/lib/uyuni-tools/ --security-opt label=disable -v var-cobbler:/var/lib/cobbler:z -v var-search:/var/lib/rhn/search:z -v var-salt:/var/lib/salt:z -v var-cache:/var/cache:z -v var-spacewalk:/var/spacewalk:z -v var-log:/var/log:z -v srv-salt:/srv/salt:z -v srv-www:/srv/www/:z -v srv-tftpboot:/srv/tftpboot:z -v srv-formulametadata:/srv/formula_metadata:z -v srv-pillar:/srv/pillar:z -v srv-susemanager:/srv/susemanager:z -v srv-spacewalk:/srv/spacewalk:z -v root:/root:z -v ca-cert:/etc/pki/trust/anchors/:z -v run-salt-master:/run/salt/master:z -v etc-tls:/etc/pki/tls:z -v var-pgsql:/var/lib/pgsql:z -v etc-rhn:/etc/rhn:z -v tls-key:/etc/pki/spacewalk-tls:z -v etc-apache2:/etc/apache2:z -v etc-systemd-multi:/etc/systemd/system/multi-user.target.wants:z -v etc-systemd-sockets:/etc/systemd/system/sockets.target.wants:z -v etc-salt:/etc/salt:z -v etc-tomcat:/etc/tomcat:z -v etc-cobbler:/etc/cobbler:z -v etc-sysconfig:/etc/sysconfig:z -v etc-postfix:/etc/postfix:z -v etc-sssd:/etc/sssd:z --network uyuni registry.opensuse.org/uyuni/server-migration-14-16:latest /var/lib/uyuni-tools/pgsqlVersionUpgrade.sh"}

{"time":"2025-02-13T15:44:19-03:00","caller":"Cmd output","message":"PostgreSQL version upgrade\nTesting presence of postgresql16...\nTesting presence of postgresql14...\nBacking up the database files ...\nCreate new database directory..."}

{"time":"2025-02-13T15:44:19-03:00","caller":"Cmd output","message":"Enforce key permission"}

{"time":"2025-02-13T15:44:19-03:00","caller":"Cmd output","message":"Initialize new postgresql 16 database..."}

{"time":"2025-02-13T15:44:19-03:00","caller":"Cmd output","message":"Running initdb using postgres user"}

{"time":"2025-02-13T15:44:19-03:00","caller":"Cmd output","message":"Any suggested command from the console should be run using postgres user"}

{"time":"2025-02-13T15:44:20-03:00","caller":"Cmd output","message":"The files belonging to this database system will be owned by user \"postgres\"."}

{"time":"2025-02-13T15:44:20-03:00","caller":"Cmd output","message":"This user must also own the server process."}

{"time":"2025-02-13T15:44:20-03:00","caller":"Cmd output"}

{"time":"2025-02-13T15:44:20-03:00","caller":"Cmd output","message":"The database cluster will be initialized with locale \"en_US.UTF-8\".\nThe default database encoding has accordingly been set to \"UTF8\".\nThe default text search configuration will be set to \"english\".\n\nData page checksums are disabled.\n\nfixing permissions on existing directory /var/lib/pgsql/data ... ok\ncreating subdirectories ... ok\nselecting dynamic shared memory implementation ... posix"}

{"time":"2025-02-13T15:44:20-03:00","caller":"Cmd output","message":"selecting default max_connections ... "}

{"time":"2025-02-13T15:44:20-03:00","caller":"Cmd output","message":"100\nselecting default shared_buffers ... "}

{"time":"2025-02-13T15:44:20-03:00","caller":"Cmd output","message":"128MB\nselecting default time zone ... "}

{"time":"2025-02-13T15:44:20-03:00","caller":"Cmd output","message":"Etc/UTC\ncreating configuration files ... "}

{"time":"2025-02-13T15:44:20-03:00","caller":"Cmd output","message":"ok\nrunning bootstrap script ... "}

{"time":"2025-02-13T15:44:20-03:00","caller":"Cmd output","message":"ok"}

{"time":"2025-02-13T15:44:20-03:00","caller":"Cmd output","message":"performing post-bootstrap initialization ... "}

{"time":"2025-02-13T15:44:21-03:00","caller":"Cmd output","message":"ok\nsyncing data to disk ... "}

{"time":"2025-02-13T15:44:22-03:00","caller":"Cmd output","message":"ok"}

{"time":"2025-02-13T15:44:22-03:00","caller":"Cmd output"}

{"time":"2025-02-13T15:44:22-03:00","caller":"Cmd output","message":"initdb:"}

{"time":"2025-02-13T15:44:22-03:00","caller":"Cmd output","message":" "}

{"time":"2025-02-13T15:44:22-03:00","caller":"Cmd output","message":"warning: "}

{"time":"2025-02-13T15:44:22-03:00","caller":"Cmd output","message":"enabling \"trust\" authentication for local connections\ninitdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb."}

{"time":"2025-02-13T15:44:22-03:00","caller":"Cmd output","message":"\nSuccess. You can now start the database server using:\n\n    pg_ctl -D /var/lib/pgsql/data -l logfile start\n"}

{"time":"2025-02-13T15:44:22-03:00","caller":"Cmd output","message":"Successfully initialized new postgresql 16 database.\nTemporarily disable SSL in the old posgresql configuration"}

{"time":"2025-02-13T15:44:22-03:00","caller":"Cmd output","message":"\nThere seems to be a postmaster servicing the old cluster.\nPlease shutdown that postmaster and try again.\nFailure, exiting"}

Additional information

mgradm --version
mgradm version 5.1.4 (Master 3640be2)