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 по дате отправления: