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(dot)hurst(at)brookhurstdata(dot)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(dot)klaver(at)aklaver(dot)com