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
gefragt vor 3 Monaten182 Aufrufe
4 Antworten
0
Akzeptierte Antwort

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
EXPERTE
beantwortet vor 3 Monaten
0
AWS
EXPERTE
Mike_L
beantwortet vor 3 Monaten
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
EXPERTE
beantwortet vor 3 Monaten
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
beantwortet vor 3 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen