Folks,

I'm about to embark on a new thing: auditing.  In order to get this
auditing actually done, I'll be using an extension I've written
https://github.com/disqus/pg_audit

The extension generates some triggers on tables in an extant
replication set, which triggers should fire on the origin.  What
I'd like to figure out is how to add the auditing stuff on replicas,
as the triggers should not fire there, or at least not until same gets
promoted to origin.

Any tips as to how generally to add triggers across an existing
replication set?

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