Page History

PGEvent Component (PostgresSQL Event)

This is a component for Apache Camel which allows for Producing/Consuming PostgreSQL events related to the LISTEN/NOTIFY commands added since PostgreSQL 8.3.

Maven users will need to add the following dependency to their pom.xml for this component:

Code Block

	xml
	xml

<dependency>
    <groupId>org.apache.camel</groupId>
    <artifactId>camel-pgevent</artifactId>
    <version>x.x.x</version>
    <!-- use the same version as your Camel core version -->
</dependency>

URI format

The pgevent component uses the following two styles of endpoint URI notation:

Code Block
pgevent:datasource[?parameters] pgevent://host:port/database/channel[?parameters]

You can append query options to the URI in the following format, ?option=value&option=value&...

Options

Div

class	confluenceTableSmall

Option	Type	Default	Description
`datasource`	String		Name of datasource to lookup from the registry to use
hostname	String	localhost	Instead of using datasource, then connect to the PostgresSQL database using this hostname and port
port	int	5432	Instead of using datasource, then connect to the PostgresSQL database using this hostname and port
database	String		The database name
channel	String		The channel name
user	String	postgres	Username
pass	String		Password

Include Page

	Endpoint See Also
	Endpoint See Also

Child pages

Versions Compared

Old Version 2

New Version Current

Key

PGEvent Component (PostgresSQL Event)

Options