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 - Mailing list pgsql-general

From Adrian Klaver
Subject 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
Date
Msg-id 7602c9ce-3bf6-0e29-658f-e85e7dd68adf@aklaver.com
Whole thread Raw
In response to 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  (FOUTE K. Jaurès <jauresfoute@gmail.com>)
List pgsql-general
On 7/1/20 11:21 AM, FOUTE K. Jaurès wrote:
> 
> 
> Le mer. 1 juil. 2020 à 15:45, Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.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@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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 
> 
> 
> -- 
> Jaurès FOUTE
> Technology Consultant
> ISNOV SARL - Business Technology Consulting
> Tel: +237 79395671 / +237 96248793
> Email: _jauresfoute@gmail.com <mailto:jauresfoute@gmail.com>_,
> jauresmelkiore@yahoo.fr <mailto:jauresmelkiore@yahoo.fr>
> Compte Skype: jauresmelkiore


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: 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
Next
From: FOUTE K. Jaurès
Date:
Subject: 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