On 8/16/19 3:18 PM, Susan Hurst wrote:
> Production version:
> PostgreSQL 9.5.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7
> 20120313 (Red Hat 4.4.7-16), 64-bit
>
> Sandbox version:
> "PostgreSQL 9.5.14, compiled by Visual C++ build 1800, 64-bit"
>
I going to say it has something to do with this:
https://www.postgresql.org/docs/9.5/release-9-5-12.html
"Avoid use of insecure search_path settings in pg_dump and other client
programs (Noah Misch, Tom Lane)"
Are you using the 9.5.0 or 9.5.14 version of pg_dump to dump from the
production server?
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com