Re: pg_dump -j against standbys - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: pg_dump -j against standbys
Date
Msg-id CAB7nPqTJuGGK5jcH4FtrzoqAZRyjtzA1+r_rCeWZdEwnEDjbbw@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump -j against standbys  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
On Tue, May 24, 2016 at 7:02 AM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
> On 5/24/16 6:27 AM, Magnus Hagander wrote:
>>
>> pg_dump: Synchronized snapshots are not supported on standby servers.
>
>
> Would it be that much harder to support this use case, perhaps by having the
> replica request the snapshot from the master on the client's behalf? It
> certainly doesn't surprise me that people would want to parallel dump from a
> replica...

For HEAD, I totally agree. However, it seems to me that what Magnus is
looking for here is a backpatch that would allow users to get more
useful information related to the error that's happening: pg_dump
provides now an error that does not help at all in diagnosing what the
problem is. And that is confusing.
-- 
Michael



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: LSN as a recovery target
Next
From: Tom Lane
Date:
Subject: Re: [PATCH][Documination] Add optional USING keyword before opclass name in INSERT statemet