Re: Postgres and fsync

2018-04-22 Thread Andres Freund
Hi, On 2018-04-23 08:30:25 +1000, Tim Cross wrote: > the recent article in LWN regarding issues with fsync and error > reporting in the Linux kernel and the potential for lost data has > prompted me to ask 2 questions. Note that you need to have *storage* failures for this to happen. I.e. your di

Postgres and fsync

2018-04-22 Thread Tim Cross
Hi all, the recent article in LWN regarding issues with fsync and error reporting in the Linux kernel and the potential for lost data has prompted me to ask 2 questions. 1. Is this issue low level enough that it affects all potentially supported sync methods on Linux? For example, if you were con

Re: Postgresql database encryption

2018-04-22 Thread Vikas Sharma
Thanks a lot for the valuable information and apologies I didn't provide specify that the requirement is to encrypt data at rest and in transit. Regards Vikas On Fri, Apr 20, 2018, 21:56 Vick Khera wrote: > On Fri, Apr 20, 2018 at 11:24 AM, Vikas Sharma wrote: > >> Hello Guys, >> >> Could some