You're trying to use Kafka Connect, using the Debezium to Postgres, and your Postgres database is running on Aiven. You have pgoutput
selected as the plugin name (this is the best choice).
You're getting this error: Caused by: org.postgresql.util.PSQLException: ERROR: must be superuser to create FOR ALL TABLES publication
.
Aiven doesn't allow you to have a superuser. Debezium tries to create a publication, and fails, because it's not using a superuser.