unexpected PQresultStatus: 8 with simple logical replication

From: Brent Tubbs <brent(dot)tubbs(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Geoff Tolley <geoff(dot)tolley(at)yougov(dot)com>
Subject: unexpected PQresultStatus: 8 with simple logical replication
Date: 2015-01-10 00:22:13
Message-ID: CAAOBOv_H4WFkgPCa=-+SHDy635ShyvyEc+PEoRB8t7LTd=3GyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm trying to learn about how to subscribe to events in a logical
replication slot. I'm finding that the documentation is sparse and mostly
focused on binary WAL replication. I'd like to get a toy example working
where I can see changes in my terminal. I'm able to create a replication
slot, but trying to start it results in the error in the subject of my
email:

psql "dbname=postgres replication=database user=postgres" -c
"CREATE_REPLICATION_SLOT foobar LOGICAL test_decoding"
slot_name | consistent_point | snapshot_name | output_plugin
-----------+------------------+---------------+---------------
foobar | 0/D9C59A60 | 0000127E-1 | test_decoding
(1 row)

psql "dbname=postgres user=postgres" -c "SELECT slot_name, plugin,
restart_lsn FROM pg_replication_slots"

slot_name | plugin | restart_lsn
-----------+---------------+-------------
foobar | test_decoding | 0/D9C59A28
(1 row)

psql "dbname=postgres replication=database user=postgres" -c
"START_REPLICATION SLOT foobar LOGICAL 0/D9C59A28"
unexpected PQresultStatus: 8

Advice?
Many thanks,
Brent

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2015-01-10 01:52:45 Re: How to analyze a slowdown in 9.3.5?
Previous Message Michael Nolan 2015-01-09 22:14:11 How to analyze a slowdown in 9.3.5?