I need to install pg_partman v5.2.4

Question

I need to install pg_partman v5.2.4

Leandro Silva - KMM 0

Hello,

I need to install pg_partman v5.2.4 in my Postgres database. This link has a step-by-step guide

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-use-pg-partman

, but it doesn't provide a way to define the pg_partman version I want.

v5.2.4 supports a varchar column filled with UUIDv7 values.

How can I install this version on my database?

Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-05T08:36:11.37+00:00

Leandro Silva - KMM
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Leandro Silva - KMM 0 Reputation points

2025-05-06T13:04:41.93+00:00

It did. I'm checking how to solve my problem. The 5.0.1 version does not support the functionalities I need. Is there a way to request an update from pg_partman to version 5.2.4? My database is a service-managed by Azure
Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-06T14:02:19.16+00:00
To install pg_partman v5.2.4 in your PostgreSQL database, follow these steps:

Download pg_partman v5.2.4:

Visit the pg_partman GitHub releases page and download the v5.2.4 release 1.

Install pg_partman:

Extract the downloaded files.

Navigate to the extracted directory and run the following commands

make sudo make install

Create Extension in PostgreSQL:

Connect to your PostgreSQL database and run:

CREATE EXTENSION pg_partman;

Configure pg_partman:

Set up the partitioning configuration according to your needs. For UUIDv7 values, ensure your partition column is correctly defined as varchar.

For more detailed instructions, you can refer to the pg_partman documentation

Regarding the service area, this falls under database management and extension installation for PostgreSQL.

Is there anything else you need help with?
Leandro Silva - KMM 0 Reputation points

2025-05-06T17:23:50.72+00:00

Thanks. My database(Azure Database for PostgreSQL) is a managed service. Is there no restriction on updating extensions in a managed service? Do I have permission, considering I'm the admin user, to access the database terminal and run commands like "create extension..."?
Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-07T10:43:15.3566667+00:00
Leandro Silva - KMM
When using Azure Database for PostgreSQL as a managed service, you do have the ability to run extension commands like CREATE EXTENSION or ALTER EXTENSION using your administrative credentials, but there are some important limitations:

Supported Extensions Only: Only PostgreSQL extensions that are on Microsoft’s allowlist are available for creation or updating. If you try to install or update an extension that isn’t allowed or provided by the service, the command will fail.

Updating Extensions: You can update an extension using the ALTER EXTENSION <extension> UPDATE; command; however, you’re restricted to upgrading only to the latest version provided by Azure. There is no support for choosing intermediate versions or downgrading without involving Azure Support.

Admin Privileges in Managed Service: Although you’re the admin user, Azure Database for PostgreSQL does not grant full superuser capabilities like an on-premises or self-managed PostgreSQL instance would. Instead, the service provides a managed “admin” role with sufficient privileges to create and update the allowed extensions while ensuring that the managed environment remains secure and stable.

In summary, while there is no blanket restriction that prevents you from running commands such as CREATE EXTENSION... or updating them, these operations are confined within the boundaries of the supported extensions and the managed service’s policies.

Do you need additional details on checking which extensions are supported or any further guidance on managing extensions in your managed PostgreSQL environment?
1)Update extensions
2)MicrosoftDocs/azure-databases-docs
Leandro Silva - KMM 0 Reputation points

2025-05-07T21:26:41.9366667+00:00

Thanks for your help

1 answer

Your answer

Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-05T08:36:11.37+00:00

Leandro Silva - KMM
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Leandro Silva - KMM 0 Reputation points

2025-05-06T13:04:41.93+00:00

It did. I'm checking how to solve my problem. The 5.0.1 version does not support the functionalities I need. Is there a way to request an update from pg_partman to version 5.2.4? My database is a service-managed by Azure
Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-06T14:02:19.16+00:00

To install pg_partman v5.2.4 in your PostgreSQL database, follow these steps:

Download pg_partman v5.2.4:

Visit the pg_partman GitHub releases page and download the v5.2.4 release 1.

