info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
logical replication postgres 10 !
17 views
Skip to first unread message
preo...@gmail.com
Sep 28, 2017, 2:18:03 AM9/28/17
to
postgres=# \c rock_legends_db;
You are now connected to database "rock_legends_db" as user "postgres".
rock_legends_db=# CREATE PUBLICATION pub_rock FOR TABLE rocker_girls;
ERROR: syntax error at or near "PUBLICATION"
LINE 1: CREATE PUBLICATION pub_rock FOR TABLE rocker_girls;
^
rock_legends_db=# CREATE PUBLICATION pub_rock FOR TABLE rocker_girls;
ERROR: syntax error at or near "PUBLICATION"
LINE 1: CREATE PUBLICATION pub_rock FOR TABLE rocker_girls;
well can anyone please help with the reason behind syntax error and how may i resolve it !!!
source : https://www.openscg.com/2017/06/the-easy-way-to-setup-postgresql-10-logical-replication/
https://www.postgresql.org/docs/10/static/logical-replication-quick-setup.html
You are now connected to database "rock_legends_db" as user "postgres".
rock_legends_db=# CREATE PUBLICATION pub_rock FOR TABLE rocker_girls;
ERROR: syntax error at or near "PUBLICATION"
LINE 1: CREATE PUBLICATION pub_rock FOR TABLE rocker_girls;
^
rock_legends_db=# CREATE PUBLICATION pub_rock FOR TABLE rocker_girls;
ERROR: syntax error at or near "PUBLICATION"
LINE 1: CREATE PUBLICATION pub_rock FOR TABLE rocker_girls;
well can anyone please help with the reason behind syntax error and how may i resolve it !!!
source : https://www.openscg.com/2017/06/the-easy-way-to-setup-postgresql-10-logical-replication/
https://www.postgresql.org/docs/10/static/logical-replication-quick-setup.html
0 new messages