Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Actually the megatest is:
> pg_dump regress > out
> dropdb regression
> createdb regression
> psql regression < out
> pg_dump regress > out2
> diff out out2
> That is the pg_dump test, and someone usually does it as part of
> regression testing before each release.
> It would be nice to add this to test/regress/Makefile maybe.
That's a good thought --- it eliminates both the platform-specific
issues and the problem of adding a bulky reference file to the
distribution.
I'd suggest, though, that the test *not* clobber the regression DB.
Instead
pg_dump regression >outcreatedb regression2psql regression2 <outpg_dump regression >out2dropdb regression2 --
maybediffout out2
This leaves you a better chance of investigating the diff if you
get one.
regards, tom lane