From: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
To: RECHTÉ Marc <marc.rechte@meteo.fr>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Inconsitancies in pg_stat_bgwriter and pg_stat_database returned values
Date: Thu, 17 Sep 2020 09:39:44 +0200
Message-ID: <20200917093944.528c26a3@firost> (raw)
In-Reply-To: <746448376.8762238.1600324690698.JavaMail.zimbra@meteo.fr>
References: <721986302.8509039.1600268805471.JavaMail.zimbra@meteo.fr>
<20200916173124.297baa41@firost>
<746448376.8762238.1600324690698.JavaMail.zimbra@meteo.fr>
On Thu, 17 Sep 2020 08:38:10 +0200 (CEST)
RECHTÉ Marc <marc.rechte@meteo.fr> wrote:
[...]
> The full row are different in your example, not just a few fields. It looks
> like mixed values from different instance.
>
> Could you share some more informations about the context and how to reproduce
> it?
>
> Regards,
>
> Hello
>
> Thanks a lot, you got it right: there are 2 instances on this machine and
> they are both configured with:
>
> stats_temp_directory = '/dev/shm'
>
> We some time ago tried, stats_temp_directory = '/dev/shm/instance', but
> PostgreSQL ignored the subdirectory part and kept creating the temp file at
> the FS root. As this is a temporary FS, one cannot in advance create the
> instance subdirectory as it is wiped out between reboots.
Use "/var/run/postgresql/instance_name" and setup systemd tmpfiles to create
the folder automatically. Eg.:
cat <<EOF > /etc/tmpfiles.d/postgresql-stats.conf
# Directory for PostgreSQL temp stat files
d /var/run/postgresql/stats-instance_name 0700 postgres postgres - -
EOF
You can add as many folders as you need.
To take this file in consideration immediately without rebooting the server,
run the following command:
systemd-tmpfiles --create /etc/tmpfiles.d/postgresql-stats.conf
Regards,
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: jgdr@dalibo.com, marc.rechte@meteo.fr, pgsql-bugs@lists.postgresql.org
Subject: Re: Inconsitancies in pg_stat_bgwriter and pg_stat_database returned values
In-Reply-To: <20200917093944.528c26a3@firost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox