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]

On 7/1/20 11:21 AM, FOUTE K. Jaurès wrote:

Le mer. 1 juil. 2020 à 15:45, Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>



--
Jaurès FOUTE
Technology Consultant
ISNOV SARL - Business Technology Consulting
Tel: +237 79395671 / +237 96248793
Email: _jauresfo...@gmail.com <mailto:jauresfo...@gmail.com>_,
jauresmelki...@yahoo.fr <mailto:jauresmelki...@yahoo.fr>
Compte Skype: jauresmelkiore

--
Adrian Klaver
adrian.kla...@aklaver.com