From: Johannes Truschnigg <johannes@truschnigg.info>
To: Erwin Fritz <efritz@gljpc.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: temp_file_limit parameter ignored?
Date: Mon, 20 Aug 2018 15:15:35 +0200
Message-ID: <20180820131535.ljrnxgph62ypus2z@vault.lan> (raw)
In-Reply-To: <9E6E27BCA0E8EE478089F158D73AF936A91EB443@Exch10-Mailbox.corp.gljpc.com>
References: <9E6E27BCA0E8EE478089F158D73AF936A91EB443@Exch10-Mailbox.corp.gljpc.com>
Hi Erwin,
On Mon, Aug 20, 2018 at 01:06:33PM +0000, Erwin Fritz wrote:
> [...] Sure enough, when I connect as ‘postgres’ to the database and run
> “show temp_file_limit”, 4GB is the answer.
>
> Is there something obvious I’m missing?
Nothing obvious, afaict - but if you connect to your database, and run
SELECT * FROM pg_settings WHERE name = 'temp_file_limit';
you should be able to see where (which file and line, if any) the setting's
value is read from.
(You might want to switch to "Extended display mode" in psql, issuing "\x"
first, to improve readability.)
Hth!
--
with best regards:
- Johannes Truschnigg ( johannes@truschnigg.info )
www: https://johannes.truschnigg.info/
phone: +43 650 2 133337
xmpp: johannes@truschnigg.info
Please do not bother me with HTML-email or attachments. Thank you.
Attachments:
signature.asc (application/pgp-signature, 832B) download
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-admin@postgresql.org
Cc: johannes@truschnigg.info, efritz@gljpc.com
Subject: Re: temp_file_limit parameter ignored?
In-Reply-To: <20180820131535.ljrnxgph62ypus2z@vault.lan>
* 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