I ran "select pg_reload_conf()" and it returned "t".
Originally, I had edited postgresql.conf, changing the temp_file_limit parameter. After that I did "pg_ctl stop" followed by "pg_ctl start". No errors were reported, but yet the 4GB limit is still reported by "show temp_file_limit".
I then ran this:
psql <db> postgres
alter system set temp_file_limit to -1;
show temp_file_limit;
And it STILL shows 4GB! However, as expected, the postgresql.auto.conf file has the -1 value.
Weird!
-----------------------------
This message is intended only for the recipient(s) to which it is addressed and may contain information that is privileged and confidential. If you have received this message in error, please notify the sender immediately and delete all copies.
-----------------------------
________________________________________
From: Johannes Truschnigg [johannes@xxxxxxxxxxxxxxx]
Sent: August 20, 2018 09:23
To: Erwin Fritz
Cc: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: temp_file_limit parameter ignored?
On Mon, Aug 20, 2018 at 03:09:33PM +0000, Erwin Fritz wrote:
> Hmm. I did that, and the sourcefile and sourceline values are blank. I then
> ran "show config_file" and the result has the correct location of the file.
Hmm. That's strange, because if you properly edited and saved that file,
postgres should at the very least notice the changed reboot value for the
setting. Are you sure you succesfully restarted/reloaded postgresql after your
change?
SELECT pg_reload_conf();
as a superuser role ("postgres" is fine) should do. Make sure to check the
postgresql logs afterwards, since it will contain information on changed
settings and syntax errors/problems (if any)!
Since you're on pg9.5, you could also use the ALTER SYSTEM command to commit
configuration changes, that will have postgres take care of applying and
persisting the changes you make. You should read
https://www.postgresql.org/docs/9.5/static/sql-altersystem.html for more info
on that particular topic/feature.
Hth.
--
with best regards:
- Johannes Truschnigg ( johannes@xxxxxxxxxxxxxxx )
www: https://johannes.truschnigg.info/
phone: +43 650 2 133337
xmpp: johannes@xxxxxxxxxxxxxxx
Please do not bother me with HTML-email or attachments. Thank you.
BEGIN:VCARD
VERSION:2.1
N:Fritz;Erwin;;;
ORG:GLJ Petroleum Consultants
TITLE:IS Operations Manager
EMAIL;PREF;internet:efritz@xxxxxxxxx
TEL;VOICE;WORK:+1 (403) 266-9570
TEL;FAX;WORK:+1 (403) 262-1855
ADR;WORK;PREF;ENCODING=QUOTED-PRINTABLE:;;Suite 4100, 400 Third Ave SW;Calgary;Alberta;T2P 4H2;Canada
FN:Erwin Fritz
REV:20180820T200620Z
END:VCARD
