ALTER NOTIFIER

Updates an existing notifier.

To change the action URL associated with an existing identifier, drop the notifier and re-create it.

Syntax

ALTER NOTIFIER notifier‑name parameter[...]


[NO] CHECK COMMITTED
ENABLE | DISABLE
IDENTIFIED BY uuid
MAXMEMORYSIZE max‑memory‑size
MAXPAYLOAD max‑payload‑size
PARAMETERS 'adapter‑params'

Parameters

notifier‑name Specifies the notifier to update.
[NO] CHECK COMMITTED Specifies to wait for delivery confirmation before sending the next message in the queue. Not all messaging systems support delivery confirmation.
ENABLE|DISABLE Specifies whether to enable or disable the notifier.
IDENTIFIED BY uuid Specifies the notifier's unique identifier. If set, all the messages published by this notifier have this attribute.
MAXMEMORYSIZE

The maximum size of the internal notifier, up to 2 TB, specified in kilobytes, megabytes, gigabytes, or terabytes as follows:

MAXMEMORYSIZE integer{K|M|G|T}

If the queue exceeds this size, the notifier drops excess messages.
MAXPAYLOAD

The maximum size of the message, up to 2 TB, specified in kilobytes, megabytes, gigabytes, or terabytes as follows:

MAXPAYLOAD integer{K|M|G|T}

The default setting is adapter-specific—for example, 1 M for Kafka.
PARAMETERS 
'adapter‑params'

Specifies one or more optional adapter parameters that are passed as a string to the adapter. Adapter parameters apply only to the adapter associated with the notifier.

For Kafka notifiers, refer to Kafka and Vertica Configuration Settings.

Privileges

Superuser

Examples

Update the settings on an existing notifier:

=> ALTER NOTIFIER my_dc_notifier
	ENABLE
	MAXMEMORYSIZE '2G'
	IDENTIFIED BY 'f8b0278a-3282-4e1a-9c86-e0f3f042a971'
	CHECK COMMITTED;

See Also