From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | FOUTE K(dot) Jaurès <jauresfoute(at)gmail(dot)com> |
Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-general(at)lists(dot)postgresql(dot)org |
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: | 2020-07-01 23:59:45 |
Message-ID: | f1af2c31-6994-a755-dd46-17a892177d00@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 7/1/20 2:21 PM, FOUTE K. Jaurès wrote:
>
>
> Le mer. 1 juil. 2020 à 22:15, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> a écrit :
>
> On 7/1/20 11:21 AM, FOUTE K. Jaurès wrote:
> >
>
> >
> > Has the problem occurred again?
> >
> > Yes
> > 2020-07-01 19: 19: 21.868 WAT [24204] ERROR: could not receive
> data from
> > WAL stream: ERROR: could not rename file "pg_logical / snapshots /
> > 1E-8567EB0.snap.22195.tmp" to "pg_logical / snapshots /
> > 1E-8567EB0.snap": No space left on device
>
> What are the permissions on?:
>
> pg_logical/snapshots/
>
> postgres
> root(at)hybride:/var/lib/postgresql/12/main/pg_logical# ll
> total 20
> drwx------ 4 postgres postgres 4096 juil. 1 20:21 ./
> drwx------ 19 postgres postgres 4096 juil. 1 20:16 ../
> drwx------ 2 postgres postgres 4096 mars 31 11:58 mappings/
> -rw------- 1 postgres postgres 56 juil. 1 20:21 replorigin_checkpoint
> drwx------ 2 postgres postgres 4096 mars 31 11:58 snapshots/
Well replication is between two instances, so are you sure you are
looking at the correct data directory?
> --
> Jaurès FOUTE
> Technology Consultant
> ISNOV SARL - Business Technology Consulting
> Tel: +237 79395671 / +237 96248793
> Email: _jauresfoute(at)gmail(dot)com <mailto:jauresfoute(at)gmail(dot)com>_,
> jauresmelkiore(at)yahoo(dot)fr <mailto:jauresmelkiore(at)yahoo(dot)fr>
> Compte Skype: jauresmelkiore
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2020-07-02 00:02:17 | Re: Different results from identical matviews |
Previous Message | Anders Steinlein | 2020-07-01 23:39:48 | Different results from identical matviews |