Skip to content

Instantly share code, notes, and snippets.

@dincosman
Created April 20, 2024 19:43
Show Gist options
  • Select an option

  • Save dincosman/af5d7d5bcb3b6e01ec0e5514c821306d to your computer and use it in GitHub Desktop.

Select an option

Save dincosman/af5d7d5bcb3b6e01ec0e5514c821306d to your computer and use it in GitHub Desktop.
Deploy pg_cron for postgresql
[root@posvt01 pg_cron]# unzip pg_cron-main.zip
[root@posvt01 pg_cron]# cd pg_cron-main/
[root@posvt01 pg_cron-main]# make
[root@posvt01 pg_cron-main]# make install
/usr/bin/mkdir -p '/usr/pgsql-16/lib'
/usr/bin/mkdir -p '/usr/pgsql-16/share/extension'
/usr/bin/mkdir -p '/usr/pgsql-16/share/extension'
/usr/bin/install -c -m 755 pg_cron.so '/usr/pgsql-16/lib/pg_cron.so'
/usr/bin/install -c -m 644 .//pg_cron.control '/usr/pgsql-16/share/extension/'
/usr/bin/install -c -m 644 .//pg_cron--1.4-1--1.5.sql .//pg_cron--1.3--1.4.sql .//pg_cron--1.5--1.6.sql .//pg_cron--1.2--1.3.sql .//pg_cron--1.0--1.1.sql .//pg_cron--1.4--1.4-1.sql .//pg_cron--1.1--1.2.sql pg_cron--1.0.sql '/usr/pgsql-16/share/extension/'
/usr/bin/mkdir -p '/usr/pgsql-16/lib/bitcode/pg_cron'
/usr/bin/mkdir -p '/usr/pgsql-16/lib/bitcode'/pg_cron/src/
/usr/bin/install -c -m 644 src/pg_cron.bc '/usr/pgsql-16/lib/bitcode'/pg_cron/src/
/usr/bin/install -c -m 644 src/job_metadata.bc '/usr/pgsql-16/lib/bitcode'/pg_cron/src/
/usr/bin/install -c -m 644 src/misc.bc '/usr/pgsql-16/lib/bitcode'/pg_cron/src/
/usr/bin/install -c -m 644 src/task_states.bc '/usr/pgsql-16/lib/bitcode'/pg_cron/src/
/usr/bin/install -c -m 644 src/entry.bc '/usr/pgsql-16/lib/bitcode'/pg_cron/src/
cd '/usr/pgsql-16/lib/bitcode' && /usr/bin/llvm-lto -thinlto -thinlto-action=thinlink -o pg_cron.index.bc pg_cron/src/pg_cron.bc pg_cron/src/job_metadata.bc pg_cron/src/misc.bc pg_cron/src/task_states.bc pg_cron/src/entry.bc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment