Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ERROR: publication "pub_test" does not exist #2

Closed
Andrewpqc opened this issue Jan 8, 2021 · 1 comment
Closed

ERROR: publication "pub_test" does not exist #2

Andrewpqc opened this issue Jan 8, 2021 · 1 comment
Labels
question Further information is requested

Comments

@Andrewpqc
Copy link

I do sure that the publication "pub_test" exist, but WaitForReplicationMessage method of jackc/pgx return a error that tell me "publication "pub_test" does not exist ". I'd appreciate if you could help.

@ihippik ihippik added the question Further information is requested label Jan 8, 2021
@ihippik
Copy link
Owner

ihippik commented Jan 8, 2021

Forgot to mention this in the documentation. First you need to create a post:
CREATE PUBLICATION "wal-listener" FOR ALL TABLES;

But this must be done before the slot is created, since they will be connected.

ps. do it in the code, but you will have to change the name of the slot or delete the existing one

@ihippik ihippik closed this as completed Jan 8, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants