Re: Replication with non-read-only standby.

Поиск
Список
Период
Сортировка
От Venkata Balaji N
Тема Re: Replication with non-read-only standby.
Дата
Msg-id CAEyp7J_pXRSjuWcYH9wA+LYYjwniC52VgO-S-ROjW=V+7q73Yg@mail.gmail.com
обсуждение исходный текст
Ответ на Replication with non-read-only standby.  (Nick Babadzhanian <nb@cobra.ru>)
Ответы Re: Replication with non-read-only standby.  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Список pgsql-general
Дерево обсуждения

On Thu, Jun 30, 2016 at 11:15 PM, Nick Babadzhanian <nb@cobra.ru> wrote:
Setup:
2 PostgreSQL servers are geographically spread. The first one is used for an application that gathers data. It is connected to the second database that is used to process the said data. Connection is not very stable nor is it fast, so using Bidirectional replication is not an option. It is OK if data is shipped in batches rather than streamed.

Question:
Is there a way to make the standby server non-read-only, so that it can keep getting updates (mostly inserts) from the 'master', but users are able to edit the data stored on 'slave'? Is there some alternative solution to this?

You can consider Ruby replication for such a requirement. I think, there is no much development happening around Ruby Replication since long time i believe. This can be used for production environment.



Regards,
Venkata B N

Fujitsu Australia

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Question about "grant create on database" and pg_dump/pg_dumpall
Следующее
От: Sridhar N Bamandlapally
Дата:
Сообщение: Re: table name size