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: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: FOUTE K(dot) Jaurès <jauresfoute(at)gmail(dot)com>, 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-06-30 20:16:58
Message-ID: 884b6772-c50a-a076-ff4d-b8697f191779@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/30/20 11:03 AM, 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.

From below it looks like you are using pg_logical which is a third
party package. It is what the builtin logical replication is derived
from, but it is not the same thing. So what version of pg_logical are
you using?

>
> 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
>
> Is there someone who faced this problem?
> Any idea how I can solve it ?
>
> BTW: I don't have any problem with space.

The error says you do.
Where is pg_logical/snapshots/ mounted?
Are there specific restrictions on that mount?

>
> Best Regard
>
> --
> Jaurès FOUTE

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2020-06-30 20:23:37 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
Previous Message Donzell White 2020-06-30 18:05:28 Re: Logical Replication Issue