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

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(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
> www.visena.com <https://www.visena.com>
> <https://www.visena.com>

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt