Postgres Pro
Downloads
Home   >   mailing lists

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

From naveen goswami
Subject Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB
Date
Msg-id CAAZkPyKesD8xE0J9NNFBsNTuLTe2iKhUyM+SAiuAHxL0x7-CiQ@mail.gmail.com
Whole thread Raw
In response to could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB  (dbatoCloud Solution <dbatocloud17@gmail.com>)
Responses Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB  (dbatoCloud Solution <dbatocloud17@gmail.com>)
List pgsql-admin
Tree view
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.albe@cybertec.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



pgsql-admin by date:

Previous
From: Michael Banck
Date:
Subject: Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB
Next
From: dbatoCloud Solution
Date:
Subject: Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB