Replication of large object is not supported by PostgreSQL logical replication. pgEdge will be releasing an extension which will take care of this functionality.
What doesn't work in PostgreSQL?
As many of you are aware, PostgreSQL's known limitation is its support for large object (LO) replication. Currently, PostgreSQL's core logical replication does not support the replication of large objects.
pgEdge Differentiator and Our messaging to Customers/Prospects
Understanding the critical nature of this limitation for our Customers and pgEdge's capabilities, happy to announce the development of the extension LOLOR - Large Object Logical Replication. This extension is specifically designed to enable seamless replication of large objects through pgEdge's Spock replication technology. This extension helps with:
- Seamless LO Replication
- Compatibility and Ease of Use
- Enhanced Data Management
More technical info:
Large objects are accessed and manipulated in PostgreSQL using the following client interface functions :
- lo_create
- lo_import
- lo_import_with_oid
- lo_open
- lo_export
- lo_read
- lo_write
- lo_seek
- lo_seek64
Next Steps:
Development Timeline: We are currently in the development phase of the LOLOR project, it will be released in the second Quarter of 2024.