alexhwoods · June 14, 2024 13:43 · Feb 21, 2020 · Feb 21, 2020 · Jan 6, 2020 · Jan 6, 2020
diff --git a/README.md b/README.md
@@ -10,7 +10,7 @@ Aiven doesn't allow you to have a superuser. Debezium tries to create a publicat
 
 # How To Fix It
 
-We have to create the publication before configuring the connector. Publications are database specific, so you have to do this when you're connected to the database you're going to use for CDC.
+We have to create the publication before configuring the connector. **Publications are database specific, so you have to do this when you're connected to the database you're going to use for CDC.**
 
 There is a package called [aiven-extras](https://github.com/aiven/aiven-extras) that allows you to create a publication.
 

diff --git a/README.md b/README.md
@@ -6,21 +6,28 @@ You're getting this error: `Caused by: org.postgresql.util.PSQLException: ERROR:
 
 # Why This is Happening
 
-Aiven doesn't allow you to have a superuser. Debezium tries to create a publication, and fails, because it's not using a superuser. 
+Aiven doesn't allow you to have a superuser. Debezium tries to create a publication, and fails, because it's not using a superuser.
 
 # How To Fix It
 
-We have to create the publication before configuring the connector. There is a package called [aiven-extras](https://github.com/aiven/aiven-extras) that allows you to create a publication.
+We have to create the publication before configuring the connector. Publications are database specific, so you have to do this when you're connected to the database you're going to use for CDC.
 
-1. Install aiven-extras
+There is a package called [aiven-extras](https://github.com/aiven/aiven-extras) that allows you to create a publication.
+
+1. Connect to the database you'll use.
+```
+\connect foodb;
+```
+
+2. Install aiven-extras
 ```
 CREATE EXTENSION aiven_extras CASCADE;
 ```
 
-2. Create a publication for all tables
+3. Create a publication for all tables
 ```sql
 SELECT *
-FROM aiven_extras.pg_create_publication_for_all_tables('dbz_publication', 'INSERT,UPDATE,DELETE')
+FROM aiven_extras.pg_create_publication_for_all_tables('dbz_publication', 'INSERT,UPDATE,DELETE');
 ```
 
 It must be called `dbz_publication`. That is what Debezium is expecting.

diff --git a/README.md b/README.md
@@ -20,7 +20,7 @@ CREATE EXTENSION aiven_extras CASCADE;
 2. Create a publication for all tables
 ```sql
 SELECT *
-FROM aiven_extras.pg_create_publication_for_all_tables('dbz_publication', 'INSERT')
+FROM aiven_extras.pg_create_publication_for_all_tables('dbz_publication', 'INSERT,UPDATE,DELETE')
 ```
 
 It must be called `dbz_publication`. That is what Debezium is expecting.

diff --git a/README.md b/README.md
@@ -0,0 +1,28 @@
+# Issue
+
+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`.
+
+# Why This is Happening
+
+Aiven doesn't allow you to have a superuser. Debezium tries to create a publication, and fails, because it's not using a superuser. 
+
+# How To Fix It
+
+We have to create the publication before configuring the connector. There is a package called [aiven-extras](https://github.com/aiven/aiven-extras) that allows you to create a publication.
+
+1. Install aiven-extras
+```
+CREATE EXTENSION aiven_extras CASCADE;
+```
+
+2. Create a publication for all tables
+```sql
+SELECT *
+FROM aiven_extras.pg_create_publication_for_all_tables('dbz_publication', 'INSERT')
+```
+
+It must be called `dbz_publication`. That is what Debezium is expecting.
+
+Now, you can run your connector and it should work (or you might have other, likely fixable issues).
No results found