From: | Sebastien Diemer <sebastien(dot)diemer(at)polyconseil(dot)fr> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | pglogical most basic setup for logical replication |
Date: | 2016-01-26 10:14:29 |
Message-ID: | CAF89c4avADb-LA73pq8gK=XXAZt6Dw8ZAWkD+jbeVhR+hWSz7g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 with pglogical source code without any
success.
I created the provider and the subscriber nodes without problem but then,
after sending the sql query `SELECT
pglogical.create_subscription('subscription1', 'host=localhost port=55432
dbname=postgres');` I got:
"ERROR: pglogical_origin extension not found"
So I `CREATE EXTENSION pglogical_origin;` on the subscriber node (this step
is not mentioned in the README).
But then, I have the following error on the worker running on the
subscriber node:
"ERROR: subscriber subscription1 initialization failed during
nonrecoverable step (s), please try the setup again"
I tried to replay the setup again without any success.
What am I missing here ?
Thanks for your help
*Sébastien DIEMER*
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2016-01-26 10:22:55 | Re: pglogical most basic setup for logical replication |
Previous Message | Torsten Zuehlsdorff | 2016-01-26 10:00:25 | Re: Add generate_series(date,date) and generate_series(date,date,integer) |