Re: Wal keep segment

Поиск
Список
Период
Сортировка
От John Scalia
Тема Re: Wal keep segment
Дата
Msg-id 675BEC19-1A77-4DFC-88DB-42982FA6E922@gmail.com
обсуждение исходный текст
Ответ на Wal keep segment  (Raj kumar <rajkumar820999@gmail.com>)
Ответы Re: Wal keep segment
Список pgsql-admin
Wal_keep_segments is a MINIMUM setting value, meaning the database is guaranteed to keep at least that many WAL
segments.If you have replication setup and it’s fallen behind or broken, then WAL segments can rapidly accumulate on a
fairlybusy server. I suspect without having your details that something of this nature is occurring. 
—
Jay

Sent from my iPad

> On Apr 25, 2020, at 8:09 AM, Raj kumar <rajkumar820999@gmail.com> wrote:
>
> 
> Hi,
>
> I have "wal_keep_segment" set as 256.
> But I could see that around 700 files are present inside pg_wal directory.
>
> I thought after reaching 256, wal writer will start overwriting from 1st.
>
> What is the upper limit of these number of wal files in the directory?
>
> Thanks and regards
> Raj kumar



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

Предыдущее
От: Raj kumar
Дата:
Сообщение: Wal keep segment
Следующее
От: Raj kumar
Дата:
Сообщение: Startup process in slave