Missing Trigger after pgdump install

From: Susan Hurst <susan(dot)hurst(at)brookhurstdata(dot)com>
To: Discuss List Postgres <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Missing Trigger after pgdump install
Date: 2019-08-16 18:27:53
Message-ID: 53f9ff4448f5210802b5a04c8fa83186@mail.brookhurstdata.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What scenarios can cause a single trigger to be omitted when populating
an empty database from a pgdump file?

We have nightly backups of our production database that we load into a
fresh, empty database in our sandbox using the pgdump file.

psql.exe -h localhost -U mi601db -p 5432 -o
C:<filepath>db_create_output.txt -L C:\<filepath>\db_create_log.txt -d
skyfall < C:<filepath>\mi601db.pg

All objects and data appear in the new database as expected, except for
a single trigger named subscribers_iur_trg. The trigger exists in
production and in the pgdump file. I can add it manually with no errors
but it's always missing after our automated process. Nothing useful
appears in the log file. The dependent function,
devops.subscribers_update() is present and accounted for as is the view,
devops.subscribers.

CREATE TRIGGER subscribers_iur_trg
INSTEAD OF UPDATE
ON devops.subscribers
FOR EACH ROW
EXECUTE PROCEDURE devops.subscribers_update();

We've checked everything we can think of but we're still missing the
trigger every day.

Thanks for your help!

Sue
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan(dot)hurst(at)brookhurstdata(dot)com
Mobile: 314-486-3261

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-08-16 18:37:59 Re: Missing Trigger after pgdump install
Previous Message Gavin Flower 2019-08-16 17:13:23 Re: Variable constants ?