```2022-08-18 12:52:00 source > Caused by: org....
# advice-data-ingestion
r
Copy code
2022-08-18 12:52:00 source > Caused by: org.postgresql.util.PSQLException: ERROR: publication "airbyte_publication" does not exist
2022-08-18 12:52:00 source >   Where: slot "airbyte_slot", output plugin "pgoutput", in the change callback, associated LSN 338C/B861BCF0
I’m seeing above when trying to sync to a postgres 10 db, first sync works, second fails. The publication definitely exists.
a
@Rocky Appiah did you create the replication slot before the publication? I suspect you may have created the publication first, which will cause this error on the second sync
You likely need to drop/recreate the publication, and then reset the source in airbyte
r
I created the replication slot and then the publication, but subsequently recreated the replication slot (i.e.: drop and then create). So I guess that’s the cause.