pg_cron
pg_cron copied to clipboard
Missing pg_cron--1.3.sql on PostgreSQL 9.5 / 9.6 installation
installed pg_cron, and restart succ. but error occurs when CREATE EXTENSION pg_cron: ERROR: could not stat file "/home/postgres/pgsql/share/postgresql/extension/pg_cron--1.3.sql": No such file or directory pg version: postgresql-9.5.22 centos 6.5 with linux 2.6.32-504.16.2.el6.x86_64
thx!
there are no pg_cron--1.3.sql under /home/postgres/pgsql/share/postgresql/extension/ but has below files: pg_cron--1.0--1.1.sql pg_cron--1.0.sql pg_cron--1.1--1.2.sql pg_cron--1.2--1.3.sql pg_cron.control
Thanks for reporting. Did you get the package from PGDG or are you building from source?
build? you mean make & make install? yes, I download your source code from tag 1.3 in git, and make & make install on centos?
make install logs: [postgres@i-vhqdp65i pg_cron-1.3.0]$ make install /bin/mkdir -p '/home/postgres/pgsql/lib/postgresql' /bin/mkdir -p '/home/postgres/pgsql/share/postgresql/extension' /bin/mkdir -p '/home/postgres/pgsql/share/postgresql/extension' /usr/bin/install -c -m 755 pg_cron.so '/home/postgres/pgsql/lib/postgresql/pg_cron.so' /usr/bin/install -c -m 644 .//pg_cron.control '/home/postgres/pgsql/share/postgresql/extension/' /usr/bin/install -c -m 644 .//pg_cron--1.0--1.1.sql .//pg_cron--1.1--1.2.sql .//pg_cron--1.2--1.3.sql pg_cron--1.0.sql '/home/postgres/pgsql/share/postgresql/extension/'
no pg_cron--1.3.sql but needed when CREATE EXTENSION.
Got it, seems the Makefile is broken for PostgreSQL 9.5.
You can work around it by running:
CREATE EXTENSION pg_cron VERSION "1.0";
ALTER EXTENSION pg_cron UPDATE;
PG 9.6 EOLd more than a year ago. I think it is ok to close this issue now.