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 <n...@noky.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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
