firebird_fdw

Website

https://github.com/ibarwick/firebird_fdw/

Description

firebird_fdw is a foreign data wrapper (FDW) to connect PostgreSQL to Firebird. It provides both read (SELECT) and write (INSERT/UPDATE/DELETE) support, WHERE-clause pushdowns, connection caching and Firebird transaction support.

Package naming convention

The PostgreSQL RPM repository uses PostgreSQL version numbers in the RPM packages. For example firebird_fdw for PostgreSQL 17 is named as firebird_fdw_17. Similarly firebird_fdw for PostgreSQL 15 is named as firebird_fdw_15.

Subpackages

firebird_fdw provides the following subpackages:

  • llvmjit: Provides just-in-time compilation support for firebird_fdw

Package specifications and repository requirements

PostgreSQL PGDG RPM repository

Install PGDG repository from: https://yum.postgresql.org/repopackages/

Installation

OS Command
RHEL / Rocky Linux / AlmaLinux / Fedora dnf install firebird_fdw_17 (or change the version as described above)

Post-installation

Connect to the database that you want to create the extension as superuser and run:
CREATE EXTENSION firebird_fdw;

Usage examples

Please visit firebird_fdw documentation for options while creating the foreign server and using it.

Available packages

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

News