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

[FOUTE K. Jaurès <jauresfoute@xxxxxxxxx>]

Le mer. 1 juil. 2020 à 17:11, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx> a écrit :

On 2020-Jun-30, FOUTE K. Jaurčs wrote:

> Hi everyone,
>
> I am use a native logical replication in PostgreSQL 12 on Ubuntu 16.04 and
> all is working fine until i faced this error below.
>
> 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

What are your fsync and wal_sync_method settings?

All the two setting are commented  

#fsync = on

#wal_sync_method = fsync

 

--
Įlvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

--

Jaurès FOUTE 
Technology Consultant

ISNOV SARL - Business Technology Consulting
Tel: +237 79395671 / +237 96248793
Email: jauresfoute@xxxxxxxxx, 

          jauresmelkiore@xxxxxxxx
Compte Skype: jauresmelkiore