log_fdw

log_fdw

foreign-data wrapper for Postgres log file access

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
8810
log_fdw
log_fdw
1.4
FDW
Apache-2.0
C
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
--s-d--
No
Yes
No
Yes
no
no
Relationships
See Also
pg_sqlog
pgaudit
file_fdw
auto_explain
pgauditlogtofile
logerrors
wrappers
multicorn

PG18 fixed by vonng

Packages

TypeRepoVersionPG Major AvailabilityPackage PatternDependencies
EL
PIGSTY
1.4
18
17
16
15
14
13
log_fdw_$v*-
Debian
PIGSTY
1.4
18
17
16
15
14
13
postgresql-$v-log-fdw-
Linux / PGPG18PG17PG16PG15PG14PG13
el8.x86_64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
MISS
el8.aarch64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
MISS
el9.x86_64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
MISS
el9.aarch64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
MISS
el10.x86_64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
MISS
el10.aarch64
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
MISS
d12.x86_64
MISS
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
MISS
d12.aarch64
MISS
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
MISS
d13.x86_64
MISS
MISS
MISS
MISS
MISS
MISS
d13.aarch64
MISS
MISS
MISS
MISS
MISS
MISS
u22.x86_64
MISS
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
MISS
u22.aarch64
MISS
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
MISS
u24.x86_64
MISS
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
MISS
u24.aarch64
MISS
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
PIGSTY 1.4
MISS
PackageVersionOSORGSIZEFile URL
log_fdw_181.4el8.x86_64pigsty20.0 KiBlog_fdw_18-1.4-2PIGSTY.el8.x86_64.rpm
log_fdw_181.4el8.aarch64pigsty20.1 KiBlog_fdw_18-1.4-2PIGSTY.el8.aarch64.rpm
log_fdw_181.4el9.x86_64pigsty20.2 KiBlog_fdw_18-1.4-2PIGSTY.el9.x86_64.rpm
log_fdw_181.4el9.aarch64pigsty20.1 KiBlog_fdw_18-1.4-2PIGSTY.el9.aarch64.rpm
log_fdw_181.4el10.x86_64pigsty20.3 KiBlog_fdw_18-1.4-2PIGSTY.el10.x86_64.rpm
log_fdw_181.4el10.aarch64pigsty20.3 KiBlog_fdw_18-1.4-2PIGSTY.el10.aarch64.rpm
PackageVersionOSORGSIZEFile URL
log_fdw_171.4el8.x86_64pigsty20.0 KiBlog_fdw_17-1.4-2PIGSTY.el8.x86_64.rpm
log_fdw_171.4el8.x86_64pigsty19.4 KiBlog_fdw_17-1.4-1PIGSTY.el8.x86_64.rpm
log_fdw_171.4el8.aarch64pigsty19.2 KiBlog_fdw_17-1.4-1PIGSTY.el8.aarch64.rpm
log_fdw_171.4el8.aarch64pigsty20.1 KiBlog_fdw_17-1.4-2PIGSTY.el8.aarch64.rpm
log_fdw_171.4el9.x86_64pigsty19.8 KiBlog_fdw_17-1.4-1PIGSTY.el9.x86_64.rpm
log_fdw_171.4el9.x86_64pigsty20.2 KiBlog_fdw_17-1.4-2PIGSTY.el9.x86_64.rpm
log_fdw_171.4el9.aarch64pigsty19.4 KiBlog_fdw_17-1.4-1PIGSTY.el9.aarch64.rpm
log_fdw_171.4el9.aarch64pigsty20.1 KiBlog_fdw_17-1.4-2PIGSTY.el9.aarch64.rpm
log_fdw_171.4el10.x86_64pigsty20.3 KiBlog_fdw_17-1.4-2PIGSTY.el10.x86_64.rpm
log_fdw_171.4el10.x86_64pigsty19.8 KiBlog_fdw_17-1.4-1PIGSTY.el10.x86_64.rpm
log_fdw_171.4el10.aarch64pigsty20.3 KiBlog_fdw_17-1.4-2PIGSTY.el10.aarch64.rpm
postgresql-17-log-fdw1.4d12.x86_64pigsty32.6 KiBpostgresql-17-log-fdw_1.4-1PIGSTY~bookworm_amd64.deb
postgresql-17-log-fdw1.4d12.aarch64pigsty32.4 KiBpostgresql-17-log-fdw_1.4-1PIGSTY~bookworm_arm64.deb
postgresql-17-log-fdw1.4u22.x86_64pigsty34.1 KiBpostgresql-17-log-fdw_1.4-1PIGSTY~jammy_amd64.deb
postgresql-17-log-fdw1.4u22.aarch64pigsty33.6 KiBpostgresql-17-log-fdw_1.4-1PIGSTY~jammy_arm64.deb
postgresql-17-log-fdw1.4u24.x86_64pigsty28.8 KiBpostgresql-17-log-fdw_1.4-1PIGSTY~noble_amd64.deb
postgresql-17-log-fdw1.4u24.aarch64pigsty28.5 KiBpostgresql-17-log-fdw_1.4-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
log_fdw_161.4el8.x86_64pigsty19.3 KiBlog_fdw_16-1.4-1PIGSTY.el8.x86_64.rpm
log_fdw_161.4el8.x86_64pigsty20.0 KiBlog_fdw_16-1.4-2PIGSTY.el8.x86_64.rpm
log_fdw_161.4el8.aarch64pigsty19.2 KiBlog_fdw_16-1.4-1PIGSTY.el8.aarch64.rpm
log_fdw_161.4el8.aarch64pigsty20.1 KiBlog_fdw_16-1.4-2PIGSTY.el8.aarch64.rpm
log_fdw_161.4el9.x86_64pigsty20.2 KiBlog_fdw_16-1.4-2PIGSTY.el9.x86_64.rpm
log_fdw_161.4el9.x86_64pigsty19.6 KiBlog_fdw_16-1.4-1PIGSTY.el9.x86_64.rpm
log_fdw_161.4el9.aarch64pigsty19.4 KiBlog_fdw_16-1.4-1PIGSTY.el9.aarch64.rpm
log_fdw_161.4el9.aarch64pigsty20.2 KiBlog_fdw_16-1.4-2PIGSTY.el9.aarch64.rpm
log_fdw_161.4el10.x86_64pigsty19.8 KiBlog_fdw_16-1.4-1PIGSTY.el10.x86_64.rpm
log_fdw_161.4el10.x86_64pigsty20.3 KiBlog_fdw_16-1.4-2PIGSTY.el10.x86_64.rpm
log_fdw_161.4el10.aarch64pigsty20.3 KiBlog_fdw_16-1.4-2PIGSTY.el10.aarch64.rpm
postgresql-16-log-fdw1.4d12.x86_64pigsty32.6 KiBpostgresql-16-log-fdw_1.4-1PIGSTY~bookworm_amd64.deb
postgresql-16-log-fdw1.4d12.aarch64pigsty32.3 KiBpostgresql-16-log-fdw_1.4-1PIGSTY~bookworm_arm64.deb
postgresql-16-log-fdw1.4u22.x86_64pigsty34.1 KiBpostgresql-16-log-fdw_1.4-1PIGSTY~jammy_amd64.deb
postgresql-16-log-fdw1.4u22.aarch64pigsty33.7 KiBpostgresql-16-log-fdw_1.4-1PIGSTY~jammy_arm64.deb
postgresql-16-log-fdw1.4u24.x86_64pigsty28.7 KiBpostgresql-16-log-fdw_1.4-1PIGSTY~noble_amd64.deb
postgresql-16-log-fdw1.4u24.aarch64pigsty28.5 KiBpostgresql-16-log-fdw_1.4-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
log_fdw_151.4el8.x86_64pigsty20.1 KiBlog_fdw_15-1.4-2PIGSTY.el8.x86_64.rpm
log_fdw_151.4el8.x86_64pigsty19.4 KiBlog_fdw_15-1.4-1PIGSTY.el8.x86_64.rpm
log_fdw_151.4el8.aarch64pigsty20.1 KiBlog_fdw_15-1.4-2PIGSTY.el8.aarch64.rpm
log_fdw_151.4el8.aarch64pigsty19.2 KiBlog_fdw_15-1.4-1PIGSTY.el8.aarch64.rpm
log_fdw_151.4el9.x86_64pigsty20.2 KiBlog_fdw_15-1.4-2PIGSTY.el9.x86_64.rpm
log_fdw_151.4el9.x86_64pigsty19.9 KiBlog_fdw_15-1.4-1PIGSTY.el9.x86_64.rpm
log_fdw_151.4el9.aarch64pigsty19.4 KiBlog_fdw_15-1.4-1PIGSTY.el9.aarch64.rpm
log_fdw_151.4el9.aarch64pigsty20.1 KiBlog_fdw_15-1.4-2PIGSTY.el9.aarch64.rpm
log_fdw_151.4el10.x86_64pigsty20.3 KiBlog_fdw_15-1.4-2PIGSTY.el10.x86_64.rpm
log_fdw_151.4el10.x86_64pigsty19.8 KiBlog_fdw_15-1.4-1PIGSTY.el10.x86_64.rpm
log_fdw_151.4el10.aarch64pigsty20.3 KiBlog_fdw_15-1.4-2PIGSTY.el10.aarch64.rpm
postgresql-15-log-fdw1.4d12.x86_64pigsty32.5 KiBpostgresql-15-log-fdw_1.4-1PIGSTY~bookworm_amd64.deb
postgresql-15-log-fdw1.4d12.aarch64pigsty32.2 KiBpostgresql-15-log-fdw_1.4-1PIGSTY~bookworm_arm64.deb
postgresql-15-log-fdw1.4u22.x86_64pigsty33.9 KiBpostgresql-15-log-fdw_1.4-1PIGSTY~jammy_amd64.deb
postgresql-15-log-fdw1.4u22.aarch64pigsty33.6 KiBpostgresql-15-log-fdw_1.4-1PIGSTY~jammy_arm64.deb
postgresql-15-log-fdw1.4u24.x86_64pigsty28.8 KiBpostgresql-15-log-fdw_1.4-1PIGSTY~noble_amd64.deb
postgresql-15-log-fdw1.4u24.aarch64pigsty28.5 KiBpostgresql-15-log-fdw_1.4-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
log_fdw_141.4el8.x86_64pigsty19.4 KiBlog_fdw_14-1.4-1PIGSTY.el8.x86_64.rpm
log_fdw_141.4el8.x86_64pigsty20.1 KiBlog_fdw_14-1.4-2PIGSTY.el8.x86_64.rpm
log_fdw_141.4el8.aarch64pigsty20.1 KiBlog_fdw_14-1.4-2PIGSTY.el8.aarch64.rpm
log_fdw_141.4el8.aarch64pigsty19.2 KiBlog_fdw_14-1.4-1PIGSTY.el8.aarch64.rpm
log_fdw_141.4el9.x86_64pigsty19.7 KiBlog_fdw_14-1.4-1PIGSTY.el9.x86_64.rpm
log_fdw_141.4el9.x86_64pigsty20.2 KiBlog_fdw_14-1.4-2PIGSTY.el9.x86_64.rpm
log_fdw_141.4el9.aarch64pigsty19.4 KiBlog_fdw_14-1.4-1PIGSTY.el9.aarch64.rpm
log_fdw_141.4el9.aarch64pigsty20.1 KiBlog_fdw_14-1.4-2PIGSTY.el9.aarch64.rpm
log_fdw_141.4el10.x86_64pigsty19.8 KiBlog_fdw_14-1.4-1PIGSTY.el10.x86_64.rpm
log_fdw_141.4el10.x86_64pigsty20.3 KiBlog_fdw_14-1.4-2PIGSTY.el10.x86_64.rpm
log_fdw_141.4el10.aarch64pigsty20.3 KiBlog_fdw_14-1.4-2PIGSTY.el10.aarch64.rpm
postgresql-14-log-fdw1.4d12.x86_64pigsty32.4 KiBpostgresql-14-log-fdw_1.4-1PIGSTY~bookworm_amd64.deb
postgresql-14-log-fdw1.4d12.aarch64pigsty32.1 KiBpostgresql-14-log-fdw_1.4-1PIGSTY~bookworm_arm64.deb
postgresql-14-log-fdw1.4u22.x86_64pigsty33.8 KiBpostgresql-14-log-fdw_1.4-1PIGSTY~jammy_amd64.deb
postgresql-14-log-fdw1.4u22.aarch64pigsty33.5 KiBpostgresql-14-log-fdw_1.4-1PIGSTY~jammy_arm64.deb
postgresql-14-log-fdw1.4u24.x86_64pigsty28.8 KiBpostgresql-14-log-fdw_1.4-1PIGSTY~noble_amd64.deb
postgresql-14-log-fdw1.4u24.aarch64pigsty28.5 KiBpostgresql-14-log-fdw_1.4-1PIGSTY~noble_arm64.deb

Source

pig build get log_fdw; # get log_fdw source code
pig build dep log_fdw; # install build dependencies
pig build pkg log_fdw; # build extension rpm or deb
pig build ext log_fdw; # build extension rpms

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install log_fdw; # install by extension name, for the current active PG version
pig ext install log_fdw; # install via package alias, for the active PG version
pig ext install log_fdw -v 18;   # install for PG 18
pig ext install log_fdw -v 17;   # install for PG 17
pig ext install log_fdw -v 16;   # install for PG 16
pig ext install log_fdw -v 15;   # install for PG 15
pig ext install log_fdw -v 14;   # install for PG 14

Create this extension with:

CREATE EXTENSION log_fdw;
Last updated on