On Sat, Jan 10, 2015 at 9:22 AM, Brent Tubbs <brent.tu...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
