| 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: | Whole Thread | Raw Message | 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
| 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 |