Greg Stark <gsst...@mit.edu> writes: > What happens on the slave when normal NOTIFYs are generated on the > master? IIRC NOTIFYs are wal-logged so I imagine LISTEN on the slave > would just work and a plain old NOTIFY/LISTEN would suffice for this > use case?
Nothing happens: NOTIFYs are *not* WAL-logged, and it would be quite against the intended use-case to have them be. If you're hoping that processes on the slave could LISTEN for events happening on the master, we'd have a bit of a conflict. This might be an example of a case where we need that "are we doing HS" flag that Simon insists we don't need. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers