Re: [BUGS] BUG #14594: postgres dies with fatal error

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] BUG #14594: postgres dies with fatal error
Дата
Msg-id 31585.1490108576@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [BUGS] BUG #14594: postgres dies with fatal error  (gnareshdba@gmail.com)
Список pgsql-bugs
gnareshdba@gmail.com writes:
> Operating system:   RHEL 7.2

> postgresql (9.4.5) instance restarts with below error during backup times

> 2017-03-19 19:00:21 EDT PANIC: semop(id=152698887) failed: Invalid argument

You need to prevent systemd from deleting Postgres' semaphores.
See the discussion of RemoveIPC here:

https://wiki.postgresql.org/wiki/Systemd

> on RHEL 7.2, and UID set to (id -u postgres) 2011

That's not the UID typically used on RHEL for Postgres, which is probably
why systemd doesn't know to exempt it from RemoveIPC.

            regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: [BUGS] BUG #14594: postgres dies with fatal error
Следующее
От: gnareshdba@gmail.com
Дата:
Сообщение: [BUGS] BUG #14595: postgres dies with fatal error