Re: spurious /dev/shm related errors on insert

On Fri, 2016-03-18 at 10:45 -0400, Michael Charnoky wrote:
> I should have noted: the application is using PostgreSQL 9.5.0,
> running on Ubuntu 14.04
>
> Mike
>
> On Fri, Mar 18, 2016 at 10:41 AM, Michael Charnoky <noky(at)noky(dot)net>
> wrote:
> > Hi, I'm seeing random errors from an application that is performing
> > DB inserts. The error happens spuriously and looks like this from
> > the application side:
> >
> > could not open file "/dev/shm/postgres_apptable_47861701461760" for
> > reading: No such file or directory
> >
> > The PostgreSQL logs show:
> >
> > 2016-03-18 07:25:01 UTC ERROR:  could not open file
> > "/dev/shm/postgres_apptable_47861701461760" for reading: No such
> > file or directory
> > 2016-03-18 07:25:01 UTC STATEMENT:  COPY urltable FROM
> > '/dev/shm/postgres_apptable_47861701461760' USING DELIMITERS '#'
> > WITH NULL AS '\null';
> >
> > Any clues? I couldn't find any similar issues reported by other
> > users. Thanks!
> >
> > Mike
> >
> >

Running 9.5.1 installed from Debian packages, when Postgres is started
it creates this file in /dev/shm

-rw------- 1 postgres postgres 2316 Mar 19 05:24 PostgreSQL.1804289383

It's binary.

Bye.