ERROR: extension "pgoutput" is not available while trying to use it with airbyte to replicate the data from PostgreSQL in real-time using CDC

Question

I am planning to use airbyte to replicate data from my PostgreSQL database to Elasticsearch in real-time using CDC. According to the documentation

The pgoutput plug-in is always present, meaning that no additional libraries must be installed, 
and the connector will interpret the raw replication event stream into change events directly.

So, when I tried to run CREATE EXTENSION IF NOT EXISTS "pgoutput";

It is showing this error.

SQL Error [0A000]: ERROR: extension "pgoutput" is not available
  Detail: Could not open extension control file "/usr/local/share/postgresql/extension/pgoutput.control": No such file or directory.
  Hint: The extension must first be installed on the system where PostgreSQL is running.

How can I solve this issue? Thanks in advance for detailed answer

Answer 1

pgoutput is not an extension, it is "always present". Just use it in a replication slot, for example:

SELECT pg_create_logical_replication_slot('slot_name', 'pgoutput');