How can I tell if pg_restore is running?

From: Moshe Jacobson <moshe(at)neadwerx(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How can I tell if pg_restore is running?
Date: 2014-06-10 14:02:10
Message-ID: CAJ4CxLnPbq8nuaYcsJfxSQcnXNM8j8W1GRyweORQqsp=RSwJCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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. <http://www.neadwerx.com>
2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Keith Fiske 2014-06-10 14:39:16 Re: How can I tell if pg_restore is running?
Previous Message Adrian Klaver 2014-06-10 13:45:14 Re: pg_standby replication problem