How do I install the pg_cron extension in Postgres 13 hosted in my Windows 10

Question

I see a few guides for installing the pg_cron extension in windows, but its very confusing. Is there any guide that can help? A simple create extension in the database doesnt work. I get the below error :

ERROR:  could not open extension control file "C:/Program Files/PostgreSQL/13/share/extension/pg_cron.control": No such file or directory
SQL state: 58P01

score 3 · Accepted Answer · answered Jul 20 '21 at 11:13

You have to install the extension first.

Since you are using Windows, things will get complicated. You need a C compiler and build instructions from source. There are no such build instructions available, but somebody has managed to do it before and suggested modifications that were never merged.

Based on this and my personal experience with pg_cron bugs, I have the feeling that Microsoft doesn't care for this project very much, and that you will have a hard time getting it to run on Windows.

Alternatively, you could try your luck with pg_timetable, but you'd have to build that from source too.

You might end up using pgAgent, for which pre-built Windows binaries exist.

How do I install the pg_cron extension in Postgres 13 hosted in my Windows 10

1 Answers1