Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1frczj-0007VS-Re for pgsql-admin@arkaria.postgresql.org; Mon, 20 Aug 2018 05:44:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1frczf-0001Ys-Iq for pgsql-admin@arkaria.postgresql.org; Mon, 20 Aug 2018 05:44:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1frczf-0001Yk-BY for pgsql-admin@lists.postgresql.org; Mon, 20 Aug 2018 05:44:47 +0000 Received: from n3.nabble.com ([162.255.23.22]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1frczW-0000s0-QD for pgsql-admin@postgresql.org; Mon, 20 Aug 2018 05:44:46 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id ACE26EA65E30 for ; Sun, 19 Aug 2018 22:44:36 -0700 (MST) Date: Sun, 19 Aug 2018 22:44:36 -0700 (MST) From: pavan95 To: pgsql-admin@postgresql.org Message-ID: <1534743876524-0.post@n3.nabble.com> Subject: Space Related Errors in Postgres 10.4 Logical Replication MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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