temp_file_limit parameter ignored?

From: Erwin Fritz <efritz(at)gljpc(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: temp_file_limit parameter ignored?
Date: 2018-08-20 13:06:33
Message-ID: 9E6E27BCA0E8EE478089F158D73AF936A91EB443@Exch10-Mailbox.corp.gljpc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello, all.

I’m an experienced Oracle DBA who’s converting to PostgreSQL, so please be kind.

I’m running the 64-bit PostgreSQL 9.5 on Ubuntu 16.04. I’m trying to index some large tables, so I set temp_file_limit to -1 in postgresql.conf and restarted the server. My index creation calls consistently failed with “temporary file size exceeds temp_file_limit (4194304kB)”. Sure enough, when I connect as ‘postgres’ to the database and run “show temp_file_limit”, 4GB is the answer.

Is there something obvious I’m missing?

Erwin Fritz
IS Operations Manager
GLJ Petroleum Consultants
Tel: +1 (403) 266-9570

________________________________

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.

________________________________

Attachment Content-Type Size
Erwin Fritz.vcf text/x-vcard 359 bytes

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Johannes Truschnigg 2018-08-20 13:15:35 Re: temp_file_limit parameter ignored?
Previous Message Stéphane Dunand 2018-08-20 13:02:39 Re: Setting up SSL for postgre