Hi all, with a huge delay, I've seen this question [1]. . and it seems like the hstore.so was somewhat intimately integrated into OP's database so the '/usr/bin/pg_dump --schema-only --binary-upgrade --format=custom' called through 'pg_upgrade' failed with: pg_dump: [archiver (db)] query failed: ERROR: could not access file "$libdir/hstore": No such file or directory Which means that the dump from old datadir, with old server (without hstore.so packaged) failed. But playing with hstore.so a bit, the upgrade always worked smoothly for me even without the "old" hstore.so Googling around, I only found that there were some incompatible changes historically in hstore.so causing pg_upgrade failure; but this is different issue -- in the issue I talk about now the module was not found at all, even though it is usually even not searched for. So the question is what circumstances could cause this issue in particular? Is it expected in general that, to make the pg_upgrade run smooth, all the "loaded" server modules are built against and available for the --old-bindir server? Don't we have some reproducer for this kind of issues? [1] https://ask.fedoraproject.org/en/question/69316/postgresql-doesnt-work-after-upgrade-to-f22/ [2] https://bugzilla.redhat.com/show_bug.cgi?id=1557490 Thank for hints, Pavel
