Re: [GENERAL] pglogical bidirectional replication of sequences

On 2017-09-01 10:29:51 +0200, Peter J. Holzer wrote: > pglogical supports replication of sequences, and although the way it > does this suggests that it can't really work in both directions > (actually I'm sceptical that it works reliably in one direction), of > course I had to try it. > > So I

Re: [GENERAL] pglogical bidirectional replication of sequences

On 2017-09-01 09:57:52 -0600, Rob Sargent wrote: > On 09/01/2017 02:29 AM, Peter J. Holzer wrote: > >TLDR: Don't. > > > >I'm currently conducting tests which should eventually lead to a 2 node > >cluster with working bidirectional logical replication. > > > >(Postgresql 9.6.4-1.pgdg90+1, pglogical

Re: [GENERAL] pglogical bidirectional replication of sequences

On 09/01/2017 02:29 AM, Peter J. Holzer wrote: TLDR: Don't. I'm currently conducting tests which should eventually lead to a 2 node cluster with working bidirectional logical replication. (Postgresql 9.6.4-1.pgdg90+1, pglogical 2.0.1-1.jessie+1 on Debian 9 (Stretch)) pglogical supports

Re: [GENERAL] pglogical sync

I see says the blind man Looked in the code and correct the syntax and ran on subscriber all good > On Aug 10, 2017, at 12:29 PM, armand pirvu wrote: > > Hi folks > > A question about pglogical sync > > I have a setup with a schema named myschema. > All works well

Re: [GENERAL] pglogical repo

Updated since last time I installed it Okay Will go move from 1.0.2 to 1.0.3 to stay up to date Thks > On Aug 10, 2017, at 1:21 PM, John R Pierce wrote: > > On 8/10/2017 10:30 AM, armand pirvu wrote: >> Looking at the installatoion steps and the yum repositories >>

Re: [GENERAL] pglogical repo

On 8/10/2017 10:30 AM, armand pirvu wrote: Looking at the installatoion steps and the yum repositories sudo yum installhttp://packages.2ndquadrant.com/pglogical/yum-repo-rpms/pglogical-rhel-1.0-2.noarch.rpm [ ] pglogical-rhel-1.0-1.noarch.rpm [ ] pglogical-rhel-1.0-2.noarch.rpm [ ]

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

Re: [GENERAL] pglogical cross subscribe

On 8/3/2016 8:27 PM, Andy Colson wrote: Hi all. I have a localdb and a remotedb. A) I'd like to send table1 and table2 from localdb to remotedb. B) I'd like to send table3 from remotedb to localdb. I have PG9.5 and pglogical setup, and (A) works fine. Well, worked. I then tried to set up

Re: [GENERAL] pglogical cascading replication (chaining replication)

The solution was found thanks to Petr Jelinek from 2ndQ. > Cascading wasn't much of a priority so far. > Currently you have to create the origin manually using > pg_replication_origin_create(). > I plan to make this work seamlessly in the future release. So whats needed to be done is: on p2:

Re: [GENERAL] pglogical cascading replication (chaining replication)

The solution was found thanks to Petr Jelinek from 2ndQ. > Cascading wasn't much of a priority so far. > Currently you have to create the origin manually using > pg_replication_origin_create(). > I plan to make this work seamlessly in the future release. So whats needed to be done is: on p1:

Re: [GENERAL] pglogical cascading replication (chaining replication)

oshua D. Drake" <j...@commandprompt.com> To: "Nick Babadzhanian" <n...@cobra.ru>, "pgsql-general" <pgsql-general@postgresql.org> Sent: Wednesday, July 13, 2016 7:16:30 PM Subject: Re: [GENERAL] pglogical cascading replication (chaining replication) On 0

Re: [GENERAL] pglogical cascading replication (chaining replication)

On 07/12/2016 07:20 AM, Nick Babadzhanian wrote: I apologize if this is wrong place to ask the question. A quote from pglogical FAQ: Q. Does pglogical support cascaded replication? Subscribers can be configured as publishers as well thus cascaded replication can be achieved by

Re: [GENERAL] pglogical cascading replication (chaining replication)

After checking logs I noticed this error on p3-node: >ERROR: cache lookup failed for replication origin >'pgl_test_node_p1_provider_sub_p1_t06410f8' pgl_test_node_p1_provider_sub_p1_t06410f8 is origin for p1-node. Here are the logs from all three server (this happens every time I insert

Re: [GENERAL] pglogical

On 25 May 2016 at 18:26, Igor Neyman wrote: > This page: > > http://2ndquadrant.com/en/resources/pglogical/ > > states that “It has also been submitted to PostgreSQL core as a candidate > for inclusion in PostgreSQL 9.6.” > > > > So, my question is: did pglogical make the

Re: [GENERAL] pglogical

On Wed, May 25, 2016 at 1:26 PM, Igor Neyman wrote: > This page: > > http://2ndquadrant.com/en/resources/pglogical/ > > states that “It has also been submitted to PostgreSQL core as a candidate > for inclusion in PostgreSQL 9.6.” > > > > So, my question is: did pglogical

Re: [GENERAL] pglogical two way replication problem

Hi, Does anybody use pglogical (http://2ndquadrant.com/en/resources/pglogical/) in production or in lab? Is there any community around this project? Where can I register issue and contribute? -- Best Regards, Alexey Larin On Mon, 2016-03-21 at 11:31 +0300, alexey.i.la...@gmail.com wrote: