Yeah, not my style. fsync is on, no caching RAID controller, etc. Thanks.
> On Aug 31, 2017, at 9:48 PM, Michael Paquier
> wrote:
>
> As long as you don't run Postgres on scissors with things like fsync =
> off or full_page_writes = off, there should be no risk with the data
> consistency.
--
On Fri, Sep 1, 2017 at 12:10 PM, scott ribe wrote:
> Yeah, I was kind of thinking that PG detects the semaphore not existing,
> bails immediately, restarts clean, thus no problem. I just wanted to hear
> from people, like you, that know way more than I do about the internals.
As long as you don
Yeah, I was kind of thinking that PG detects the semaphore not existing, bails
immediately, restarts clean, thus no problem. I just wanted to hear from
people, like you, that know way more than I do about the internals.
> On Aug 31, 2017, at 9:08 PM, Tom Lane wrote:
>
> scott ribe writes:
>>
scott ribe writes:
> Thanks to a typo, I did not turn off systemd's RemoveIPC, and had many many
> pg restarts before I figured out the problem.
> Should my data be OK? Or do I need to dump & reload?
I don't know of any reason to think that that poses a data corruption
risk. (But I've been wro
Thanks to a typo, I did not turn off systemd's RemoveIPC, and had many many pg
restarts before I figured out the problem.
Should my data be OK? Or do I need to dump & reload?
--
Scott Ribe
scott_r...@elevated-dev.com
(303) 722-0567
--
Sent via pgsql-general mailing list (pgsql-general@postgr