Postgres Pro
Downloads
Home   >   mailing lists

Trigger function on Warm Standby - Mailing list pgsql-general

From ning chan
Subject Trigger function on Warm Standby
Date
Msg-id CAG0k5vBYTXDxdnUg1c_xugJzxFYCgwgAuGRHG7b2VMdpwvP=VA@mail.gmail.com
Whole thread Raw
Responses Re: Trigger function on Warm Standby  (Jerry Sievers <gsievers19@comcast.net>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Tyson Maly
Date:
Subject: Re: question on most efficient way to increment a column
Next
From: Igor Neyman
Date:
Subject: Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4