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 CAHQ1jffWPXiSUQ6W_SFAeNLr1q2W8_3XZ2=_EioPdCbTqwmPtw@mail.gmail.com
Whole thread Raw
In response to 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>)
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
List pgsql-general


Le mar. 30 juin 2020 à 22:36, Adrian Klaver <adrian.klaver@aklaver.com> a écrit :
On 6/30/20 1:47 PM, FOUTE K. Jaurès wrote:
>
>
> Le mar. 30 juin 2020 à 21:23, Bruce Momjian <bruce@momjian.us
> <mailto: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

My mistake, I remembered the location for the logical files wrong.


>
> /var/lib/postgresql/12/main/pg_logical (default location)

 From /var/lib/postgresql/12/main/pg_logical what does du -sh  show?
Please show results as text, you can copy from terminal screen.
root@hybride:/var/lib/postgresql/12/main/pg_logical# du -sh
16K .

 


>
>      > Are there specific restrictions on that mount?
>
> image.png
>
>
>     I would also look at your kernel log.
>
>     --
>        Bruce Momjian  <bruce@momjian.us <mailto:bruce@momjian.us>>
>     https://momjian.us
>        EnterpriseDB https://enterprisedb.com
>
>        The usefulness of a cup is in its emptiness, Bruce Lee
>
>
>
> --
> Jaurès FOUTE


--
Adrian Klaver
adrian.klaver@aklaver.com


--
Jaurès FOUTE 
Technology Consultant
ISNOV SARL - Business Technology Consulting
Tel: +237 79395671 / +237 96248793
Email: jauresfoute@gmail.com
          jauresmelkiore@yahoo.fr
Compte Skype: jauresmelkiore

pgsql-general by date:

Previous
From: Radoslav Nedyalkov
Date:
Subject: Re: restart_lsn is not advancing
Next
From: FOUTE K. Jaurès
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