4 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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.
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} | {"","",""}
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.
répondu il y a 3 mois
Contenus pertinents
- demandé il y a un an
- demandé il y a 4 mois
- demandé il y a 2 mois
- demandé il y a 2 mois
- AWS OFFICIELA mis à jour il y a 4 ans
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a un an