MongoDB Foreign Data Wrapper

The MongoDB Foreign Data Wrapper (mongo_fdw ) is a Postgres extension that lets you access data that resides on a MongoDB database from EDB Postgres Advanced Server. It’s a writable foreign data wrapper that you can use with Postgres functions and utilities or with other data that resides on a Postgres host.

You can install the MongoDB Foreign Data Wrapper with an RPM package. You can download an installer from the EDB website .

• Release notes
  • Version 5.5.0
  • Version 5.4.0
  • Version 5.3.0
  • Version 5.2.9
  • Version 5.2.8
  • Version 5.2.6
  • Version 5.2.3
• Supported database versions
• Limitations
• Architecture overview
• Key features
  • Writable FDW
  • WHERE clause pushdown
  • Join pushdown
  • Aggregate pushdown
  • ORDER BY pushdown
  • LIMIT OFFSET pushdown
  • Connection pooling
  • Automated cleanup
  • Full-document retrieval
    • Example
• Installing
  • Red Hat Enterprise Linux (RHEL) and derivatives
  • SUSE Linux Enterprise (SLES) and derivatives
  • Debian and derivatives
  • Red Hat Enterprise Linux (RHEL)
  • SUSE Linux Enterprise (SLES)
    • Installing MongoDB Foreign Data Wrapper on Linux x86 (amd64)
    • Installing MongoDB Foreign Data Wrapper on IBM Power (ppc64le)
• Initial Configuration
  • CREATE EXTENSION
    • Parameters
    • Example
  • CREATE SERVER
    • Parameters
    • Example
  • CREATE USER MAPPING
    • Parameters
    • Example
  • CREATE FOREIGN TABLE
    • Parameters
    • Example
    • Data type mappings
  • DROP EXTENSION
    • Parameters
    • Example
  • DROP SERVER
    • Parameters
    • Example
  • DROP USER MAPPING
    • Parameters
    • Example
  • DROP FOREIGN TABLE
    • Parameters
    • Example
• Upgrading
  • On RHEL or Rocky Linux or AlmaLinux or OL 8
  • On SLES
  • On Debian or Ubuntu
  • On RHEL or CentOS 7 on PPCLE
• Uninstalling
• End-to-end
• Join pushdown
• Aggregate function pushdown
• LIMIT OFFSET pushdown
• ORDER BY pushdown
• WHERE clause pushdown
• Identifying the version