On Tue, 11 Feb 2014, David Fetter wrote:

> On Tue, Feb 11, 2014 at 08:46:26PM -0500, Vick Khera wrote:
>> On Sat, Feb 8, 2014 at 12:23 PM, Steve Singer <steve at ssinger.info> wrote:
>>
>>> Just add the triggers to your tables as you normally would on all nodes.
>>
>> Which is to say using slonik to run the SQL script that will add them.
>
> Thanks for clarifying that.  It's kinda important :)

You can add the triggers via slonik EXECUTE SCRIPT, but in most cases you 
can also add the triggers to all nodes directly with psql.

With the psql method the triggers get added to all nodes immedately, even if 
the node is behind in replication.  With a origin only trigger this 
shouldn't make a difference.  If the trigger does stuff on replicas then 
this is more of an issue.



>
> Cheers,
> David.
> -- 
> David Fetter <david at fetter.org> http://fetter.org/
> Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
> Skype: davidfetter      XMPP: david.fetter at gmail.com
> iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
>
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
>