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

Le mar. 30 juin 2020 à 21:23, Bruce Momjian <bruce(at)momjian(dot)us> a écrit :

> 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?
>
I only install Postgresql 12. I dont use pg_logical

> >
> > >
> > > 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?
>
/var/lib/postgresql/12/main/pg_logical (default location)

> > Are there specific restrictions on that mount?
>
[image: image.png]

>
> 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
>
>

--
Jaurès FOUTE