pg_fact_loader
build fact tables with Postgres
Module:
Categories:
Overview
PGDG 1st Party Extension: pg_fact_loader
: build fact tables with Postgres
Information
- Extension ID: 9820
- Extension Name:
pg_fact_loader
- Package Name:
pg_fact_loader
- Category:
ETL
- License: MIT
- Website: https://github.com/enova/pg_fact_loader
- Language: C
- Extra Tags: N/A
- Comment: N/A
Metadata
- Latest Version: 2.0
- Postgres Support:
17
,16
,15
,14
,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION
DDL - Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas:
fact_loader
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_fact_loader_$v*
- RPM Ver :
2.0
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-fact-loader
- DEB Ver :
2.0
- DEB Deps: N/A
Packages
Installation
Install pg_fact_loader
via the pig
CLI tool:
pig ext install pg_fact_loader
Install pg_fact_loader
via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_fact_loader"]}' # -l <cls>
Install pg_fact_loader
RPM from YUM repo directly:
dnf install pg_fact_loader_17*;
dnf install pg_fact_loader_16*;
dnf install pg_fact_loader_15*;
dnf install pg_fact_loader_14*;
dnf install pg_fact_loader_13*;
Install pg_fact_loader
DEB from APT repo directly:
apt install postgresql-17-pg-fact-loader;
apt install postgresql-16-pg-fact-loader;
apt install postgresql-15-pg-fact-loader;
apt install postgresql-14-pg-fact-loader;
apt install postgresql-13-pg-fact-loader;
Enable pg_fact_loader
extension on PostgreSQL cluster:
CREATE EXTENSION pg_fact_loader;
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.