Space Related Errors in Postgres 10.4 Logical Replication

Поиск
Список
Период
Сортировка
От pavan95
Тема Space Related Errors in Postgres 10.4 Logical Replication
Дата
Msg-id 1534743876524-0.post@n3.nabble.com
обсуждение исходный текст
Ответы Re: Space Related Errors in Postgres 10.4 Logical Replication  (pavan95 <pavan.postgresdba@gmail.com>)
Re: Space Related Errors in Postgres 10.4 Logical Replication  (Christoph Berg <myon@debian.org>)
Список pgsql-admin
Hi all,

I have configured Postgres Native Logical Replication for 2 servers(a
publisher and subscriber). I have came across a new error in the postgres
log file as shown as below:

*PUBLISHER LOG:*
*2018-08-20 10:34:55.801 IST [24955] user@db ERROR:  could not create
directory "pg_replslot/mysub_14211111_sync_111111.tmp": No space left on
device *
*2018-08-20 10:34:56.036 IST [34222] user@db ERROR:  could not create file
"pg_replslot/mysub/state.tmp": No space left on device*
*2018-08-20 10:34:56.053 IST [23444] user@db WARNING:  could not create
relation-cache initialization file "global/pg_internal.init.11331": No space
left on device*
*2018-08-20 10:34:56.053 IST [23444] user@db DETAIL:  Continuing anyway, but
there's something wrong.*

My questions are: 
1) why has the error occurred?
2) What is the immediate to do task to reduce this error?
3) How to prevent it's forthcoming occurrence (or) How to make changes to
reduce this error?

This is my first Logical Replication setup. Kindly help me with these
issues..

Thanks in Advance.


Regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html


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

Предыдущее
От: nikhil raj
Дата:
Сообщение: pg_stat_statements in the query column I am not getting the exact query
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Logical replication monitoring