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
demandé il y a 3 mois182 vues
4 réponses
0
Réponse acceptée

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
EXPERT
répondu il y a 3 mois
0
AWS
EXPERT
Mike_L
répondu il y a 3 mois
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
EXPERT
répondu il y a 3 mois
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
répondu il y a 3 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions