This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Category: ETL

ETL: Logical Replication, Decoding, CDC in protobuf/JSON/Mongo format, Copy & Load & Compare Postgres Databases,…

1: pglogical
2: pgl_ddl_deploy
3: pg_failover_slots
4: wal2json
5: wal2mongo
6: decoderbufs
7: decoder_raw
8: test_decoding
9: mimeo
10: repmgr
11: pgcopydb
12: pgloader
13: pg_fact_loader
14: pg_bulkload
15: pg_comparator
16: pgimportdoc
17: pgexportdoc

ETL category has 17 available extensions:

Extension (URL)	Alias	Repo	Version	Category	License	Description
pglogical	`pglogical`	PGDG	2.4.4	`ETL`	PostgreSQL	PostgreSQL Logical Replication
pglogical_origin	`pglogical`	PGDG	1.0.0	`ETL`	PostgreSQL	Dummy extension for compatibility when upgrading from Postgres 9.4
pglogical_ticker	`pglogical`	PGDG	1.4	`ETL`	PostgreSQL	Have an accurate view on pglogical replication delay
pgl_ddl_deploy	`pgl_ddl_deploy`	PGDG	2.2	`ETL`	MIT	automated ddl deployment using pglogical
pg_failover_slots	`pg_failover_slots`	PIGSTY	1.0.1	`ETL`	PostgreSQL	PG Failover Slots extension
wal2json	`wal2json`	PGDG	2.5.3	`ETL`	BSD 3	Changing data capture in JSON format
wal2mongo	`wal2mongo`	PIGSTY	1.0.7	`ETL`	Apache-2.0	PostgreSQL logical decoding output plugin for MongoDB
decoderbufs	`decoderbufs`	PGDG	0.1.0	`ETL`	MIT	Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
decoder_raw	`decoder_raw`	PIGSTY	1.0	`ETL`	PostgreSQL	Output plugin for logical replication in Raw SQL format
test_decoding	`test_decoding`	CONTRIB	16.3	`ETL`	PostgreSQL	SQL-based test/example module for WAL logical decoding
mimeo	`mimeo`	PIGSTY	1.5.1	`ETL`	PostgreSQL	Extension for specialized, per-table replication between PostgreSQL instances
repmgr	`repmgr`	PGDG	5.4	`ETL`	GPLv3	Replication manager for PostgreSQL
pgcopydb	`pgcopydb`	PGDG	0.15	`ETL`	PostgreSQL	Copy a Postgres database to a target Postgres server
pgloader	`pgloader`	PGDG	3.6.10	`ETL`	PostgreSQL	Migrate to PostgreSQL in a single command!
pg_fact_loader	`pg_fact_loader`	PGDG	2.0	`ETL`	MIT	build fact tables with Postgres
pg_bulkload	`pg_bulkload`	PGDG	3.1.21	`ETL`	BSD 3	pg_bulkload is a high speed data loading utility for PostgreSQL
pg_comparator	`pg_comparator`	PGDG	2.2.5	`ETL`	BSD 3	Comparation of testing and production services PostgreSQL databases.
pgimportdoc	`pgimportdoc`	PGDG	0.1.4	`ETL`	BSD 2	command line utility for importing XML, JSON, BYTEA document to PostgreSQL
pgexportdoc	`pgexportdoc`	PGDG	0.1.4	`ETL`	BSD 2	export XML, JSON and BYTEA documents from PostgreSQL

1 - pglogical

PostgreSQL Logical Replication

Overview

PGDG 1st Party Extension: pglogical : PostgreSQL Logical Replication

Information

ID: 9500
Name: pglogical
Alias: pglogical
Category: ETL
Website: https://github.com/2ndQuadrant/pglogical
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 2.4.4
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: pglogical
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pglogical_$v*
RPM Ver : 2.4.4
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-pglogical*
DEB Ver : 2.4.5
DEB Deps: Nil

Details

2 - pgl_ddl_deploy

automated ddl deployment using pglogical

Overview

PGDG 1st Party Extension: pgl_ddl_deploy : automated ddl deployment using pglogical

Information

ID: 9510
Name: pgl_ddl_deploy
Alias: pgl_ddl_deploy
Category: ETL
Website: https://github.com/enova/pgl_ddl_deploy
License: MIT License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 2.2
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: pgl_ddl_deploy
Requires: pglogical

Packages

