Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device

On 7/1/20 11:21 AM, FOUTE K. Jaurès wrote:
>
>
> Le mer. 1 juil. 2020 à 15:45, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> a écrit :
>
> On 6/30/20 10:51 PM, FOUTE K. Jaurès wrote:
> >
> >
>
> >
> >       From /var/lib/postgresql/12/main/pg_logical what does du
> -sh  show?
> >     Please show results as text, you can copy from terminal screen.
> >
> > root(at)hybride:/var/lib/postgresql/12/main/pg_logical# du -sh
> > 16K .
> >
>
> Has the problem occurred again?
>
> Yes
> 2020-07-01 19: 19: 21.868 WAT [24204] ERROR: could not receive data from
> WAL stream: ERROR: could not rename file "pg_logical / snapshots /
> 1E-8567EB0.snap.22195.tmp" to "pg_logical / snapshots /
> 1E-8567EB0.snap": No space left on device

Also look in system log for any events around 2020-07-01 19: 19

>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>
>
> --
> Jaurès FOUTE
> Technology Consultant
> ISNOV SARL - Business Technology Consulting
> Tel: +237 79395671 / +237 96248793
> Email: _jauresfoute(at)gmail(dot)com <mailto:jauresfoute(at)gmail(dot)com>_,
> jauresmelkiore(at)yahoo(dot)fr <mailto:jauresmelkiore(at)yahoo(dot)fr>
> Compte Skype: jauresmelkiore

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com