Обсуждение: Space Related Errors in Postgres 10.4 Logical Replication
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
Hi all, Looking forward to hear from you regarding the above errors. Thanks in advance. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
Re: pavan95 2018-08-20 <1534743876524-0.post@n3.nabble.com> > *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 * This is simply what it says: your disk was full. You need to make sure PG has enough free disk space available. Christoph
But enough space was available. Don't know why it occurred.
Regards,
Pavan
On Tue, Aug 28, 2018, 12:08 AM Christoph Berg <myon@debian.org> wrote:
Re: pavan95 2018-08-20 <1534743876524-0.post@n3.nabble.com>
> *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 *
This is simply what it says: your disk was full. You need to make sure
PG has enough free disk space available.
Christoph
Maybe check if you have any quotas set up that might be limiting the space available. Alternatively it might just be that the space required is bigger than you think (i.e usage grows so fast that casual monitoring does not pick it up). regards Mark On 28/08/18 06:58, Pavan Teja wrote: > But enough space was available. Don't know why it occurred. > > Regards, > Pavan > > On Tue, Aug 28, 2018, 12:08 AM Christoph Berg <myon@debian.org > <mailto:myon@debian.org>> wrote: > > Re: pavan95 2018-08-20 <1534743876524-0.post@n3.nabble.com > <mailto:1534743876524-0.post@n3.nabble.com>> > > *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 * > > This is simply what it says: your disk was full. You need to make sure > PG has enough free disk space available. > > Christoph >