Re: pglogical vs. built-in logical replication in pg-10

Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> · Thu, 22 Jun 2017 12:43:02 +0300



    On 22/06/2017 11:21, Andreas Joseph
      Krogh wrote:

    
      Hi.
       
      1. Why should one prefer built-in logical replication in
        pg-10 to pglogical, does it do anything pglogical doesn't?
      It seems pglogical is more feature-rich...
      2. As I understand built-in logical replication in pg-10
        doesn't support large-objects, which we use a lot. Does
        pglogical replicate large objects? I cannot find any notes about
        large-objects under "Limitations and
Restrictions": https://www.2ndquadrant.com/en/resources/pglogical/pglogical-docs/
    
    You may do a simple test, create a table with a largeobject and try
    to read the logical stream, if it cannot represent the lo_import,
    lo_open, lowrite, lo_close (and I 'd bet they can't be encoded) then
    neither pglogical (being based on the same logical decoding
    technology) will support them. 

    
        --
          Andreas Joseph Krogh
          CTO / Partner - Visena AS
          Mobile: +47 909 56 963
          andreas@xxxxxxxxxx
          www.visena.com
          
        
    -- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt