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
      • Using Spock to Synchronize a New Node
      • Adding a Node to Your Cluster
      • 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
      • Guc Values
      • 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
      • Managing a Spock Installation
      • 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
      • Using Spock to Add a Node to a Cluster
      • Adding a Node with Zero Downtime
      • Adding a Node with Minimal Downtime with pgBackRest
        • Populating the spockctrl.json File
        • Using spockctrl Functions
        • Using a Workflow File to Modify a Cluster
        • Index
      • Creating an Empty Subscriber Node with pg_basebackup
      • Monitoring the Configuration and Health of Your Cluster
      • Finding Cluster Information
      • Using Lag Tracking to Evaluate your Cluster
      • Using a Sync Event to Monitor Node Content
      • Spock Functions
        • Spock Health Check
        • Spock Metrics Check
        • Spock Node Add Interface
        • Spock Node Alter Location
        • Spock Node Create
        • Spock Node Drop
        • Spock Node Drop Interface
        • Spock Node List
        • Spock Replicate Ddl
        • Spock Repset Add All Seqs
        • Spock Repset Add All Tables
        • Spock Repset Add Partition
        • Spock Repset Add Seq
        • Spock Repset Add Table
        • Spock Repset Alter
        • Spock Repset Create
        • Spock Repset Drop
        • Spock Repset List Tables
        • Spock Repset Remove Partition
        • Spock Repset Remove Seq
        • Spock Repset Remove Table
        • Spock Seq Sync
        • Spock Sequence Convert
        • Spock Set Readonly
        • Spock Sub Add Repset
        • Spock Sub Alter Interface
        • Spock Sub Create
        • Spock Sub Disable
        • Spock Sub Drop
        • Spock Sub Enable
        • Spock Sub Remove Repset
        • Spock Sub Resync Table
        • Spock Sub Show Status
        • Spock Sub Show Table
        • Spock Sub Sync
        • Spock Sub Wait for Sync
        • Spock Table Wait for Sync
      • 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.