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

Поиск
Список
Период
Сортировка
От naveen goswami
Тема Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB
Дата
Msg-id CAAZkPyKesD8xE0J9NNFBsNTuLTe2iKhUyM+SAiuAHxL0x7-CiQ@mail.gmail.com
обсуждение исходный текст
Ответ на could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB  (dbatoCloud Solution <dbatocloud17@gmail.com>)
Ответы Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB  (dbatoCloud Solution <dbatocloud17@gmail.com>)
Список 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.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 по дате отправления:

Предыдущее
От: Michael Banck
Дата:
Сообщение: Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB
Следующее
От: dbatoCloud Solution
Дата:
Сообщение: Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB