Specify a user & password

[GoNzCiD]

Hi, I'm trying to migrate from 12 to 13, but I have the error role "postgres" does not exist. It's normal because this database doesn't contain this role, is there any way to specifiy it?

I've tried with docker run --rm -v /docker/postgres:/var/lib/postgresql -e POSTGRES_PASSWORD=pas**rd -e POSTGRES_USER=us@r tianon/postgres-upgrade:12-to-13 --link but it seems to me that the environment variables ar not set. :(

[GoNzCiD]

Thanks to the combined workarounds found here I can go ahead but now I have another error......

...
Checking for presence of required libraries                 ok

could not create hard link between old and new data directories: Invalid cross-device link
In link mode the old and new data directories must be on the same file system.
Failure, exiting

[GoNzCiD]

To not use the --link parameter works for me. After that have to copy/update the pg_hba.conf file to the new folder.

[jooize]

Thank you @GoNzCiD. I used docker-postgres-upgrade for a previously failed Matrix Synapse database upgrade from PostgreSQL 11 to 13 with the following final command. Your clues were valuable to me.

POSTGRES_USER="synapse"
POSTGRES_PASSWORD="synapse-password"
OLD=11
NEW=13
OLD_DATA="/matrix/postgres/data-auto-upgrade-backup"
NEW_DATA="/matrix/postgres/data"

sudo docker run --rm \
-e PGUSER="$POSTGRES_USER" \
-e POSTGRES_INITDB_ARGS="-U $POSTGRES_USER" \
-e POSTGRES_PASSWORD="$POSTGRES_PASSWORD" \
-v "$OLD_DATA":"/var/lib/postgresql/$OLD/data" \
-v "$NEW_DATA":"/var/lib/postgresql/$NEW/data" \
"tianon/postgres-upgrade:$OLD-to-$NEW"

cp -a /matrix/postgres/data-auto-upgrade-backup/pg_hba.conf /matrix/postgres/data/

If anyone else ends up where I did, also check the ownerships and permissions of /matrix/*.

Thank you, @tianon, for docker-postgres-upgrade!