Re: 9.4+ partial log-shipping possible?

Sven Geggus <lists(at)fuchsschwanzdomain(dot)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°