Postgres Pro
Downloads
Home   >   mailing lists

Re: temporary file - No Space left on device - Mailing list pgsql-admin

From dbatoCloud Solution
Subject Re: temporary file - No Space left on device
Date
Msg-id CAEz7P_vB_iJfgK0P8e1jJ2KeQriPWA0XLmYphn9i5XA2aficYQ@mail.gmail.com
Whole thread Raw
In response to temporary file - No Space left on device  (dbatoCloud Solution <dbatocloud17@gmail.com>)
Responses Re: temporary file - No Space left on device  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Tree view
Hi All,
Just for your update,  the below temporary file size usage . Please let me know how to reduce this size

image.png

 

 

Thanks & Best Wishes,

Ashok

 

---------------------------------------------------------------------------------------------------------------------

Ashokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UAE | BLR , INDIA

M: +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922

W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com



On Mon, Feb 15, 2021 at 3:14 PM dbatoCloud Solution <dbatocloud17@gmail.com> wrote:

Dear All,


 We have been facing temporary file - no space left issue on postgreSQL 10.13.


Please help

 

Error:touchstone.i131_core_contact_pref_center_unsub_0_9.I131_core_contact_pref_center_unsub - tDBRow_8 ERROR: could not write block 196055 of temporary file: No space left on device
org.postgresql.util.PSQLException: ERROR: could not write block 196055 of temporary file: No space left on device
approx IST time 2021-02-14 06:24:36


The below temporary file current usage#
image.png



Regards,
Ashok

Attachment

pgsql-admin by date:

Previous
From: dbatoCloud Solution
Date:
Subject: temporary file - No Space left on device
Next
From: Ron
Date:
Subject: Re: temporary file - No Space left on device