|
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?
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. |
BEGIN:VCARD VERSION:2.1 N:Fritz;Erwin;;; ORG:GLJ Petroleum Consultants TITLE:IS Operations Manager EMAIL;PREF;internet:efritz@xxxxxxxxx TEL;VOICE;WORK:+1 (403) 266-9570 TEL;FAX;WORK:+1 (403) 262-1855 ADR;WORK;PREF;ENCODING=QUOTED-PRINTABLE:;;Suite 4100, 400 Third Ave SW;Calgary;Alberta;T2P 4H2;Canada FN:Erwin Fritz REV:20180820T130635Z END:VCARD
