Trigger function on Warm Standby

From: ning chan <ninchan8328(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Trigger function on Warm Standby
Date: 2013-05-08 19:38:45
Message-ID: CAG0k5vBYTXDxdnUg1c_xugJzxFYCgwgAuGRHG7b2VMdpwvP=VA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I have a Primary Standby setup with streaming replication.
Trigger is created on a table, and all it does it to log a message.

The trigger works as expected on Primary, however, I don't see the same on
standby.

I alter the table to have ENABLE ALWAYS TRIGGER, I verified the setting on
both Primary and Standby which is set to A.

Standby:
-bash-4.1$ psql -c "select tgrelid, tgname, tgenabled from pg_trigger where
tgname='processnodeafter'"
tgrelid | tgname | tgenabled
---------+------------------+-----------
19218 | processnodeafter | A

Primary:
postgres=# select tgrelid, tgname, tgenabled from pg_trigger where
tgname='processnodeafter';
tgrelid | tgname | tgenabled
---------+------------------+-----------
19218 | processnodeafter | A
(1 row)

Can someone tell me if the trigger will never happen on the Standby server?
Is it expected or am I missing some other settings?

Thanks~
Ning

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2013-05-08 20:12:12 Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4
Previous Message Tyson Maly 2013-05-08 19:14:39 Re: question on most efficient way to increment a column