Postgres pg_cron extension
Dear all,
I am trying to enable pg_cron extension in RDS postgres and I got to know
it will be enabled only in custom parameter group..it can't be enabled in
default one.
1. Suppose if we create a custom group for existing postgres 14
databases,will all the existing parameters in default group gets copied
over to custom group?
2.Also will there be any impact if we change this parameter group?
3.Also if we upgrade 14 to 15 in future,Do we need to change the parameter
to 15 compatible?
Apologies if its in wrong forum,
Thanks,
Arun
Yes, definitely the wrong forum. RDS is not Postgres, and "parameter
groups" is an Amazon thing. A quick web search would seem to indicate that
the default group is replaced by the custom one, rather than enhancing it.
But really, this is a simple "try it and see" sort of task.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/parameter-groups-overview.html
Other than that, reach out to Amazon support.
Cheers,
Greg
On Wed, Feb 14, 2024 at 10:23 AM Greg Sabino Mullane <htamfids@gmail.com>
wrote:
Yes, definitely the wrong forum. RDS is not Postgres, and "parameter
groups" is an Amazon thing. A quick web search would seem to indicate that
the default group is replaced by the custom one, rather than enhancing it.
But really, this is a simple "try it and see" sort of task.https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/parameter-groups-overview.html
Parameter Groups are AWS' name for, and clunky web implementation of,
postgresql.conf. You can use the same Parameter Group for multiple
instances, or you can create a different PaGr for each instance.
(Modifying a PaGr via the aws cli made it tolerably useful.)