Re: [HACKERS] pglogical most basic setup for logical replication

2016-01-26 Thread Craig Ringer
On 26 January 2016 at 19:18, Sebastien Diemer < sebastien.die...@polyconseil.fr> wrote: > It sounds like you must be running on PostgreSQL 9.4. > > Indeed I am on PostgreSQL 9.4, I omitted this important point. > > I'll update the docs to mention the extra step on 9.4. > You'll need to drop the

Re: [HACKERS] pglogical most basic setup for logical replication

2016-01-26 Thread Sebastien Diemer
> > It sounds like you must be running on PostgreSQL 9.4. Indeed I am on PostgreSQL 9.4, I omitted this important point. You'll need to drop the subscriber database and re-create it. Use a new > node name. Seems to work but I still do not really understand what was wrong in the first place thoug

Re: [HACKERS] pglogical most basic setup for logical replication

2016-01-26 Thread Craig Ringer
On 26 January 2016 at 18:14, Sebastien Diemer < sebastien.die...@polyconseil.fr> wrote: > Hello, > > I did not manage to make the simplest logical replication scheme work with > pglogical. > My setup is the following: two postgresql nodes (one provider and one > subscriber) with one database and o

[HACKERS] pglogical most basic setup for logical replication

2016-01-26 Thread Sebastien Diemer
Hello, I did not manage to make the simplest logical replication scheme work with pglogical. My setup is the following: two postgresql nodes (one provider and one subscriber) with one database and one simple table: `CREATE TABLE t (c1 integer, PRIMARY KEY (c1));` I followed the README provided wi