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
Тема 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
Дата
Msg-id f1af2c31-6994-a755-dd46-17a892177d00@aklaver.com
обсуждение исходный текст
Ответ на 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  (FOUTE K. Jaurès <jauresfoute@gmail.com>)
Список pgsql-general
On 7/1/20 2:21 PM, FOUTE K. Jaurès wrote:
> 
> 
> Le mer. 1 juil. 2020 à 22:15, Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.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@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@gmail.com <mailto:jauresfoute@gmail.com>_,
> jauresmelkiore@yahoo.fr <mailto:jauresmelkiore@yahoo.fr>
> Compte Skype: jauresmelkiore


-- 
Adrian Klaver
adrian.klaver@aklaver.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Anders Steinlein
Дата:
Сообщение: Different results from identical matviews
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Different results from identical matviews