Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
| X-Received | by 10.237.57.163 with SMTP id m32mr3341117qte.29.1506579482646; Wed, 27 Sep 2017 23:18:02 -0700 (PDT) |
|---|---|
| X-Received | by 10.31.211.195 with SMTP id k186mr129055vkg.9.1506579482613; Wed, 27 Sep 2017 23:18:02 -0700 (PDT) |
| Path | csiph.com!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!q8no1150267qtb.0!news-out.google.com!x15ni684qth.1!nntp.google.com!b1no1147544qtc.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail |
| Newsgroups | pgsql.general |
| Date | Wed, 27 Sep 2017 23:18:02 -0700 (PDT) |
| Complaints-To | groups-abuse@google.com |
| Injection-Info | glegroupsg2000goo.googlegroups.com; posting-host=123.49.3.114; posting-account=8uhEbQoAAADyNDfN7zd79ieQ4T1OFtl4 |
| NNTP-Posting-Host | 123.49.3.114 |
| User-Agent | G2/1.0 |
| MIME-Version | 1.0 |
| Message-ID | <c25ed426-b3e0-4823-89fd-e2435673f6c4@googlegroups.com> (permalink) |
| Subject | logical replication postgres 10 ! |
| From | preom.ssk@gmail.com |
| Injection-Date | Thu, 28 Sep 2017 06:18:02 +0000 |
| Content-Type | text/plain; charset="UTF-8" |
| Lines | 16 |
| Xref | csiph.com pgsql.general:21 |
Show key headers only | 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
logical replication postgres 10 ! preom.ssk@gmail.com - 2017-09-27 23:18 -0700
csiph-web