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 |
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 |