On 8/16/19 3:45 PM, Susan Hurst wrote:
We're using the 9.5.14 in the sandbox to extract data and objects from
the pgdump that was created in the 9.5.0 version. Hope I answered your
question correctly. If not, let me know and I'll try again.
As Rob pointed out I was wanting to know what pg_binary was used to grab
the schema and data from the 9.5.0 instance?
Our biggest concern is that there may be other silent issues that we
have not yet discovered. Thanks for the info you just provided, Adrian.
We'll read up on the path settings to see if we can find an answer there.
In a post upstream you had:
CREATE VIEW subscribers appears on line 11,968 in the dump file
CREATE FUNCTION subscribers_update() appears on line 2,466
CREATE TRIGGER subscribers_iur_trg appears on line 5,457,362
Is that direct from the pg_dump file?
In other words are the above not schema qualified in the file?
In the 9.5.14 instance when you do in psql:
\d subscribers
what do you get?
Sue
---
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan.hu...@brookhurstdata.com
Mobile: 314-486-3261
On 2019-08-16 17:29, Adrian Klaver wrote:
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.kla...@aklaver.com
