RE: temp_file_limit parameter ignored?

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(at)comcast(dot)net>
> Sent: Monday, August 20, 2018 14:44
> To: Erwin Fritz <efritz(at)gljpc(dot)com>
> Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>; Johannes Truschnigg
> <johannes(at)truschnigg(dot)info>; pgsql-admin(at)postgresql(dot)org
> Subject: Re: temp_file_limit parameter ignored?
>
> Erwin Fritz <efritz(at)gljpc(dot)com> 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(at)sss(dot)pgh(dot)pa(dot)us]
> > Sent: August 20, 2018 09:26
> > To: Erwin Fritz
> > Cc: Johannes Truschnigg; pgsql-admin(at)postgresql(dot)org
> > Subject: Re: temp_file_limit parameter ignored?
> >
> > Erwin Fritz <efritz(at)gljpc(dot)com> 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(dot)consulting(at)comcast(dot)net
> p: 312.241.7800