Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB

From: naveen goswami <rilogical(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB
Date: 2021-02-02 02:27:07
Message-ID: CAAZkPyKesD8xE0J9NNFBsNTuLTe2iKhUyM+SAiuAHxL0x7-CiQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Another option if you cannot change the workload, Free Local storage
(temporary files storage), is twice the size of RAM of your Aurora
instance. e.g. r5.db24xlarge will provide 1500GB of free local storage. not
sure if its possible, but higher instance size may help but that comes with
higher cost.

On Mon, Feb 1, 2021 at 6:11 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> On Mon, 2021-02-01 at 19:27 +0530, dbatoCloud Solution wrote:
> > Is there any way to reduce the temporary files which are having huge
> size .
>
> Cancel the queries that generate them.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message dbatoCloud Solution 2021-02-02 08:57:37 Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB
Previous Message Laurenz Albe 2021-02-01 14:11:18 Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB