On 11/21/18 7:14 PM, Andres Freund wrote:
Could you check whether you still encounter the issue after applying the attached fix?
This has largely fixed the problem, so I think this should be applied. With some adjustments to the tests to remove problematic cases (e.g. postgres_fdw's ft_pg_type) the tests pass. The exception is HEAD->HEAD. The change is that the LOs are not dumped in the same order pre and post upgrade. I can change the tests to allow for a greater fuzz factor - generally when the source and target are the same we don't allow any fuzz. Or if we care we could do a better job of dumping LOs in a consistent order.
cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
