Re: standby replication server throws invalid memory alloc requestsize , does not start up - Mailing list pgsql-admin

From Scott Ribe
Subject Re: standby replication server throws invalid memory alloc requestsize , does not start up
Date
Msg-id 8F8408A0-7FEB-4F32-8E76-F7429DA0B481@elevated-dev.com
Whole thread Raw
In response to standby replication server throws invalid memory alloc request size ,does not start up  (Vijaykumar Jain <vjain@opentable.com>)
Responses 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>)
List pgsql-admin
You need to worry, very much, that your setup did not preserve data write ordering when the power went out.

- you might have fsync turned off in PG
- you might be using a non-journaled filesystem
- your disks might be cheating on sync commands (consumer grade disks are notorious for this)
- you might be using consumer-grade flash that can't flush its cache on power loss

This highly unlikely to be a PG bug, and you do need to worry that it could have been the master if you had been less
lucky.

--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/



> On Jun 28, 2018, at 7:17 AM, Vijaykumar Jain <vjain@opentable.com> wrote:
>
> My only concern was do I need to worry about this error showing up again?



pgsql-admin by date:

Previous
From: Vijaykumar Jain
Date:
Subject: standby replication server throws invalid memory alloc request size ,does not start up
Next
From: Scott Ribe
Date:
Subject: Re: standby replication server throws invalid memory alloc requestsize , does not start up