Re: [GENERAL] RemoveIPC problem

2017-08-31 Thread scott ribe
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

Re: [GENERAL] RemoveIPC problem

2017-08-31 Thread Michael Paquier
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

Re: [GENERAL] RemoveIPC problem

2017-08-31 Thread scott ribe
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: > >

Re: [GENERAL] RemoveIPC problem

2017-08-31 Thread Tom Lane
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