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
preguntada hace 3 meses182 visualizaciones
4 Respuestas
0
Respuesta aceptada

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
EXPERTO
respondido hace 3 meses
0
AWS
EXPERTO
Mike_L
respondido hace 3 meses
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
EXPERTO
respondido hace 3 meses
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
respondido hace 3 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas