WARM standby with pg_standby

Поиск
Список
Период
Сортировка
От Dennis Thrysøe
Тема WARM standby with pg_standby
Дата
Msg-id 1A57E5A7-AEB8-412B-B3A7-D52768F2FCF7@geysirit.dk
обсуждение исходный текст
Ответы Re: WARM standby with pg_standby  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin
Hi,

I have a few elaborating questions in regard to setting up Warm Standby.

1) The master keeps writing WAL files even though I'm quite sure nothing is happening. This seems like a large waste of
diskspace?

2) Sometimes my slave does not read and delete WAL files when in recovery mode. This will eventually fill up the disk.

pg_controldata gives me:

Minimum recovery ending location:     0/0

What does that mean?

Is there any good ways of troubleshooting the behaviour, and finding out precisely what state the slave is in, etc.?

Thanks,

--
Geysir IT
dth@geysirit.dk
http://geysirit.dk
+45 31 51 60 00


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

Предыдущее
От: Jonathan Foy
Дата:
Сообщение: Re: PD_ALL_VISIBLE flag warning
Следующее
От: Eduardo Sá dos Reis
Дата:
Сообщение: How to block access to a scheme