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)
Список
Дерево обсуждения
standby replication server throws invalid memory alloc request size ,does not start up Vijaykumar Jain <vjain@opentable.com>
Re: standby replication server throws invalid memory alloc requestsize , does not start up Andres Freund <andres@anarazel.de>
Re: standby replication server throws invalid memory alloc requestsize , does not start up Scott Ribe <scott_ribe@elevated-dev.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 Rui DeSousa <rui@crazybean.net>
Re: [External] Re: standby replication server throws invalid memoryalloc request size , does not start up Andres Freund <andres@anarazel.de>
Re: [External] standby replication server throws invalid memory allocrequest size , does not start up Rui DeSousa <rui@crazybean.net>
Re: [External] Re: standby replication server throws invalid memoryalloc request size , does not start up Scott Ribe <scott_ribe@elevated-dev.com>
Re: [External] Re: standby replication server throws invalid memoryalloc request size , does not start up Andres Freund <andres@anarazel.de>
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>
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: standby replication server throws invalid memory alloc requestsize , does not start up Scott Ribe <scott_ribe@elevated-dev.com>
> On Jun 28, 2018, at 9:47 AM, Vijaykumar Jain 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 and a power outage will lead to data corruption — the only saving grace at that point would be the battery backup logic on the controller which may or nay not be trustworthy.
В списке pgsql-admin по дате отправления
От: Vijaykumar Jain
Дата:
От: Vijaykumar Jain
Дата: