Re: 9.4+ partial log-shipping possible?

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: 9.4+ partial log-shipping possible?
Дата
Msg-id 20150326175322.GA16654@tux
обсуждение исходный текст
Ответ на 9.4+ partial log-shipping possible?  (Sven Geggus <lists@fuchsschwanzdomain.de>)
Список pgsql-general
Sven Geggus <lists@fuchsschwanzdomain.de> wrote:

> So here is my question:
>
> Would it be possible to have a setup, where one master data database will
> act in the above matter (still running osm2pgsl) but will also provide
> publicly availabe data for log-shipping standby servers?
>
> We would need to be able to explicitely specify the tables to be replicated
> or the other way round explicitely exclude a couple of them. If this helps
> it would be possible to separate them by tablespaces.

you can use logical replication slots, but afaik there are no
ready-to-use solution available.

Read more:
http://michael.otacoo.com/postgresql-2/postgres-9-4-feature-highlight-basics-logical-decoding/

i think, this (logical replication) are still under construction...


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


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

Предыдущее
От: Marc Mamin
Дата:
Сообщение: Re: :Posgres - performance problem
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: Column does not exists?