On 10/02/2016 01:53 PM, Tom Lane wrote:
>> So then why are the pre-upgrade and post-upgrade dumps different?
> Because pg_dump with --binary-upgrade neglects to emit
>
> ALTER EXTENSION bloom ADD ACCESS METHOD bloom;
That's what I suspected.
>
> which it would need to do in order to make this work right. The other
> small problem is that there is no such ALTER EXTENSION syntax in the
> backend. This is a rather major oversight in the patch that added DDL
> support for access methods, if you ask me.
I agree.
cheers
andrew