| From: | Rui DeSousa <rui(at)crazybean(dot)net> |
|---|---|
| To: | Vijaykumar Jain <vjain(at)opentable(dot)com> |
| Cc: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: [External] Re: standby replication server throws invalid memory alloc request size , does not start up |
| Date: | 2018-06-28 14:43:16 |
| Message-ID: | 3B059AC5-D674-4D97-9E28-6B17A3FF73D4@crazybean.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> On Jun 28, 2018, at 9:47 AM, Vijaykumar Jain <vjain(at)opentable(dot)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 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vijaykumar Jain | 2018-06-28 15:18:08 | Re: [External] Re: standby replication server throws invalid memory alloc request size , does not start up |
| Previous Message | Vijaykumar Jain | 2018-06-28 13:47:56 | Re: [External] Re: standby replication server throws invalid memory alloc request size , does not start up |