Re: WAL retention

Поиск
Список
Период
Сортировка
От Slavcho Trnkovski
Тема Re: WAL retention
Дата
Msg-id CACwHmfGiEDE4kTR+uAeBQThw0aOft4wkNVHXp6xu5cfEbMJHzQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: WAL retention  (Bert <biertie@gmail.com>)
Ответы Re: WAL retention
Список pgsql-admin
Дерево обсуждения
Hi,

I use version 9.4. 
If I create physical replication slot, I'll need standby server to use it. I can use pg_receivexlog but it will not prevent removing WAL files, it will just stream it to some other location.
Do you maybe have an idea how backup can use replication slot (without standby)?

Regards,
Slavcho

On Mon, Jun 20, 2016 at 3:52 PM, Bert <biertie@gmail.com> wrote:
Hello,

Which version of PostgreSQL are you using?
If you are using version 9.4 or newer you can use the concept of 'replication slots' to block the removal or archiving of WAL files.
But do not forgot to remove the slot again, else PostgreSQL will never remove the wall files again!

Bert

On Mon, Jun 20, 2016 at 10:38 AM, Slavcho Trnkovski <strnkovski@gmail.com> wrote:
Hi Guys,

Is there a way to set retention policy for removing WAL files in hours/days instead of number of WAL files (wal_keep_segments)?

I have a problem when backup is running, it complains that some files are missing. The problem is that i have situation when data load is running and a lot of WAL files are generated.

Regards,
Slavcho




--
Bert Desmet
0477/305361

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Too many Open files error for postgres
Следующее
От: Keith
Дата:
Сообщение: Re: WAL retention