Re: pglogical most basic setup for logical replication
| От | Craig Ringer |
|---|---|
| Тема | Re: pglogical most basic setup for logical replication |
| Дата | |
| Msg-id | CAMsr+YHdj=GM7j8C137t8o2NoCns51_fGN6TNV2XoPr0cAaz7w@mail.gmail.com обсуждение исходный текст |
| Ответ на | pglogical most basic setup for logical replication (Sebastien Diemer <sebastien.diemer@polyconseil.fr>) |
| Ответы |
Re: pglogical most basic setup for logical replication
|
| Список | pgsql-hackers |
On 26 January 2016 at 18:14, Sebastien Diemer <sebastien.diemer@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 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"
It sounds like you must be running on PostgreSQL 9.4.
9.5 was the primary target for pglogical. Replicating from 9.4 to 9.4 was added quite late in the process. It seems we left out some key information from the documentation there.
"ERROR: subscriber subscription1 initialization failed during nonrecoverable step (s), please try the setup again"I tried to replay the setup again without any success.
You'll need to drop the subscriber database and re-create it. Use a new node name.
В списке pgsql-hackers по дате отправления: