From: | Jerry Sievers <gsievers19(at)comcast(dot)net> |
---|---|
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" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: temp_file_limit parameter ignored? |
Date: | 2018-08-20 20:44:02 |
Message-ID: | 87k1okg44t.fsf@jsievers.enova.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jerry Sievers | 2018-08-20 20:57:41 | Re: temp_file_limit parameter ignored? |
Previous Message | David Steele | 2018-08-20 20:10:33 | Re: pgbackrest: backup from standby |