title: Aurora PostgreSQL engine: no space left on device
body: <p>I am working with the AWS Aurora PostgreSQL 10.4 engine.  I am trying to <code>cluster table ... using index</code> and getting an error like</p>
  
  <pre><code>could not write block .... of temporary file: no space left on device
  </code></pre>
  
  <p>If I were managing my own PostgreSQL instance I would be looking at the space available on individual volumes with <code>df</code>.  (See also: <a href="https://stackoverflow.com/questions/23227695/i-get-an-error-could-not-write-block-of-temporary-file-no-space-left-on-de">I get an error &quot;could not write block .... of temporary file no space left on device ...&quot; using postgresql</a>) </p>
  
  <p>But with Aurora, AWS should be managing the storage and automatically expanding it on demand.  So I'm wondering how I would go about fixing this condition if I'm not managing the storage myself.  I'm guessing that that the PG engine's temp storage is separate from the Aurora-managed virtualized storage layer, but not sure how to change it. </p>