Trigger function on Warm Standby

Поиск
Список
Период
Сортировка
От ning chan
Тема Trigger function on Warm Standby
Дата
Msg-id CAG0k5vBYTXDxdnUg1c_xugJzxFYCgwgAuGRHG7b2VMdpwvP=VA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Trigger function on Warm Standby
Список 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

В списке pgsql-general по дате отправления: