Yeah, that was me. I now understand the relationship between "set database/system", postgresql.auto.conf, and postgresql.conf much better than I did before. Thanks! Erwin > -----Original Message----- > From: Jerry Sievers <gsievers19@xxxxxxxxxxx> > Sent: Monday, August 20, 2018 14:44 > To: Erwin Fritz <efritz@xxxxxxxxx> > Cc: Tom Lane <tgl@xxxxxxxxxxxxx>; Johannes Truschnigg > <johannes@xxxxxxxxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: temp_file_limit parameter ignored? > > Erwin Fritz <efritz@xxxxxxxxx> writes: > > > Here's the output: > > > > select * from pg_settings where name = 'temp_file_limit'; > > -[ RECORD 1 ]---+------------------------------------------------------------------- > > name | temp_file_limit > > setting | 4194304 > > unit | kB > > category | Resource Usage / Disk > > short_desc | Limits the total size of all temporary files used by each > session. > > extra_desc | -1 means no limit. > > context | superuser > > vartype | integer > > source | database > > ^^^^^ > > This means someone/thing said... > > ALTER DATABASE $foodb SET temp_file_limit to '$whatever'; > > See psql \drds. > > Just do an explicit override in your own job prior to the code that > errors out due to resource shortfall. > > SET temp_file_limit to -1; > > HTH > > > > min_val | -1 > > max_val | 2147483647 > > enumvals | > > boot_val | -1 > > reset_val | 4194304 > > sourcefile | > > sourceline | > > pending_restart | f > > > > > > > > > > ----------------------------- > > 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: Tom Lane [tgl@xxxxxxxxxxxxx] > > Sent: August 20, 2018 09:26 > > To: Erwin Fritz > > Cc: Johannes Truschnigg; pgsql-admin@xxxxxxxxxxxxxx > > Subject: Re: temp_file_limit parameter ignored? > > > > Erwin Fritz <efritz@xxxxxxxxx> writes: > >> 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. > > > > What does the "source" column say? > > > > regards, tom lane > > > > > > -- > Jerry Sievers > Postgres DBA/Development Consulting > e: postgres.consulting@xxxxxxxxxxx > p: 312.241.7800
