Postgres Pro
Downloads
Home   >   mailing lists

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 FOUTE K. Jaurès
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 CAHQ1jfcgH_L4CczpGjwZ0YiE19QTBBBva2mT0PAX6AkTdt1SZQ@mail.gmail.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  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses 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
List pgsql-general
Tree view


Le mer. 1 juil. 2020 à 22:15, Adrian Klaver <adrian.klaver@aklaver.com> a écrit :
On 7/1/20 11:21 AM, FOUTE K. Jaurès wrote:
>

>
>     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

What are the permissions on?:

pg_logical/snapshots/

postgres
root@hybride:/var/lib/postgresql/12/main/pg_logical# ll
total 20
drwx------  4 postgres postgres 4096 juil.  1 20:21 ./
drwx------ 19 postgres postgres 4096 juil.  1 20:16 ../
drwx------  2 postgres postgres 4096 mars  31 11:58 mappings/
-rw-------  1 postgres postgres   56 juil.  1 20:21 replorigin_checkpoint
drwx------  2 postgres postgres 4096 mars  31 11:58 snapshots/
 >
>
>
>     --
>     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


--
Jaurès FOUTE 
Technology Consultant
ISNOV SARL - Business Technology Consulting
Tel: +237 79395671 / +237 96248793
Email: jauresfoute@gmail.com, 
          jauresmelkiore@yahoo.fr
Compte Skype: jauresmelkiore

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: Anders Steinlein
Date:
Subject: Different results from identical matviews