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