https://github.com/pramsey/pgsql_http/
pgsql_http allows users to be able to write a trigger that calls a web service either to get back a result, or to poke that service into refreshing itself against the new state of the database.
The PostgreSQL RPM repository uses PostgreSQL version numbers in the RPM packages. For example pgsql_http for PostgreSQL 17 is named as pgsql_http_17. Similarly pgsql_http for PostgreSQL 15 is named as pgsql_http_15.
pgsql_http provides the following subpackages:
Install PGDG repository from: https://yum.postgresql.org/repopackages/
| OS | Command |
|---|---|
| RHEL / Rocky Linux / AlmaLinux / Fedora | dnf install pgsql_http_17 (or change the version as described above) |
Connect to the database that you want to create the extension as superuser and run:
CREATE EXTENSION http;
You can use the following GUC to manage this extension. See extension documentation for details:
http.keepalive # (boolean) Maintain connections as long as possible . Default: off http.timeout_msec # (integer) Timeout (in miliseconds) for the completion of a request. Default: 0
| PostgreSQL version(s) | OS version | Arch | Status |
|---|---|---|---|
| 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 9 | x86_64, aarch64 | Available |
| 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 8 | x86_64, aarch64 | Available |
| 17,16,15,14,13 | Fedora Linux | x86_64 | Available |