Re: Logical replication and restore from pg_basebackup

2019-02-12 Thread Alexey Kondratov
Hi Dmitry, On 11.02.2019 17:39, Dmitry Vasiliev wrote: What is the scope of logical replication if I cannot make recovery from pg_basebackup? No, you can, but there are some things to keep in mind: 1) I could be wrong, but usage of pgbench in such a test seems to be a bad idea, since it dro

Re: Logical replication and restore from pg_basebackup

2019-02-11 Thread Michael Paquier
On Mon, Feb 11, 2019 at 05:39:49PM +0300, Dmitry Vasiliev wrote: > Do I understand correctly that logical replication and recovery from > pg_basebackup are incompatible things? When using physical streaming replication, it is mandatory to have nodes with a system ID matching, meaning that all node

Re: Logical replication and restore from pg_basebackup

2019-02-11 Thread Dmitry Vasiliev
At the start of the logical subscriber is not informed that it is connected to the logical replication slot with a non-consistent state. Whether I understood correctly that, postgresql deceives the user and data in logical replication cannot be trusted. 2019-02-11 17:22:20.103 MSK [71156] LOG: da

Logical replication and restore from pg_basebackup

2019-02-11 Thread Dmitry Vasiliev
What is the scope of logical replication if I cannot make recovery from pg_basebackup? in this example: https://gist.github.com/vadv/e55fca418d6a14da71f01a95da493fae I get logically unsynchronized data at the subscriber and publisher, but I'm not told anything about it in the log. Do I understand