Re: System crashed: fatal error restarting postgres - Mailing list pgsql-general

From Tom Lane
Subject Re: System crashed: fatal error restarting postgres
Date
Msg-id 12471.1475267000@sss.pgh.pa.us
Whole thread Raw
In response to System crashed: fatal error restarting postgres  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: System crashed: fatal error restarting postgres  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Rich Shepard <rshepard@appl-ecosys.com> writes:
>    A java application threw a major error when closing and it crashed my
> system (including wiping out most of /tmp). After rebooting I su'd to user
> postgres and tried to start postgresql-9.5.4, but this error displays:

> postgres@salmo:~$ FATAL:  could not open shared memory segment
> "/PostgreSQL.1804289383": Permission denied

Wrong permissions on /dev/shm, perhaps?  On Linux I believe it should
always be

drwxrwxrwt. 2 root root 160 Sep 30 15:23 /dev/shm/

Although TBH, the first question you should be asking yourself is why
you're running *any* java application with root privileges, which is
what I think would be needed to let this happen.

            regards, tom lane


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [ANNOUNCE] pgAdmin 4 v1.0 Released!
Next
From: Adrian Klaver
Date:
Subject: Re: isnull() function in pgAdmin3