Re: Wal files - Question | Postgres 9.2

Поиск
Список
Период
Сортировка
От Patrick B
Тема Re: Wal files - Question | Postgres 9.2
Дата
Msg-id CAJNY3iv-RYkrkNgSgmKNai6Atg5M-B+eFH8toG8LjE3H5DEH1A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Wal files - Question | Postgres 9.2  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения


2016-12-01 14:15 GMT+13:00 David G. Johnston <david.g.johnston@gmail.com>:
On Wed, Nov 30, 2016 at 6:05 PM, Patrick B <patrickbakerbr@gmail.com> wrote:
https://www.postgresql.org/docs/9.2/static/runtime-config-replication.html

wal_keep_segments is the parameter responsible for streaming replication be able to recover itself without using wal_files, is that right?

[...] ​without using wal_files[sic] [from an external archive location]

David J.
​



Yep David! Thanks for correcting me.

Got it now. Thanks everyone.

one more question...  I'm working with wal_keep_segments = 1000 - Would that in your opinion be a safe number?

Yes. I got plenty of free space and I'm using pg_xlogs in a different partition on the master.

Patrick

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Wal files - Question | Postgres 9.2
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Logging for 2 instances of PostgreSQL