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 cr

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 repli

[GENERAL] pglogical bidirectional replication of sequences

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 replication of sequences, and although the way it does t

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 but looking at sync > > p

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 >> >> sudo yum >> instal

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 [ ] pglog

[GENERAL] pglogical repo

Hi folks Looking at the installatoion steps and the yum repositories sudo yum install http://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 [ ] pglogical-rhel-1.0-3.noarch.rpm

[GENERAL] pglogical sync

Hi folks A question about pglogical sync I have a setup with a schema named myschema. All works well but looking at sync pglogical.alter_subscription_resynchronize_table(subscription_name name, relation regclass) Resynchronize one existing table. WARNING: This function will truncate the table

[GENERAL] pglogical trouble on BDR cluster

Hi. I currently have a two-server BDR replication setup. Apart from the two master nodes, I have another two servers which I want to have read only replication for some tables only. I first had to deal with some trouble regarding CREATE EXTENSION being replicated by BDR, and that causing the sc

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 logic

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 mailto:and...@anarazel.de>>: 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 t

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 su

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 be

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 mailto: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 mailto:ach...@matrix

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 mailto: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,

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 d

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 large-objec

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

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

[GENERAL] pglogical and slony

Thanks to Adrian I got pointed in the direction of enabling triggers to use with pglogical In other words, whatever comes down the pglogical in terms of inserts/updates/deletes, I can track those in some audit table or do something else That got me thinking why not putting at the end of pglogi

[GENERAL] pglogical Replication CONFLICT

I am using PostgreSQL 9.4 with pglogical replication. I have 1 provider node and 1 subscriber in 2 separate locations. The subscriber subscribes to 1 database on the provider. Every evening a function runs that DELETE's & INSERT's to tables that are replicated to the subscriber and causes CONFLI

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 (B)

[GENERAL] pglogical cross subscribe

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 (B) which seems to work, but now (A) is bro

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" To: "Nick Babadzhanian" , "pgsql-general" Sent: Wednesday, July 13, 2016 7:16:30 PM Subject: 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 a

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 forwarding/chai

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 somet

[GENERAL] pglogical cascading replication (chaining replication)

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 forwarding/chaining (again no failover though). The only m

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 9.6 core, or not? > pgl

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 make the 9.6 core, or not

[GENERAL] pglogical

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 9.6 core, or not? The reason I'm asking is that pglogical is available (for 9.4 and 9.5)

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:

[GENERAL] pglogical two way replication problem

Hi All, Try to configure pglogical in such way: srv1, srv2: CentOS 6.7, PostgreSQL 9.5.1, pglogical 1.0.1 On both servers created database "xdray", schema is common and consists tables t1 and t2. The srv1 writes to the t1. The t1 added to replication set repset_t1 on the srv1. The srv2 writes t