How can I tell if pg_restore is running? - Mailing list pgsql-general

From Moshe Jacobson
Subject How can I tell if pg_restore is running?
Date
Msg-id CAJ4CxLnPbq8nuaYcsJfxSQcnXNM8j8W1GRyweORQqsp=RSwJCw@mail.gmail.com
Whole thread Raw
Responses Re: How can I tell if pg_restore is running?
Re: How can I tell if pg_restore is running?
Re: How can I tell if pg_restore is running?
List pgsql-general
My extension has a config table that is dumped by pg_dump and populated by pg_restore.
However, this table has triggers on it that I would like not to do anything if the table is being populated by pg_restore. I want the triggers to operate only if the user is manipulating the table directly after the database has been restored and is running.

Is there a way for my extension's trigger functions to return immediately when triggered by pg_restore?

Thanks.

Moshe Jacobson
Manager of Systems Engineering, Nead Werx Inc.
2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339

"Quality is not an act, it is a habit." -- Aristotle

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_standby replication problem
Next
From: Keith Fiske
Date:
Subject: Re: How can I tell if pg_restore is running?