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

On Tue, Jun 30, 2020 at 01:16:58PM -0700, Adrian Klaver wrote:
> 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?

I would also look at your kernel log.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EnterpriseDB https://enterprisedb.com

The usefulness of a cup is in its emptiness, Bruce Lee