Re: [GENERAL] FDW and BDR

2015-09-02 Thread Craig Ringer
On 2 September 2015 at 20:40, Andres Freund wrote: > On 2015-09-02 20:27:40 +0800, Craig Ringer wrote: >> The reason for this is that BDR replicates at a database level, but >> CREATE SERVER and CREATE USER MAPPING are global, affecting all >> databases on a PostgreSQL install. BDR can't therefore

Re: [GENERAL] FDW and BDR

2015-09-02 Thread Alvaro Herrera
Andres Freund wrote: > On 2015-09-02 20:27:40 +0800, Craig Ringer wrote: > > The reason for this is that BDR replicates at a database level, but > > CREATE SERVER and CREATE USER MAPPING are global, affecting all > > databases on a PostgreSQL install. BDR can't therefore guarantee to > > replicate

Re: [GENERAL] FDW and BDR

2015-09-02 Thread Willy-Bas Loos
Haha, that is funny :) It's always nice to see problems evaporate. Thank's a lot for your answers. On Wed, Sep 2, 2015 at 2:40 PM, Andres Freund wrote: > Either way it should be > simple to implement. > > -- Willy-Bas Loos

Re: [GENERAL] FDW and BDR

2015-09-02 Thread Andres Freund
On 2015-09-02 20:27:40 +0800, Craig Ringer wrote: > The reason for this is that BDR replicates at a database level, but > CREATE SERVER and CREATE USER MAPPING are global, affecting all > databases on a PostgreSQL install. BDR can't therefore guarantee to > replicate CREATE SERVER to other nodes, s

Re: [GENERAL] FDW and BDR

2015-09-02 Thread Tom Lane
Craig Ringer writes: > On 2 September 2015 at 18:46, Willy-Bas Loos wrote: >> I've read that CREATE FOREIGN DATA WRAPPER currently is prohibited on BDR >> enabled databases. And other FDW and FTS related commands too. > Correct. > The reason for this is that BDR replicates at a database level,

Re: [GENERAL] FDW and BDR

2015-09-02 Thread Craig Ringer
On 2 September 2015 at 18:46, Willy-Bas Loos wrote: > Sorry, forgot [GENERAL] in the subject at first. You don't need to add it. The list manager software does that. > I've read that CREATE FOREIGN DATA WRAPPER currently is prohibited on BDR > enabled databases. And other FDW and FTS related com

Re: [GENERAL] FDW and BDR

2015-09-02 Thread Willy-Bas Loos
Sorry, forgot [GENERAL] in the subject at first. On Wed, Sep 2, 2015 at 12:46 PM, Willy-Bas Loos wrote: > Hi, > > I've read that CREATE FOREIGN DATA WRAPPER currently is prohibited on BDR > enabled databases. And other FDW and FTS related commands too. > > This seems obvious, but i want to make

[GENERAL] FDW and BDR

2015-09-02 Thread Willy-Bas Loos
Hi, I've read that CREATE FOREIGN DATA WRAPPER currently is prohibited on BDR enabled databases. And other FDW and FTS related commands too. This seems obvious, but i want to make sure: Does that mean that FDW's are not supported at all in databases that use Bi-Directional Replication? (maybe one