Re: [ADMIN] Replicate only 1 out of 2 databases of Server A to ServerB ?

Поиск
Список
Период
Сортировка
От John Scalia
Тема Re: [ADMIN] Replicate only 1 out of 2 databases of Server A to ServerB ?
Дата
Msg-id CABzCKRDJwUT8-ovOZcaW6-G78kDgh14jr-3d7mm6o_sZvb3SLA@mail.gmail.com
обсуждение исходный текст
Ответ на [ADMIN] Replicate only 1 out of 2 databases of Server A to Server B ?  (czezz <czezz@o2.pl>)
Список pgsql-admin
Дерево обсуждения
Yes, that is possible through PostgreSQL's logical replication system. It sounds like, however, you're using streaming replication and that cannot replicate just one database from the master cluster. So, you'll have to change your mechanism. Suggest you look at configuring logical replication.
--
Jay

On Mon, Apr 24, 2017 at 9:33 AM, czezz <czezz@o2.pl> wrote:
Hi all.

PostgreSQL 9.2.18
Running on replication mode Master-Slave (async).
Server A (2 databases) is fully replicated to Server B.
That works OK.

Question:
Is it possible to replicate only 1 out of 2 databases of Server A to Server B?

Best regards,
czezz

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

Предыдущее
От: czezz
Дата:
Сообщение: [ADMIN] Replicate only 1 out of 2 databases of Server A to Server B ?
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [ADMIN] Replicate only 1 out of 2 databases of Server A to ServerB ?