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
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? |