search

tianon / docker-postgres-upgrade

a PoC for using "pg_upgrade" inside Docker -- learn from it, adapt it for your needs; don't expect it to work as-is!
https://hub.docker.com/r/tianon/postgres-upgrade/
MIT License
1.08k stars 116 forks source link

After latest version upgrade, The 13-14 image no longer works #62

Closed maudrid closed 2 years ago

maudrid commented 2 years ago

This was working fine yesterday, did a pull from docker hub today and it's now broken: Here is the error message:

The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are enabled.

fixing permissions on existing directory /var/lib/postgresql/14/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

Success. You can now start the database server using:

    pg_ctl -D /var/lib/postgresql/14/data -l logfile start

check for "/usr/lib/postgresql/14/bin/pg_dump" failed: incorrect version: found "pg_dump (PostgreSQL) 14.2 (Debian 14.2-1.pgdg110+1)", expected "pg_dump (PostgreSQL) 14.3 (Debian 14.3-1.pgdg110+1)"
Failure, exiting
maudrid commented 2 years ago

I found that the culprit is postgresql-plpython3-14 After installing this plugin, pg_upgrade version number changes to 14.3. So it's not caused by this project.