From: Wilson Coelho <wilson.coelho@tecnisys.com.br>
To: Wells Oliver <wells.oliver@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: RDS No free space
Date: Mon, 22 May 2023 09:49:11 -0300
Message-ID: <d2d7a8b5d8dcf6491b9e1d51d7b9229d@tecnisys.com.br> (raw)
In-Reply-To: <CAOC+FBU-1aB8+ivHe+nttSiM08QsaJH=t7_rDHb7YNTwhmkf9Q@mail.gmail.com>
References: <CAOC+FBU-1aB8+ivHe+nttSiM08QsaJH=t7_rDHb7YNTwhmkf9Q@mail.gmail.com>
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@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.oliver@gmail.com
Links:
------
[1] http://www.tecnisys.com.brAttachments:
[image/gif] f62593aa.gif (43B, ../d2d7a8b5d8dcf6491b9e1d51d7b9229d@tecnisys.com.br/3-f62593aa.gif)
download | view image
[image/gif] 04237a95.gif (3.1K, ../d2d7a8b5d8dcf6491b9e1d51d7b9229d@tecnisys.com.br/4-04237a95.gif)
download | view image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: wilson.coelho@tecnisys.com.br, wells.oliver@gmail.com
Subject: Re: RDS No free space
In-Reply-To: <d2d7a8b5d8dcf6491b9e1d51d7b9229d@tecnisys.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox