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
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
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
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
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
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
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