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