Date: Mon, 20 Aug 2018 15:15:35 +0200
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?
Message-ID: <20180820131535.ljrnxgph62ypus2z@vault.lan>
References: 
 <9E6E27BCA0E8EE478089F158D73AF936A91EB443@Exch10-Mailbox.corp.gljpc.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="4ji76lunbnicc5d4"
Content-Disposition: inline
In-Reply-To: 
 <9E6E27BCA0E8EE478089F158D73AF936A91EB443@Exch10-Mailbox.corp.gljpc.com>
User-Agent: NeoMutt/20170113 (1.7.2)
Precedence: bulk


--4ji76lunbnicc5d4
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi Erwin,

On Mon, Aug 20, 2018 at 01:06:33PM +0000, Erwin Fritz wrote:
> [...] Sure enough, when I connect as =E2=80=98postgres=E2=80=99 to the da=
tabase and run
> =E2=80=9Cshow temp_file_limit=E2=80=9D, 4GB is the answer.
>=20
> Is there something obvious I=E2=80=99m missing?

Nothing obvious, afaict - but if you connect to your database, and run

  SELECT * FROM pg_settings WHERE name =3D '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!

--=20
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.

--4ji76lunbnicc5d4
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEGu9IhkI+7/aKLUWF95W3jMsYfLUFAlt6vvQACgkQ95W3jMsY
fLVTORAAjJOVIF8b3OQFx0WOk3q1dFX1/yreEn0+1gVrc+VyWfx9Cphj0b0/z0Xx
13NaFtQZirHEP17TTwisqtWgh1QK8yrMF0Dgg0xCLkflxwRQAVc6+lkC22A7HrO8
tP7BiR+lSatrqgTqwWdR03fm0ndjFQPp79pDM5UMC7EoMd7GCU75eqsL3Hv6eygp
SCeGgVpnjqIPdHunEkTb2ArbyNifVCx6MVAcVC0CMuydnmm/AlCa8dl0wdyXqvfM
h5LU+QfH4qOOBBQRJHNGf/x7AhnFz/4KTZs2jqa9a7+6PWjjEiHQU7hRbUdutNdB
XxaKrDIH2qexYivN5iBm49hSeDPGcf+c46m9/NPDHhzEeMHagFrwYdQILsZFskWn
4dx/Jk1ccskIdXFALF9ZwlP1oX62gW5P7mFExrZXiImKNuM9yCaBIW+EQRGe79t0
V+lUP9Zg6Wtg73NQej7zxoDLSTTi0hMx/YsNFOZGBW9wd19xCf0EVzJdUXcDJ7yg
4Db2uGy0UfUpWqdtPeMZO1hRL9Z6g8Cr6kyEVBWXq1UGL0IYRQbdVPUCe4tWb3V+
cq3HiEa1rlgNWTzRjhyAntX5WcdZKEOl4b3iZzTgmBtW46YfssLI2T3DdyzZ7hlt
3GU+wajcQ6Je3ytDN9s89H5aZBVXbiJHHTPTxwn2BobXvFS49+U=
=hKlN
-----END PGP SIGNATURE-----

--4ji76lunbnicc5d4--