Re: Missing Trigger after pgdump install

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