Re: pg_upgrade: when the --old-bindir requires "additional" $libdir/plugins? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: pg_upgrade: when the --old-bindir requires "additional" $libdir/plugins?
Date
Msg-id baeb43b9-87d4-3ad6-7486-7d25bd731167@aklaver.com
Whole thread Raw
In response to Re: pg_upgrade: when the --old-bindir requires "additional" $libdir/ plugins?  (Pavel Raiskup <praiskup@redhat.com>)
List pgsql-general
On 04/18/2018 08:04 AM, Pavel Raiskup wrote:
> On Wednesday, April 18, 2018 4:43:01 PM CEST Adrian Klaver wrote:

>> I am obviously missing something. If the old server was using hstore in
>> a database how could hstore.so could be accessible to it but not pg_dump?
> 
> Because on Fedora we usually run pg_upgrade after distribution upgrade
> (e.g. for Fedora 27 => Fedora 28 upgrade it means also upgrade from PostgreSQL
> 9.6 to 10), and then we provide the old server in different package
> (postgresql-upgrade) which has limited feature set (including the missing
> hstore.so module).

Thanks, now it makes sense.

> 
> Pavel
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Pavel Raiskup
Date:
Subject: Re: pg_upgrade: when the --old-bindir requires "additional" $libdir/ plugins?
Next
From: Vitaliy Garnashevich
Date:
Subject: Re: Tricking the optimizer