Does Aurora PostgreSQL serverless support pg_partman?

0

I am trying to archive a datatable from Aurora PostgreSQL serverless db. I read about pg_partman for Postgres. I don't think we can do it for serverless. Right? Please let me know if it is supported or not. If it is, then can you please refer me to an article about it?

Thanks, Indu.

Indu
已提问 3 个月前182 查看次数
4 回答
0
已接受的回答

I don't think it can be used with Aurora PostgreSQL 11.x.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraPostgreSQL.Extensions.html#AuroraPostgreSQL.Extensions.11

I have enabled the extension on Aurora Serverless v2 PostgreSQL version 15.4.

profile picture
专家
已回答 3 个月前
0
AWS
专家
Mike_L
已回答 3 个月前
0

Hello.

I was able to create Aurora Serverless and enable "pg_partman".
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/PostgreSQL_Partitions.html

I was able to confirm up to the point of enabling it.
I recommend that you check the operation in your own environment.

postgres=> SELECT * FROM pg_available_extensions WHERE name IN ('pg_partman') ORDER BY name;
    name    | default_version | installed_version |                       comment
------------+-----------------+-------------------+------------------------------------------------------
 pg_partman | 4.7.3           |                   | Extension to manage partitioned tables by time or ID
(1 row)

postgres=> CREATE SCHEMA partman;
postgres=> CREATE EXTENSION pg_partman WITH SCHEMA partman;

postgres=> SELECT * FROM pg_extension;
  oid  |  extname   | extowner | extnamespace | extrelocatable | extversion |      extconfig      | extcondition
-------+------------+----------+--------------+----------------+------------+---------------------+--------------
 14498 | plpgsql    |       10 |           11 | f              | 1.0        |                     |
 20523 | pg_partman |       10 |        20522 | f              | 4.7.3      | {20527,20556,20589} | {"","",""}
profile picture
专家
已回答 3 个月前
0

Thank you for your reply, I have tried the query that you have sent me. I don't see it in our extensions. We use Aurora Serverless v1 along with 11.21 version.

Indu
已回答 3 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则