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

On 22/06/2017 20:30, Andres Freund wrote: On 2017-06-22 18:10:40 +0300, Achilleas Mantzios wrote: Once again having pg_largeobject as a system-catalog prevents LOs from working smoothly. Neither replication nor having LOs on a different tablespace (by moving pg_largeobject) works. I think

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

På torsdag 22. juni 2017 kl. 17:10:40, skrev Achilleas Mantzios < ach...@matrix.gatewaynet.com >: [snip] What's so better in LO's VS bytea? You do a lot updates on the binary data, changing only parts of it?   BYTEA really sucks when dealing with large objects

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

På torsdag 22. juni 2017 kl. 19:30:49, skrev Andres Freund >: On 2017-06-22 18:10:40 +0300, Achilleas Mantzios wrote: > > Once again having pg_largeobject as a system-catalog prevents LOs > > from working smoothly. Neither replication nor having

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

On 2017-06-22 18:10:40 +0300, Achilleas Mantzios wrote: > > Once again having pg_largeobject as a system-catalog prevents LOs > > from working smoothly. Neither replication nor having LOs on a > > different tablespace (by moving pg_largeobject) works. > I think logical decoding was designed for

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

On 2017-06-22 12:43:02 +0300, Achilleas Mantzios wrote: > 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

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

On 6/22/17 04:21, Andreas Joseph Krogh wrote: > 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... You are right that pglogical has more functionality. Much of that functionality can

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

On 22/06/2017 17:46, Andreas Joseph Krogh wrote: På torsdag 22. juni 2017 kl. 15:25:20, skrev Achilleas Mantzios >: On 22/06/2017 13:38, Andreas Joseph Krogh wrote: På torsdag 22. juni 2017 kl. 11:43:02, skrev

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

På torsdag 22. juni 2017 kl. 15:25:20, skrev Achilleas Mantzios < ach...@matrix.gatewaynet.com >: On 22/06/2017 13:38, Andreas Joseph Krogh wrote: På torsdag 22. juni 2017 kl. 11:43:02, skrev Achilleas Mantzios < ach...@matrix.gatewaynet.com

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

On 22/06/2017 13:38, Andreas Joseph Krogh wrote: På torsdag 22. juni 2017 kl. 11:43:02, skrev Achilleas Mantzios >: On 22/06/2017 11:21, Andreas Joseph Krogh wrote: Hi. 1. Why should one prefer built-in logical

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

På torsdag 22. juni 2017 kl. 11:43:02, skrev Achilleas Mantzios < ach...@matrix.gatewaynet.com >: 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

Re: [GENERAL] 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