Re: [External] Re: standby replication server throws invalid memoryalloc request size , does not start up

Поиск
Список
Период
Сортировка
От Rui DeSousa
Тема Re: [External] Re: standby replication server throws invalid memoryalloc request size , does not start up
Дата
Msg-id 3B059AC5-D674-4D97-9E28-6B17A3FF73D4@crazybean.net
обсуждение исходный текст
Ответ на Re: [External] Re: standby replication server throws invalid memoryalloc request size , does not start up  (Vijaykumar Jain <vjain@opentable.com>)
Ответы Re: [External] Re: standby replication server throws invalid memoryalloc request size , does not start up  (Vijaykumar Jain <vjain@opentable.com>)
Re: [External] Re: standby replication server throws invalid memoryalloc request size , does not start up  (Andres Freund <andres@anarazel.de>)
Список pgsql-admin

> On Jun 28, 2018, at 9:47 AM, Vijaykumar Jain <vjain@opentable.com> wrote:
>
> Thanks Scott.
>
> fsync is on.
>
> postgres=# show fsync;
> fsync
> -------
> on
> (1 row)
>

Yeah, I agree with Scott; it sounds like fsync() is being shorted somewhere in the I/O path.  Are you using a RAID
controller;if so is the cache setting — write through or write back?  If it’s write back then writes are being cached
anda power outage will lead to data corruption — the only saving grace at that point would be the battery backup logic
onthe controller which may or nay not be trustworthy. 




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

Предыдущее
От: Vijaykumar Jain
Дата:
Сообщение: Re: [External] Re: standby replication server throws invalid memoryalloc request size , does not start up
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: Re: [External] Re: standby replication server throws invalid memoryalloc request size , does not start up