Re: make installcheck failing for postgres_fdw

Natalie Wenz <nataliewenz(at)ebureau(dot)com> writes:
> I have a server that has 9.4.4 with the postgres_fdw module successfully running for the past couple of years. I am looking to update it, so I'm testing the procedure on a test server, and have been running into trouble. Out of curiosity, I tried installing it with 10beta4, but the gmake installcheck failed. So I tried with 9.6.2 (because it happened to be on the machine) and it still failed. I tried 9.6.5--and it also failed.

> Note that the installation doesn't seem to have any issue, just the installcheck. Is this a known issue? Is it just a matter of the regression tests lagging behind, or should I be concerned? The regression.diffs files are not identical between versions, but they only seem to contain query plans with differences.

If you're running with any non-default planner settings in your
installation, this would likely be unsurprising. I'd try "make check",
which is more self-contained, before concluding you have a problem.

regards, tom lane