Re: 9.4+ partial log-shipping possible? - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: 9.4+ partial log-shipping possible?
Date
Msg-id 20150326175322.GA16654@tux
Whole thread Raw
In response to 9.4+ partial log-shipping possible?  (Sven Geggus <lists@fuchsschwanzdomain.de>)
List 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 by date:

Previous
From: Marc Mamin
Date:
Subject: Re: :Posgres - performance problem
Next
From: Francisco Olarte
Date:
Subject: Re: Column does not exists?