I'm currently facing an issue while trying to install the pg_cron extension with PostgreSQL on macOS. I've followed the steps outlined in the documentation and various online resources, but I'm encountering difficulties getting it to work properly.
Description of the Issue:
- I have PostgreSQL 14.11 installed on my macOS system.
- I've downloaded and compiled pg_cron version 1.4.1 from the GitHub repository.
- I've configured pg_cron in the postgresql.conf file by adding shared_preload_libraries = 'timescaledb, pg_cron' (I already have timescaledb and want to adding pg_cron However, upon starting PostgreSQL, I'm encountering errors related to loading the pg_cron library.
Step i tried:
- Cloned the pg_cron repository from GitHub. --> https://github.com/citusdata/pg_cron
- Checked out the v1.4.1 release.
- Compiled pg_cron using make. Then i got error from make and fixed it by remove -Werror in Makefile of pg_cron
- Added pg_cron to the shared_preload_libraries parameter in postgresql.conf
- Restarted PostgreSQL. (got error could not start server)
Question: Can anyone provide guidance on how to correctly configure pg_cron with PostgreSQL on macOS? Are there any additional steps or configurations I might be missing? How can I troubleshoot the error preventing the PostgreSQL server from starting after adding pg_cron to shared_preload_libraries?
