Closed pascalwacker closed 2 years ago
When I try to inject the PGUSER
env variable and run it from a local folder instead of the volume, it gets a bit further but still fails in the end:
$ docker run --rm -v /home/pascal/Dockers/api/db-test/12:/var/lib/postgresql/12/data -v /home/pascal/Dockers/api/db-test/14:/var/lib/postgresql/14/data -e PGUSER=api-platform tianon/postgres-upgrade:12-to-14
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
Checking database user is the install user ok
Checking database connection settings ok
Checking for prepared transactions ok
Checking for system-defined composite types in user tables ok
Checking for reg* data types in user tables ok
Checking for contrib/isn with bigint-passing mismatch ok
Checking for user-defined encoding conversions ok
Checking for user-defined postfix operators ok
Creating dump of global objects ok
Creating dump of database schemas
api
postgres
template1
ok
connection to server on socket "/var/lib/postgresql/.s.PGSQL.50432" failed: FATAL: role "api-platform" does not exist
could not connect to target postmaster started with the command:
"/usr/lib/postgresql/14/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/postgresql/14/data" -o "-p 50432 -b -c synchronous_commit=off -c fsync=off -c full_page_writes=off -c vacuum_defer_cleanup_age=0 -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/var/lib/postgresql'" start
Failure, exiting
Is there anything I'm doing wrong?
I've tried to run an update from PG 12 to PG 14, I currently simply have the db data in a docker volume and there's no postgres user on the host machine.
Am I doing anything wrong?
Full command and output attacked below: