Groups | Search | Server Info | Keyboard shortcuts | Login | Register

Groups > pgsql.general > #21

logical replication postgres 10 !

Show all headers | View raw

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

Back to pgsql.general | Previous | Next | Find similar

Thread

logical replication postgres 10 ! preom.ssk@gmail.com - 2017-09-27 23:18 -0700

csiph-web