Re: PSQLException: ERROR: could not write to hash-join temporary file: No space left on device

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: PSQLException: ERROR: could not write to hash-join temporary file: No space left on device
Date: 2019-11-12 22:03:12
Message-ID: 1573596192903-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

and two additionnal idea:
- check logs to find the initial SQL statement(s) that failed,
- restart the cluster to free all that space

Regards
PAscal

--
Sent from: https://www.postgresql-archive.org/PostgreSQL-novice-f2132464.html

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Stephen Froehlich 2019-11-13 00:53:20 RE: PSQLException: ERROR: could not write to hash-join temporary file: No space left on device
Previous Message legrand legrand 2019-11-12 21:59:19 Re: PSQLException: ERROR: could not write to hash-join temporary file: No space left on device