Postgres Pro
Downloads
Home   >   mailing lists

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

From Keith
Subject Re: How can I tell if pg_restore is running?
Date
Msg-id CAHw75vszQ4W-h9jfuea0gGmabyD4FxViywokUNXYk9uy39BvtQ@mail.gmail.com
Whole thread Raw
In response to Re: How can I tell if pg_restore is running?  (Moshe Jacobson <moshe@neadwerx.com>)
List pgsql-general
Tree view
If you can't use a wrapper script and you can't use that flag, I'm not sure how you're going to manage to keep this a process that's simple for a typical end user to manage. From what I know, there's nothing internally on the data loading process that pg_restore uses that would guarantee you that what is loading the data is pg_restore. Might need to rethink your strategy here.


On Wed, Jun 11, 2014 at 2:18 PM, Moshe Jacobson <moshe@neadwerx.com> wrote:

On Tue, Jun 10, 2014 at 10:57 AM, Francisco Olarte <folarte@peoplecall.com> wrote:
Is there any reason to avoid pg_restore --disable-triggers ?

Yes, this extension needs to work with everyone's normal restore process. Otherwise I would have to ask everyone who used my extension to modify their pg_restore command.

This also means that I can't rely on a wrapper to pg_restore, as Keith suggested earlier.



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: Merlin Moncure
Date:
Subject: Re: what does pg_activity mean when the database is stuck?
Next
From: Merlin Moncure
Date:
Subject: Re: max_connections reached in postgres 9.3.3