This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 18%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Hello everyone.... we need to run some cron in 2 databases that I have in an instance of "Azure Database for PostgreSQL flexible server". For this, enable "azure.extensions -> pg_cron" from the portal, then it seems that I must CREATE the EXTENSION in my DB instance and for that from what I read it is using the command:
CREATE EXTENSION pg_cron SCHEMA addons;
But when I run it it gives me the following error: ERROR: schema "addons" does not exist. Should I really create the SCHEMA addons???
Thanks.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 49%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
You can install it in the default schema if you do not specify "SCHEMA addons".
Hello, I'm trying to create the extension but it tells me that it can only be created in the Postgres DB and that I must edit a file. Being a managed database, I do not have a way to access the file through the console, but from the portal I have the option to configure the "Server Parameters" and search for the word "cron.database_name" and edit the word "postgres" and add the name of my DB.
This could help, the thing is that I have 2 BDs and in both I would need a CRON, if I add only one I will miss the other and if I add both it won't let me:
Any suggestions?
@Sebastian Pacheco Have you tried checking similar post here?https://learn.microsoft.com/en-us/answers/questions/1062471/how-to-use-pg-cron-extension-in-multiple-databases
Regards
Geetha
Hello, yes I had seen it... in the end I modified the "cron.database_name" option of postgres to the name of my DB, then I installed the extension and I was able to run the cron on that DB. I think that using the "schedule_in_database" option I could add another cron to ANOTHER DB.
Thanks!