Re: [GENERAL] pg_stat_tmp and pg_upgrade

2017-10-02 Thread Bruce Momjian
On Thu, Sep 28, 2017 at 08:02:44AM -0700, kbran...@pwhome.com wrote: > With Pg10.0 coming, I have a question about pg_stat_tmp and upgrades that I'm > hoping I can get some advice on. > > Historically, we've created a tmpfs "disk" and mounted it on > $PGDATA/pg_stat_tmp and then started Pg. For

[GENERAL] pg_stat_tmp and pg_upgrade

2017-09-28 Thread
With Pg10.0 coming, I have a question about pg_stat_tmp and upgrades that I'm hoping I can get some advice on. Historically, we've created a tmpfs "disk" and mounted it on $PGDATA/pg_stat_tmp and then started Pg. For most situations, this works well. However, we have one situation where it does

Re: [GENERAL] pg_stat_tmp

2013-12-17 Thread Jeff Janes
On Tue, Dec 17, 2013 at 3:25 AM, Tim Kane wrote: > > Thanks Jeff, Magnus > > Thanks for the suggestions. > This morning the same issue occurred, but this time it also complained > that it failed to write to pg_clog (previous days, the only failure was in > writing to pg_stat_tmp) > > ... > 201

Re: [GENERAL] pg_stat_tmp

2013-12-17 Thread Tim Kane
Are these truly orphaned files that postgresql no longer needs (possibly due to a crash) ?Is there a mechanism to scan the PG_DATA directories to locate such files? FYI, we’re running 9.2.4 Thanks again, Tim From: Jeff Janes Date: Monday, 16 December 2013 17:32 To: Tim Kane Cc: pgs

Re: [GENERAL] pg_stat_tmp

2013-12-16 Thread Jeff Janes
On Mon, Dec 16, 2013 at 5:57 AM, Tim Kane wrote: > Hi all, > > The past few days I’ve been encountering the following error, followed by > a full db restart and recovery > > > 2013-12-16 07:12:53 GMT LOG: could not write temporary statistics file > "pg_stat_tmp/pgstat.tmp": No space left on devi

Re: [GENERAL] pg_stat_tmp

2013-12-16 Thread Magnus Hagander
On Mon, Dec 16, 2013 at 2:57 PM, Tim Kane wrote: > Hi all, > > The past few days I’ve been encountering the following error, followed by > a full db restart and recovery > > > 2013-12-16 07:12:53 GMT LOG: could not write temporary statistics file > "pg_stat_tmp/pgstat.tmp": No space left on devi

[GENERAL] pg_stat_tmp

2013-12-16 Thread Tim Kane
Hi all, The past few days I’ve been encountering the following error, followed by a full db restart and recovery 2013-12-16 07:12:53 GMT LOG: could not write temporary statistics file "pg_stat_tmp/pgstat.tmp": No space left on device This occurs at a time of moderate load, during the same set