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
feita há 3 meses182 visualizações
4 Respostas
0
Resposta aceita

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
ESPECIALISTA
respondido há 3 meses
0
AWS
ESPECIALISTA
Mike_L
respondido há 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
ESPECIALISTA
respondido há 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 há 3 meses

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas