Re: [GENERAL] BDR DML Only

2014-09-16 Thread Andres Freund
On 2014-09-16 20:03:21 +0200, p...@mailme.dk wrote: > With DDL disabled then create extension posgis gives a loop on the "slave" > > LOG: starting background worker process "bdr > (6059699842869179629,1,16384,): beta: apply" > ERROR: relation "public.spatial_ref_sys" does not exist > LOG: worke

Re: [GENERAL] BDR DML Only

2014-09-16 Thread p...@mailme.dk
> Hi, > > On 2014-09-16 19:32:38 +0200, p...@mailme.dk wrote: >> I am not sure I have a very good case other than the very lousy argument >> that I would trust it to be stable much more quickly :-) > > Well, we'll get the much more quickly if people report problems ;) > >> I tried it and it works f

Re: [GENERAL] BDR DML Only

2014-09-16 Thread Andres Freund
Hi, On 2014-09-16 19:32:38 +0200, p...@mailme.dk wrote: > I am not sure I have a very good case other than the very lousy argument > that I would trust it to be stable much more quickly :-) Well, we'll get the much more quickly if people report problems ;) > I tried it and it works fine for the

Re: [GENERAL] BDR DML Only

2014-09-16 Thread p...@mailme.dk
> On 2014-09-15 19:54:42 +0200, p...@mailme.dk wrote: >> Is it already possible or would you consider a configuration option that >> would only replicate DML but not DDL ? >> >> This should of course be combined with a predictable way of manually >> handling DDL errors. Like simply manually adding

Re: [GENERAL] BDR DML Only

2014-09-16 Thread Andres Freund
On 2014-09-15 19:54:42 +0200, p...@mailme.dk wrote: > Is it already possible or would you consider a configuration option that > would only replicate DML but not DDL ? > > This should of course be combined with a predictable way of manually > handling DDL errors. Like simply manually adding any mi

Re: [GENERAL] BDR DML Only

2014-09-15 Thread Christoph Moench-Tegeder
## p...@mailme.dk (p...@mailme.dk): > Is it already possible or would you consider a configuration option that > would only replicate DML but not DDL ? bdr.skip_ddl_replication = true can even be set at transaction level Regards, Christoph -- Spare Space -- Sent via pgsql-general mailing li

[GENERAL] BDR DML Only

2014-09-15 Thread p...@mailme.dk
Is it already possible or would you consider a configuration option that would only replicate DML but not DDL ? This should of course be combined with a predictable way of manually handling DDL errors. Like simply manually adding any missing DDL on the "slave". Thanks Poul -- Sent via pgsql-