RPM Repo: PGDG
RPM Name: pgl_ddl_deploy_$v*
RPM Ver : 2.2
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-pgl-ddl-deploy
DEB Ver : 2.2
DEB Deps: Nil

Details

3 - pg_failover_slots

PG Failover Slots extension

Overview

PIGSTY 3rd Party Extension: pg_failover_slots : PG Failover Slots extension

Information

ID: 9520
Name: pg_failover_slots
Alias: pg_failover_slots
Category: ETL
Website: https://github.com/EnterpriseDB/pg_failover_slots
License: PostgreSQL License
Language: C
Tags: nil-lic
Comment: 无

Metadata

Version: 1.0.1
PG Vers: 17,16,15,14,13,12
Need Load: Explicit Loading Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_failover_slots_$v*
RPM Ver : 1.0.1
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-failover-slots
DEB Ver : 1.0.1
DEB Deps: Nil

Details

4 - wal2json

Changing data capture in JSON format

Overview

PGDG 1st Party Extension: wal2json : Changing data capture in JSON format

Information

ID: 9610
Name: wal2json
Alias: wal2json
Category: ETL
Website: https://github.com/eulerto/wal2json
License: BSD 3 License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 2.5.3
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: wal2json_$v*
RPM Ver : 2.5.3
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-wal2json
DEB Ver : 2.5.3
DEB Deps: Nil

Details

5 - wal2mongo

PostgreSQL logical decoding output plugin for MongoDB

Overview

PIGSTY 3rd Party Extension: wal2mongo : PostgreSQL logical decoding output plugin for MongoDB

Information

ID: 9620
Name: wal2mongo
Alias: wal2mongo
Category: ETL
Website: https://github.com/HighgoSoftware/wal2mongo
License: Apache-2.0 License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0.7
PG Vers: 16,15,14,13
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: wal2mongo_$v*
RPM Ver : 1.0.7
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-wal2mongo
DEB Ver : 1.0.7
DEB Deps: Nil

Details

6 - decoderbufs

Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format

Overview

PGDG 1st Party Extension: decoderbufs : Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format

Information

ID: 9630
Name: decoderbufs
Alias: decoderbufs
Category: ETL
Website: https://github.com/debezium/postgres-decoderbufs
License: MIT License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 0.1.0
PG Vers: 16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: postgres-decoderbufs_$v*
RPM Ver : 0.1.0
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-decoderbufs
DEB Ver : 0.1.0
DEB Deps: Nil

Details

7 - decoder_raw

Output plugin for logical replication in Raw SQL format

Overview

PIGSTY 3rd Party Extension: decoder_raw : Output plugin for logical replication in Raw SQL format

Information

ID: 9640
Name: decoder_raw
Alias: decoder_raw
Category: ETL
Website: https://github.com/michaelpq/pg_plugins/blob/main/decoder_raw/
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: decoder_raw_$v*
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-decoder-raw
DEB Ver : 1.0
DEB Deps: Nil

Details

8 - test_decoding

SQL-based test/example module for WAL logical decoding

Overview

CONTRIB Built-in Extension: test_decoding : SQL-based test/example module for WAL logical decoding

Information

ID: 9690
Name: test_decoding
Alias: test_decoding
Category: ETL
Website: https://www.postgresql.org/docs/current/test-decoding.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 16.3
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

9 - mimeo

Extension for specialized, per-table replication between PostgreSQL instances

Overview

PIGSTY 3rd Party Extension: mimeo : Extension for specialized, per-table replication between PostgreSQL instances

Information

ID: 9700
Name: mimeo
Alias: mimeo
Category: ETL
Website: https://github.com/omniti-labs/mimeo
License: PostgreSQL License
Language: Pure SQL
Tags: N/A
Comment:

Metadata

Version: 1.5.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: dblink

Packages

RPM Repo: PIGSTY
RPM Name: mimeo_$v
RPM Ver : 1.5.1
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-mimeo
DEB Ver : 1.5.1
DEB Deps: Nil

Details

10 - repmgr

Replication manager for PostgreSQL

Overview

PGDG 1st Party Extension: repmgr : Replication manager for PostgreSQL

Information

ID: 9710
Name: repmgr
Alias: repmgr
Category: ETL
Website: https://github.com/EnterpriseDB/repmgr
License: GPLv3 License
Language: Unknown
Tags: not-used
Comment: 无

Metadata

