| From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
|---|---|
| To: | Brent Tubbs <brent(dot)tubbs(at)gmail(dot)com> |
| Cc: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>, Geoff Tolley <geoff(dot)tolley(at)yougov(dot)com> |
| Subject: | Re: unexpected PQresultStatus: 8 with simple logical replication |
| Date: | 2015-01-10 20:39:22 |
| Message-ID: | 20150110203922.GN12509@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2015-01-10 10:24:56 -0800, Brent Tubbs wrote:
> That's working! The blog posts I linked earlier
Which blogpost is that? At least this thread doesn't seem to contain a
reference.
> made me think that I had to explicitly call START_REPLICATION, but I
> guess that's not necessary?
START_REPLICATION over a replication connection is the streaming variant
of logical decoding. Unfortunately psql can't deal with that (and it
doesn't make sense to support it, as you need to send back feedback
messages and such). The SQL function Michael linked to are there for
easier accessibility, but don't support streaming. Other than that,
they're the same.
Hope that clears up things a bit?
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Nolan | 2015-01-10 21:00:01 | Re: How to analyze a slowdown in 9.3.5? |
| Previous Message | Andy Colson | 2015-01-10 18:55:09 | Re: How to analyze a slowdown in 9.3.5? |