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 - Mailing list pgsql-general

From FOUTE K. Jaurès
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
Msg-id CAHQ1jffzVBP3gG169XUbsBiaawqBTntPV_eDoEyVnr35keX6FQ@mail.gmail.com
Whole thread Raw
In response to 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@gmail.com>)
Responses 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  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general


Le mar. 30 juin 2020 à 21:23, Bruce Momjian <bruce@momjian.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.png
 

I would also look at your kernel log.

--
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

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



--
Jaurès FOUTE 
Attachment

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
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
Next
From: Rene de Gek
Date:
Subject: Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBC or JDBC