Install pg_partman:

Extract the downloaded files.

Navigate to the extracted directory and run the following commands

make sudo make install

Create Extension in PostgreSQL:

Connect to your PostgreSQL database and run:

CREATE EXTENSION pg_partman;

Configure pg_partman:

Set up the partitioning configuration according to your needs. For UUIDv7 values, ensure your partition column is correctly defined as varchar.

For more detailed instructions, you can refer to the pg_partman documentation

Regarding the service area, this falls under database management and extension installation for PostgreSQL.

Is there anything else you need help with?
Leandro Silva - KMM 0 Reputation points

2025-05-06T17:23:50.72+00:00

Thanks. My database(Azure Database for PostgreSQL) is a managed service. Is there no restriction on updating extensions in a managed service? Do I have permission, considering I'm the admin user, to access the database terminal and run commands like "create extension..."?
Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator

2025-05-07T10:43:15.3566667+00:00

Leandro Silva - KMM
When using Azure Database for PostgreSQL as a managed service, you do have the ability to run extension commands like CREATE EXTENSION or ALTER EXTENSION using your administrative credentials, but there are some important limitations:

Supported Extensions Only: Only PostgreSQL extensions that are on Microsoft’s allowlist are available for creation or updating. If you try to install or update an extension that isn’t allowed or provided by the service, the command will fail.

Updating Extensions: You can update an extension using the ALTER EXTENSION <extension> UPDATE; command; however, you’re restricted to upgrading only to the latest version provided by Azure. There is no support for choosing intermediate versions or downgrading without involving Azure Support.

Admin Privileges in Managed Service: Although you’re the admin user, Azure Database for PostgreSQL does not grant full superuser capabilities like an on-premises or self-managed PostgreSQL instance would. Instead, the service provides a managed “admin” role with sufficient privileges to create and update the allowed extensions while ensuring that the managed environment remains secure and stable.

In summary, while there is no blanket restriction that prevents you from running commands such as CREATE EXTENSION... or updating them, these operations are confined within the boundaries of the supported extensions and the managed service’s policies.

Do you need additional details on checking which extensions are supported or any further guidance on managing extensions in your managed PostgreSQL environment?
1)Update extensions
2)MicrosoftDocs/azure-databases-docs
Leandro Silva - KMM 0 Reputation points

2025-05-07T21:26:41.9366667+00:00

Thanks for your help

Answer 1

Hi Leandro Silva - KMM
It looks like you're trying to install pg_partman v5.2.4 for your PostgreSQL database, and you need guidance on specifying that version since the documentation doesn't cover that.

Here's what you can do:

Check Version Availability: First, confirm that the version you want (5.2.4) is available for your PostgreSQL version. Based on the documentation, pg_partman v5.2.4 is not listed in the Azure PostgreSQL flexible server documentation, as they typically provide a limited set of versions.
Installing the Extension: If you have confirmed that your PostgreSQL version supports pg_partman v5.2.4, you would typically create the extension using:
```
   CREATE EXTENSION pg_partman;
```
However, to specify a version, you would need to have access to the specific binaries for that release, which might not be available on Azure directly.
Manually Installing from Source: If the version isn't available directly, you might need to download the source code from the official pg_partman GitHub, then build it and install it manually on a self-managed PostgreSQL instance.
Using a Different Environment: If Azure doesn't provide the version you need, consider hosting your PostgreSQL on a VM or using another cloud provider where you have more control over the installation of such extensions.
Check Compatibility: Since you mentioned that v5.2.4 supports UUIDv7, double-check the compatibility of the rest of your setup (like the PostgreSQL version) with that feature.

I hope this gives you a good starting point! If you have any further questions or need more details, feel free to ask.

Please refer the below document for more information https://github.com/pgpartman/pg_partman/blob/development/doc/pg_partman.md
https://github.com/pgpartman/pg_partman/releases

Share via

I need to install pg_partman v5.2.4

1 answer

Your answer