Re: unexpected PQresultStatus: 8 with simple logical replication

Поиск
Список
Период
Сортировка
От Brent Tubbs
Тема Re: unexpected PQresultStatus: 8 with simple logical replication
Дата
Msg-id CAAOBOv9j0qwWGe-U1-YQ+rqEcXD0LkiN1UFO52NcB3X-F+FANw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: unexpected PQresultStatus: 8 with simple logical replication  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: unexpected PQresultStatus: 8 with simple logical replication  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-general
That's working!  The blog posts I linked earlier made me think that I had to explicitly call START_REPLICATION, but I guess that's not necessary?

For anyone else following this thread, I found some better examples at http://pgci.eisentraut.org/jenkins/job/postgresql_master_world/Documentation/logicaldecoding-example.html.

On Sat, Jan 10, 2015 at 4:48 AM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Sat, Jan 10, 2015 at 9:22 AM, Brent Tubbs <brent.tubbs@gmail.com> wrote:
> psql "dbname=postgres replication=database user=postgres" -c
> "START_REPLICATION SLOT foobar LOGICAL 0/D9C59A28"
> unexpected PQresultStatus: 8
psql is not smart enough to understand that with a replication connection..

> Advice?
You should use pg_logical_slot_peek_changes or
pg_logical_slot_get_changes to grab changes from a replication slot
using psql. If you are looking at something at a lower level, have a
look at pg_recvlogical as an example of logical change receiver. It is
a good start point as well if your goal is to implement your own
receiver.

In any case, the documentation provides some examples:
http://www.postgresql.org/docs/current/static/logicaldecoding-example.html
--
Michael

В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: unexpected PQresultStatus: 8 with simple logical replication
Следующее
От: Andy Colson
Дата:
Сообщение: Re: How to analyze a slowdown in 9.3.5?