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"
followedby "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
privilegedand confidential. If you have received this message in error, please notify the sender immediately and delete
allcopies.
-----------------------------
________________________________________
From: Johannes Truschnigg [johannes@truschnigg.info]
Sent: August 20, 2018 09:23
To: Erwin Fritz
Cc: pgsql-admin@postgresql.org
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@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.
