pg_partman support for pg17

[Rammurthy5]

Hiya, i dont see partman listed as extensions in Pg17 spock extension.

could that be added please?

Postgres pg15 15.14-1 2025-08-15 prod Postgres pg16 16.10-1 2025-08-15 prod Postgres pg17 17.6-1 2025-08-15 prod Installed Extensions audit-pg17 17.1-1 2025-08-15 prod Extensions cron-pg17 1.6.4-2 2025-08-15 prod Extensions hintplan-pg17 1.7.0-2 2025-08-15 prod Extensions lolor-pg17 1.2-2 2025-08-15 prod Extensions orafce-pg17 4.14.4-1 2025-08-15 prod Extensions pldebugger-pg17 1.8-2 2025-08-15 prod Extensions plprofiler-pg17 4.2.5-2 2025-08-15 prod Extensions plv8-pg17 3.2.3-2 2025-08-15 prod Extensions postgis-pg17 3.5.3-1 2025-08-15 prod Extensions setuser-pg17 4.1.0-2 2025-08-15 prod Extensions snowflake-pg17 2.2-2 2025-08-15 prod Installed Extensions spock40-pg17 4.0.10-1 2025-02-24 prod Extensions spock50-pg17 5.0.2-1 2025-09-18 prod Installed Extensions vector-pg17 0.8.0-2 2025-08-15 prod Applications etcd 3.5.12-2 2024-03-28 prod EL Applications patroni 3.2.2.2-1 2024-11-07 prod EL

[mason-sharp]

It looks like you may be using the pgedge CLI. Since pg_partman is not packaged with it, you would need to manually install it on your nodes. Most Postgres extensions should work with pgedge.

[Rammurthy5]

Thanks Mason. Yes, I'm using cli with Spock.
Typically, we have seen partman packaged with cli in pg15 and 16. Is there a specific reason it's not packaged with 17, please?

I'm concerned manual installation might not work as smooth as it is with CLI which I presume may have been tested by pgEdge team already.

[Rammurthy5]

@mason-sharp could you advise best approach to install this extension manually, please?