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

Le mer. 1 juil. 2020 à 22:15, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(at)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(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
>

--
Jaurès FOUTE
Technology Consultant
ISNOV SARL - Business Technology Consulting
Tel: +237 79395671 / +237 96248793
Email: *jauresfoute(at)gmail(dot)com <jauresfoute(at)gmail(dot)com>*,
jauresmelkiore(at)yahoo(dot)fr
Compte Skype: jauresmelkiore