Re: Moving a large DB (> 500GB) to another DB with different locale

Поиск
Список
Период
Сортировка
От Shulgin, Oleksandr
Тема Re: Moving a large DB (> 500GB) to another DB with different locale
Дата
Msg-id CACACo5Tvdd5gaOA=2ne-+YGdNQwqEBi12Pd0OXbNYd6YfhsQcg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Moving a large DB (> 500GB) to another DB with different locale  (Andreas Joseph Krogh <andreas@visena.com>)
Ответы Re: Moving a large DB (> 500GB) to another DB with different locale  (Andreas Joseph Krogh <andreas@visena.com>)
Список pgsql-general
Дерево обсуждения
On Fri, Jan 15, 2016 at 1:02 PM, Andreas Joseph Krogh <andreas@visena.com> wrote:
På torsdag 14. januar 2016 kl. 00:34:51, skrev Jim Nasby <Jim.Nasby@BlueTreble.com>:
On 1/13/16 2:39 PM, Andreas Joseph Krogh wrote:
> Where can I find more info about how to use and configure pg_logical to
> replicate a 9.4 DB to 9.5?

http://2ndquadrant.com/en/resources/pglogical/
 
Thanks, I found detailed instructions in /usr/share/doc/postgresql-9.5-pglogical/README.md.gz
Any chance of putting in online?
 
I see that wal_level = 'logical', and that is a problem for us as we already use wal_level = 'hot_standby' on this installation as it replicates to another server.
 
Is it possible to use pglogical together with hot_standby streaming-replication?

Well, the wal_level change is just a matter of database restart: you got to do that once in a while anyway, e.g. for minor version updates.  I would expect you only need this wal_level on the walsender side, thus for pglogical_output, the logical decoding plugin.

--
Alex

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

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: Moving a large DB (> 500GB) to another DB with different locale
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: Moving a large DB (> 500GB) to another DB with different locale