Restrictions of logical replication

Hi Tatsuo,

On Fri, Jun 16, 2017 at 04:00:56PM +0900, Tatsuo Ishii wrote:

Maybe I am missing something, but I could not find any description
that logical replication does not support large objects and TRUNCATE
in the doc. Do we want to add them to the doc as the restrictions of
the logical replication?

I knew about TRUNCATE and it most definitely should be documented if
it's not yet. And what about large objects?

--
Best regards,
Aleksander Alekseev

2017-06-16 4:00 GMT-03:00 Tatsuo Ishii <ishii@sraoss.co.jp>:

Maybe I am missing something, but I could not find any description
that logical replication does not support large objects and TRUNCATE
in the doc. Do we want to add them to the doc as the restrictions of
the logical replication?

Docs stated "Publications can choose to limit the changes they produce to
any combination of INSERT, UPDATE, and DELETE". It is clear that only those
DMLs are supported. However, we should mention that large objects are not
supported.

--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
<http://www.timbira.com.br&gt;

On 6/16/17 03:00, Tatsuo Ishii wrote:

Maybe I am missing something, but I could not find any description
that logical replication does not support large objects and TRUNCATE
in the doc. Do we want to add them to the doc as the restrictions of
the logical replication?

Some of that information was sprinkled around, but I have now added a
new section that collects them all in one place. (section 31.4)

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

On 6/16/17 03:00, Tatsuo Ishii wrote:

Maybe I am missing something, but I could not find any description
that logical replication does not support large objects and TRUNCATE
in the doc. Do we want to add them to the doc as the restrictions of
the logical replication?

Some of that information was sprinkled around, but I have now added a
new section that collects them all in one place. (section 31.4)

Great. Thanks!
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Docs stated "Publications can choose to limit the changes they produce to
any combination of INSERT, UPDATE, and DELETE". It is clear that only those
DMLs are supported.

What about COPY?

However, we should mention that large objects are not
supported.

Right.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

2017-06-16 11:03 GMT-03:00 Peter Eisentraut <
peter.eisentraut@2ndquadrant.com>:

Some of that information was sprinkled around, but I have now added a
new section that collects them all in one place. (section 31.4)

Shouldn't we mention that COPY is supported?

--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
<http://www.timbira.com.br&gt;

Some of that information was sprinkled around, but I have now added a
new section that collects them all in one place. (section 31.4)

Shouldn't we mention that COPY is supported?

I think any commands that are not mentioned in the section are
considered to be supported.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

On 6/16/17 10:59, Tatsuo Ishii wrote:

Docs stated "Publications can choose to limit the changes they produce to
any combination of INSERT, UPDATE, and DELETE". It is clear that only those
DMLs are supported.

What about COPY?

Sure, added note about that as well.

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers