Could this works to migrate a repmgr enabled database

[mulder999]

I’m currently using bitnami/postgresql-repmgr container for PostgreSQL replication, and I’m wondering if this package can be utilized to migrate the master node.

I have the following script that attempts to migrate the database from version 16 to 17:

#!/bin/bash

FROM="/data/postgresql/16"
TO="/data/postgresql/17"

sudo rsync -avh --delete "${FROM}/" "${TO}/"

sudo chown -R 1001 "${TO}"
sudo chmod 777 "${TO}"

docker run --rm \
  --user 0 \
  -v "${TO}:/bitnami/postgresql" \
  -e PGAUTO_ONESHOT=yes \
  -e PGDATA=/bitnami/postgresql/data \
  pgautoupgrade/pgautoupgrade:17-debian

sudo chown -R 1001 "${TO}"
sudo chmod 700 "${TO}"

However, after running the script, I encounter the following error:

could not load library "$libdir/repmgr": ERROR:  could not access file "$libdir/repmgr": No such file or directory
In database: repmgr

[mulder999]

In case anyone wonder, I finally installed repmgr like so for pgautoupgrade.

#!/bin/bash

FROM="/data/postgresql/16"
TO="/data/postgresql/17"

sudo rsync -avh --delete "${FROM}/" "${TO}/"

sudo chown -R 1001 "${TO}"
sudo chmod 777 "${TO}"

docker run --rm \
  --user 0 \
  --entrypoint bash \
  -v "${TO}:/bitnami/postgresql" \
  -e PGAUTO_ONESHOT=yes \
  -e PGDATA=/bitnami/postgresql/data \
  pgautoupgrade/pgautoupgrade:17-debian \
  -c "
    set -e
    echo 'Installing repmgr...'
    apt-get update && apt-get install -y repmgr
    echo 'Starting upgrade process...'
    exec /usr/local/bin/docker-entrypoint.sh postgres
  "

sudo chown -R 1001 "${TO}"
sudo chmod 700 "${TO}"

Still need to do some checks but it might be ok.

REM: Remember to upgrade repmgr to latest version using REPMGR_UPGRADE_EXTENSION in bitnami container first.

[justinclift]

Interesting approach, to use the -c option to docker run to install packages.

That kind of sounds like it might work out fine, though as you mention more checking/testing is a good idea in case there's some kind of unexpected weirdness that crops up. 😄

[mulder999]

Yeah, I thought it might be a neat way to quickly get things set up! The migration actually went up just fine, so I’m closing the topic for now 😄