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.hurst@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.klaver@aklaver.com