You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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. :(
The text was updated successfully, but these errors were encountered:
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
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.
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. :(The text was updated successfully, but these errors were encountered: