Search Postgresql Archives

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 Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 7/1/20 2:21 PM, FOUTE K. Jaurès wrote:


Le mer. 1 juil. 2020 à 22:15, Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> 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/


Well replication is between two instances, so are you sure you are looking at the correct data directory?



--
Jaurès FOUTE
Technology Consultant
ISNOV SARL - Business Technology Consulting
Tel: +237 79395671 / +237 96248793
Email: _jauresfoute@xxxxxxxxx <mailto:jauresfoute@xxxxxxxxx>_,
jauresmelkiore@xxxxxxxx <mailto:jauresmelkiore@xxxxxxxx>
Compte Skype: jauresmelkiore


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux