Re: [GENERAL] Trying to setup pglogical with no success

2016-04-13 Thread John R Pierce
On 4/13/2016 5:30 PM, Adrian Klaver wrote: "pg_hba.conf has to allow replication connections from localhost, by a user with replication privilege." Not sure if: host replication postgres 10.241.0.10/32 trust host replication postgres 10.241.0.12/32 trust I would add lines with 127.0.0.1/32

Re: [GENERAL] Trying to setup pglogical with no success

2016-04-13 Thread Adrian Klaver
On 04/13/2016 03:16 PM, cchee-ob wrote: > Here's what I have done to try to set up pglogical. What am I doing wrong? Not sure. Did you do this?: http://2ndquadrant.com/en/resources/pglogical/pglogical-docs/ "The pglogical_output extension needs to be installed on both provider and subscriber.

[GENERAL] Trying to setup pglogical with no success

2016-04-13 Thread cchee-ob
Here's what I have done to try to set up pglogical. What am I doing wrong? 2 nodes provider - 10.241.0.10 subscriber - 10.241.0.12 svp2=# select version(); version -