1

I am trying to create a publication (for logical replication) in PostgreSQL database but it throws an error:

indsolv_dev=# CREATE PUBLICATION my_publication;
ERROR:  syntax error at or near "PUBLICATION"
LINE 1: CREATE PUBLICATION my_publication;
1
  • 2
    What version are you using (select version();)? CREATE PUBLICATION was not implemented until v10.
    – jjanes
    Mar 27, 2019 at 11:51

1 Answer 1

1

As JJanes mentioned, Publication is available from Version 10. I was using version 9.6.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.