Re: pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed: Identifier removed

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed: Identifier removed
Дата
Msg-id 5549.1539063826@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641)failed: Identifier removed  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
Список pgsql-general
Raghavendra Rao J S V <raghavendrajsv@gmail.com> writes:
> Receiving below error while taking the backup using pg_dump. Please help me
> why and how to resolve this.

> pg_dump: [archiver (db)] query failed: FATAL:  semop(id=10649641) failed:
> Identifier removed

Are you running on a platform that uses systemd?  If so, see

https://www.postgresql.org/docs/current/static/kernel-resources.html#SYSTEMD-REMOVEIPC

If it's not systemd, I'd still say that something kneecapped your PG
server by removing its semaphores.  Restarting the postmaster will
clear the problem transiently, but do nothing to prevent a recurrence.

            regards, tom lane



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

Предыдущее
От: Raghavendra Rao J S V
Дата:
Сообщение: pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641)failed: Identifier removed
Следующее
От: magodo
Дата:
Сообщение: Re: pg9.6: no backup history file (*.backup) created on hot standby