Missing pg_cron--1.3.sql on PostgreSQL 9.5 / 9.6 installation

[xinxue205]

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!

[xinxue205]

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

[marcocitus]

Thanks for reporting. Did you get the package from PGDG or are you building from source?

[xinxue205]

build? you mean make & make install? yes, I download your source code from tag 1.3 in git, and make & make install on centos?

[xinxue205]

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.

[marcocitus]

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;

[hanefi]

PG 9.6 EOLd more than a year ago. I think it is ok to close this issue now.