| From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | Steve Singer <steve(at)ssinger(dot)info>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: "snapshot too large" error when initializing logical replication (9.4) |
| Date: | 2014-11-17 14:52:38 |
| Message-ID: | 20141117145238.GD27042@awork2.anarazel.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2014-11-17 11:51:54 -0300, Alvaro Herrera wrote:
> Andres Freund wrote:
> > Hi,
> >
> > On 2014-10-25 18:09:36 -0400, Steve Singer wrote:
> > > I sometimes get the error "snapshot too large" from my logical replication
> > > walsender process when in response to a CREATE_REPLICATION_SLOT.
> >
> > Yes. That's possible if 'too much' was going on until a consistent point
> > was reached. I think we can just use a much larger size for the array
> > if necessary.
> >
> > I've attached patch for this. Could you try whether that helps? I don't
> > have a testcase handy that reproduces the problem.
>
> You haven't pushed this, have you?
No, but it's on my todo list.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2014-11-17 15:21:04 | Re: Wait free LW_SHARED acquisition - v0.2 |
| Previous Message | Alvaro Herrera | 2014-11-17 14:51:54 | Re: "snapshot too large" error when initializing logical replication (9.4) |