You can install it in the default schema if you do not specify "SCHEMA addons".
Activate pg_cron
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.
2 answers
Sort by: Most helpful
-
-
GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee
2024-03-25T15:26:18.9833333+00:00 @Sebastian Pacheco Have you tried checking similar post here?https://video2.skills-academy.com/en-us/answers/questions/1062471/how-to-use-pg-cron-extension-in-multiple-databases
Regards
Geetha