Re: Both type of replications from a single server?

Поиск
Список
Период
Сортировка
От Srinivasa T N
Тема Re: Both type of replications from a single server?
Дата
Msg-id CAFruNdcqEwkHa+wXqmRyssB+nudmUCtj3g84qhmnWVhL4E44tw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Both type of replications from a single server?  (Srinivasa T N <seenutn@gmail.com>)
Ответы Re: Both type of replications from a single server?  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-general


On Thu, Oct 8, 2020 at 12:50 PM Srinivasa T N <seenutn@gmail.com> wrote:
On Thu, Oct 8, 2020 at 12:19 PM Michael Paquier <michael@paquier.xyz> wrote:
On Thu, Oct 08, 2020 at 11:43:26AM +0530, Srinivasa T N wrote:
>    Is it possible to have both type of replications (streaming and logical)
> from a single server?

Yes.

>    If I have 3 servers A,B and C, then I want to have streaming replication
> from A to B whereas logical replication from A to C.  Is it possible?

And yes.
My next question is "Are there any setup instructions available for the same"?
 
For streaming replication, I need to set wal_level to replica in A whereas for logical_replication we need to set wal_level to replica in the same A server.  So, was wondering how to go about?

Regards,
Seenu.

В списке pgsql-general по дате отправления:

Предыдущее
От: Levente Birta
Дата:
Сообщение: pgadmin4 error
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Both type of replications from a single server?