question about upgrading the pg_partman version.

[prognik]

Hi All!
I installed the pg_partman extension to manage partitions in tables on two seemingly identical nodes:

1. PostgreSQL 14.18 (Ubuntu 14.18-0ubuntu0.22.04.1),
2. PostgreSQL 14.18 (Ubuntu 14.18-1.pgdg22.04+1).

The installation was done with the command
sudo apt install postgresql-14-partman.

But on the first node (1.) pg_partman 4.6.0 was installed.
And on the second node (2.) pg_partman 5.2.4 was installed.

These nodes are in wal-replication. Therefore, if I understand correctly, they should have the same version of pg_partman.
Please help me solve the issue of how to upgrade pg_partman to version 5.2.4 on PostgreSQL 14.18 (Ubuntu 14.18-0ubuntu0.22.04.1).
Thanks in advance for any help!

[keithf4]

It looks like you have the PGDG repository set up on one system (Ubuntu 14.18-1.pgdg22.04+1) but not the other. That repository usually has the more recent packages available.

https://www.postgresql.org/download/linux/ubuntu/

[keithf4]

If system one is your primary and you actually installed the extension in the database there (CREATE EXTENSION), then the replica should also have that version there. Run \dx in a psql prompt on all systems in the replication cluster and you should see the same version.

pg_partman is mostly a pl/pgsql based extension so its code is replicated via WAL. But it does have a C-based background worker for maintenance that runs on the primary (if you enabled it). If you were to fail over, that would likely throw errors until you get the matching package version installed so that the proper library file is available on the file system. You will have to restart that database instance to make sure the most recent library is loaded when you update the package.

This is true of all extensions with compiled libraries.

[prognik]

Thanks for the tip. I set the pgdg repository and updated pg_partman. Now everything is on version 5.2.4.
Thank you very much!