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

From: FOUTE K(dot) Jaurès <jauresfoute(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-general(at)lists(dot)postgresql(dot)org
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: 2020-07-01 18:21:58
Message-ID: CAHQ1jfdsEJY=fx9bto6uGKra9n3_JDzUY5ZJYGnD8GjZZcHZWw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le mer. 1 juil. 2020 à 15:45, Adrian Klaver <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

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2020-07-01 18:25:34 Re: Can't seem to mix an inner and outer join in a query and get it to work right.
Previous Message David Gauthier 2020-07-01 16:50:49 Re: Can't seem to mix an inner and outer join in a query and get it to work right.