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 à 22:36, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(at)momjian(dot)us
> > <mailto: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
>
> 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(at)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(at)momjian(dot)us <mailto: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
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

--
Jaurès FOUTE
Technology Consultant
ISNOV SARL - Business Technology Consulting
Tel: +237 79395671 / +237 96248793
Email: *jauresfoute(at)gmail(dot)com <jauresfoute(at)gmail(dot)com>*,
jauresmelkiore(at)yahoo(dot)fr
Compte Skype: jauresmelkiore