Re: RDS No free space

From: Wilson Coelho <wilson(dot)coelho(at)tecnisys(dot)com(dot)br>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: RDS No free space
Date: 2023-05-22 12:49:11
Message-ID: d2d7a8b5d8dcf6491b9e1d51d7b9229d@tecnisys.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Oliver

You need to check where are the postgres data directory and verify if
there is enough available space on it to the operation you trying to do
over the database.
It seems to be a problem related with a partition scheme and not the DB
per se.
Also take a look at the distribution of your data over the partitions.
If that file is on a partition with no space, try to resize or, move to
other partition

Regards

Wilson Coelho

---

Wilson Moraes Coelho
Especialista

Sia Trecho 08, lotes 245 / 255 / 265 ||

Tel.:+55 (61) 3039-9700 - (61) 99989-8932

71205-080 || Guará || Brasília, DF 0800-6020097

www.tecnisys.com.br [1]

Em 21/05/2023 14:15, Wells Oliver escreveu:

> I am seeing a lot of this morning:
>
> ERROR: could not extend file "base/16411/616989679.62": No space left on devi2023-05-21 17:11:45 UTC::@:[386]:LOG: all server processes terminated; reinitializing
>
> 2023-05-21 17:04:02 UTC:172.31.21.22(55060):woliver(at)db:[31430]:ERROR: could not extend file "base/16411/616989585.45": No space left on device
>
> Etc
>
> However, when I can connect, the DB is well below the provisioned space.
>
> I am trying to figure this out but not sure where to turn yet.
> --
>
> Wells Oliver
> wells(dot)oliver(at)gmail(dot)com

Links:
------
[1] http://www.tecnisys.com.br

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Priancka Chatz 2023-05-22 12:54:10 Re: RDS No free space
Previous Message kaido vaikla 2023-05-22 11:15:15 Re: trigger creation failed