Version: 5.4
PG Vers: 16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: repmgr_$v*
RPM Ver : 5.4
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-repmgr
DEB Ver : 5.4
DEB Deps: Nil

Details

11 - pgcopydb

Copy a Postgres database to a target Postgres server

Overview

PGDG 3rd Party Extension: pgcopydb : Copy a Postgres database to a target Postgres server

Information

ID: 9800
Name: pgcopydb
Alias: pgcopydb
Category: ETL
Website: https://github.com/dimitri/pgcopydb
License: PostgreSQL License
Language: C
Tags: N/A
Comment:

Metadata

Version: 0.15
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pgcopydb
RPM Ver : 0.15
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: pgcopydb
DEB Ver : 0.15
DEB Deps: Nil

Details

12 - pgloader

Migrate to PostgreSQL in a single command!

Overview

PGDG 1st Party Extension: pgloader : Migrate to PostgreSQL in a single command!

Information

ID: 9810
Name: pgloader
Alias: pgloader
Category: ETL
Website: https://github.com/dimitri/pgloader
License: PostgreSQL License
Language: Lisp
Tags: N/A
Comment:

Metadata

Version: 3.6.10
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pgloader
RPM Ver : 3.6.10
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: pgloader
DEB Ver : 3.6.10
DEB Deps: Nil

Details

13 - pg_fact_loader

build fact tables with Postgres

Overview

PGDG 1st Party Extension: pg_fact_loader : build fact tables with Postgres

Information

ID: 9820
Name: pg_fact_loader
Alias: pg_fact_loader
Category: ETL
Website: https://github.com/enova/pg_fact_loader
License: MIT License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 2.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: fact_loader
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_fact_loader_$v*
RPM Ver : 2.0
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-pg-fact-loader
DEB Ver : 2.0
DEB Deps: Nil

Details

14 - pg_bulkload

pg_bulkload is a high speed data loading utility for PostgreSQL

Overview

PGDG 3rd Party Extension: pg_bulkload : pg_bulkload is a high speed data loading utility for PostgreSQL

Information

ID: 9830
Name: pg_bulkload
Alias: pg_bulkload
Category: ETL
Website: https://github.com/ossc-db/pg_bulkload
License: BSD 3 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 3.1.21
PG Vers: 16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_bulkload_$v*
RPM Ver : 3.1.21
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-bulkload
DEB Ver : 3.1.21
DEB Deps: Nil

Details

15 - pg_comparator

Comparation of testing and production services PostgreSQL databases.

Overview

PGDG 1st Party Extension: pg_comparator : Comparation of testing and production services PostgreSQL databases.

Information

ID: 9840
Name: pg_comparator
Alias: pg_comparator
Category: ETL
Website: https://www.postgresql.org/ftp/projects/pgFoundry/pg-comparator/pg_comparator/2.2.1/
License: BSD 3 License
Language: C
Tags: bin, archived
Comment: 无

Metadata

Version: 2.2.5
PG Vers: 16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_comparator_$v*
RPM Ver : 2.2.5
RPM Deps: Nil
DEB Repo: N/A
DEB Name: N/A
DEB Ver : N/A
DEB Deps: Nil

Details

16 - pgimportdoc

command line utility for importing XML, JSON, BYTEA document to PostgreSQL

Overview

PGDG 1st Party Extension: pgimportdoc : command line utility for importing XML, JSON, BYTEA document to PostgreSQL

Information

ID: 9850
Name: pgimportdoc
Alias: pgimportdoc
Category: ETL
Website: https://github.com/okbob/pgimportdoc
License: BSD 2 License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 0.1.4
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pgimportdoc_$v*
RPM Ver : 0.1.4
RPM Deps: Nil
DEB Repo: N/A
DEB Name: N/A
DEB Ver : N/A
DEB Deps: Nil

Details

17 - pgexportdoc

export XML, JSON and BYTEA documents from PostgreSQL

Overview

PGDG 1st Party Extension: pgexportdoc : export XML, JSON and BYTEA documents from PostgreSQL

Information

ID: 9860
Name: pgexportdoc
Alias: pgexportdoc
Category: ETL
Website: https://github.com/okbob/pgexportdoc
License: BSD 2 License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 0.1.4
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pgexportdoc_$v*
RPM Ver : 0.1.4
RPM Deps: Nil
DEB Repo: N/A
DEB Name: N/A
DEB Ver : N/A
DEB Deps: Nil