pgEdge
GitHubGitHub (opens in a new tab)
  • Introduction to pgEdge
  • pgEdge Cloud
    • Getting Started: Choosing a Cloud Edition
      • Getting Started with pgEdge Enterprise Edition
      • Getting Started with pgEdge Developer Edition
      • Linking your Cloud Account
        • Linking an AWS Account
        • Linking an Azure Account
        • Linking a Google Account
      • Adding an SSH Key
    • Cluster Management
      • Creating a Cluster
      • Managing a Cluster
      • Defining a Cluster's Backup Store
      • Managing Firewall Rules
    • Database Management
      • Creating a Database
      • Managing a Database
    • Modifying a Database or a Cluster
      • Using the Actions Menu
      • Adding a Database or Cluster Node
      • Dropping a Database, Node, or Cluster
      • Modifying a Database, Node, or Cluster
    • Database Administration
      • Creating and Managing Tables
      • Using Integrations
      • Reviewing Database Metrics
      • Viewing Log Files
      • Reviewing Backup Details
      • Using PostgreSQL Extensions
    • Connecting to a Database
      • Connecting with ssh
      • Connecting with psql
      • Connecting with pgAdmin
      • Connecting a Custom Client to Developer Edition
      • Connecting over HTTPS
      • Best Practices for Managing Connections
      • Backing up your Database
      • Managing Database Backups on the Cloud
      • Restoring from Backup
    • Reviewing Console Tasks
    • Migrating to pgEdge Cloud
      • Taking a Backup
      • Restoring from Backup
    • Settings
    • Team Resources
    • Troubleshooting
    • Cloud Release Notes
  • pgEdge Platform
    • Prerequisites: Preparing your System for pgEdge
      • Supported Operating Systems
      • pgEdge Architecture Models
      • Planning for Active-Active Replication
    • Installing the pgEdge Platform
      • Tutorial - Deploying with a Configuration File
      • Tutorial - Manually Deploying a Cluster
      • Upgrading your CLI Installation
      • Creating, Managing, and Deploying a Cluster Configuration File
      • Creating and Upgrading an Offline Repository
      • Adding a Node to Your Cluster
      • Using Spock to Synchronize a New Node
      • Removing a Node from Your Cluster
      • Setting Parameter Values
      • Using Automatic DDL Replication
      • Managing Replication Exceptions
      • Managing Supported Extensions
      • Configuring Backups with pgBackrest
      • Creating Custom Filters
      • Reviewing Log Files and Cluster Information
    • ACE (the Active Consistency Engine)
      • Managing Data Consistency with ACE
      • Enhancing ACE Performance with Merkle Trees
      • Installing ACE
      • Using ACE Functions
      • ACE API Endpoints
      • Scheduling ACE Operations and Repairs
    • Using Snowflake Sequences
    • Managing Large Objects for Logical Replication
    • PGEDGE CLI Reference
      • ACE Commands
      • DB Commands
      • CLUSTER Commands
      • LOCALHOST Commands
      • SERVICE Commands
      • SETUP Command
      • SPOCK Commands
      • UPDATE Manager
    • Troubleshooting Replication
      • Troubleshooting
      • Finding Cluster Information
      • pgEdge Log Files
    • pgEdge Release Notes
  • The Spock Extension
    • Installing and Configuring Spock
    • Upgrading a Spock Installation
    • Spock's Conflict Avoidance Options
    • Spock's Management Features
      • Replicating Partitioned Tables
      • Using Batch Inserts
      • Filtering Data
      • Using Spock in Read-Only Mode
      • Using a Trigger to Manage Replication Set Membership
      • Using Snowflake Sequences
      • Using Lolor to Manage Large Objects
      • Using Automatic DDL Replication
    • Adding a Node to a Cluster
      • Adding a Node with Zero Downtime
      • Adding a Node with Minimal Downtime with pgBackRest
      • Managing your Cluster with Spockctrl
        • Populating the spockctrl.json File
        • Using spockctrl Functions
        • Using a Workflow File to Modify a Cluster
      • Creating an Empty Subscriber Node with pg_basebackup
    • Monitoring your Cluster
      • Finding Cluster Information
      • Using Lag Tracking to Evaluate your Cluster
      • Using a Sync Event to Monitor Node Content
    • Using Spock Functions
      • Node Mgmt Functions
      • Replication Set Mgmt Functions
      • Subscription Mgmt Functions
      • Cluster Mgmt Functions
    • Spock Release Notes
    • Limitations

On This Page

  • Using LOLOR to Manage Large objects
The Spock Extension
Spock's Management Features
Using Lolor to Manage Large Objects

Using LOLOR to Manage Large objects

PostgreSQL's logical decoding facility does not support decoding changes to large objects (opens in a new tab); we recommend instead using the LOLOR extension (opens in a new tab) to manage large objects.

If you're using pgEdge Platform, you'll also find more information about using LOLOR with your distributed cluster here.

Using Snowflake SequencesUsing Automatic DDL Replication
2025 ©pgEdge, Inc.