Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres pg_cron extension

Postgres pg_cron extension

From
arun chirappurath
Date:
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

Re: Postgres pg_cron extension

From
Greg Sabino Mullane
Date:
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.

Other than that, reach out to Amazon support.

Cheers,
Greg

Re: Postgres pg_cron extension

From
Ron Johnson
Date:
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.

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.)