Regarding built-in logical replication

2018-01-11 Thread PG Doc comments form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/static/logical-replication.html
Description:

I am referring to link
'https://www.postgresql.org/docs/10/static/logical-replication.html' and it
has been mentioned that 'Replicating between different major versions of
PostgreSQL.' under the section of 'The typical use-cases for logical
replication are:' but I don't think logical replication using
PUBLICATION/SUBSCRIPTION model is possible between different PostgreSQL
versions, which is only possible using pglogical.


Re: [DOCS] Add JSON to the list of acronyms in the documentation's appendix

2018-01-11 Thread Bruce Momjian
On Tue, Oct 24, 2017 at 08:18:49PM +, torsten.gr...@gmail.com wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/10/static/acronyms.html
> Description:
> 
> Hello all,
> 
> I propose to add 'JSON' (for JavaScript Object Notation, 
> http://json.org) to
> the list of acronyms in the documentation's appendix
> (https://www.postgresql.org/account/comments/new/10/acronyms.html/).

Good idea.  Patch applied --- it will appear in PG 11.

-- 
  Bruce Momjian  http://momjian.us
  EnterpriseDB http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+  Ancient Roman grave inscription +
diff --git a/doc/src/sgml/acronyms.sgml b/doc/src/sgml/acronyms.sgml
new file mode 100644
index 6e9fddf..751c46d
*** a/doc/src/sgml/acronyms.sgml
--- b/doc/src/sgml/acronyms.sgml
***
*** 370,375 
--- 370,385 
 
  
 
+ JSON
+ 
+  
+   http://json.org";>JavaScript Object Notation
+  
+ 
+
+ 
+
  LDAP
  
   


Re: [DOCS] Add JSON to the list of acronyms in the documentation's appendix

2018-01-11 Thread Oleg Bartunov
On Thu, Jan 11, 2018 at 7:22 PM, Bruce Momjian  wrote:
> On Tue, Oct 24, 2017 at 08:18:49PM +, torsten.gr...@gmail.com wrote:
>> The following documentation comment has been logged on the website:
>>
>> Page: https://www.postgresql.org/docs/10/static/acronyms.html
>> Description:
>>
>> Hello all,
>>
>> I propose to add 'JSON' (for JavaScript Object Notation, 
>> http://json.org) to
>> the list of acronyms in the documentation's appendix
>> (https://www.postgresql.org/account/comments/new/10/acronyms.html/).
>
> Good idea.  Patch applied --- it will appear in PG 11.

Then, why not add JSONB !

>
> --
>   Bruce Momjian  http://momjian.us
>   EnterpriseDB http://enterprisedb.com
>
> + As you are, so once was I.  As I am, so you will be. +
> +  Ancient Roman grave inscription +



Re: [DOCS] Add JSON to the list of acronyms in the documentation's appendix

2018-01-11 Thread Bruce Momjian
On Thu, Jan 11, 2018 at 08:13:28PM +0300, Oleg Bartunov wrote:
> On Thu, Jan 11, 2018 at 7:22 PM, Bruce Momjian  wrote:
> > On Tue, Oct 24, 2017 at 08:18:49PM +, torsten.gr...@gmail.com wrote:
> >> The following documentation comment has been logged on the website:
> >>
> >> Page: https://www.postgresql.org/docs/10/static/acronyms.html
> >> Description:
> >>
> >> Hello all,
> >>
> >> I propose to add 'JSON' (for JavaScript Object Notation, 
> >> http://json.org) to
> >> the list of acronyms in the documentation's appendix
> >> (https://www.postgresql.org/account/comments/new/10/acronyms.html/).
> >
> > Good idea.  Patch applied --- it will appear in PG 11.
> 
> Then, why not add JSONB !

Uh, most of those acronyms are for _externally_ defined terms.

-- 
  Bruce Momjian  http://momjian.us
  EnterpriseDB http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+  Ancient Roman grave inscription +



Re: Regarding built-in logical replication

2018-01-11 Thread Peter Eisentraut
On 1/11/18 09:48, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/10/static/logical-replication.html
> Description:
> 
> I am referring to link
> 'https://www.postgresql.org/docs/10/static/logical-replication.html' and it
> has been mentioned that 'Replicating between different major versions of
> PostgreSQL.' under the section of 'The typical use-cases for logical
> replication are:' but I don't think logical replication using
> PUBLICATION/SUBSCRIPTION model is possible between different PostgreSQL
> versions, which is only possible using pglogical.

The documentation is correct.

(The only caveat is that there are currently no other versions than 10
that have built-in logical replication, but if there were any, it would
work.)

-- 
Peter Eisentraut  http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



Re: Regarding built-in logical replication

2018-01-11 Thread Ranjan Gajare
This means it would work with version 10 and its later versions. No
backward compatibility is possible.
Thanks for resolution.

Ranjan Gajare


On 12-Jan-2018 2:14 AM, "Peter Eisentraut" 
wrote:

On 1/11/18 09:48, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/10/static/logical-replication.html
> Description:
>
> I am referring to link
> 'https://www.postgresql.org/docs/10/static/logical-replication.html' and
it
> has been mentioned that 'Replicating between different major versions of
> PostgreSQL.' under the section of 'The typical use-cases for logical
> replication are:' but I don't think logical replication using
> PUBLICATION/SUBSCRIPTION model is possible between different PostgreSQL
> versions, which is only possible using pglogical.

The documentation is correct.

(The only caveat is that there are currently no other versions than 10
that have built-in logical replication, but if there were any, it would
work.)

--
Peter Eisentraut  http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services