Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mJWJ7-0005Is-CF for pgsql-admin@arkaria.postgresql.org; Fri, 27 Aug 2021 07:29:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mJWJ6-0003wb-8A for pgsql-admin@arkaria.postgresql.org; Fri, 27 Aug 2021 07:29:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mJWJ5-0003wM-S1 for pgsql-admin@lists.postgresql.org; Fri, 27 Aug 2021 07:29:43 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mJWJ0-0006oZ-17 for pgsql-admin@lists.postgresql.org; Fri, 27 Aug 2021 07:29:43 +0000 Received: by mail-wm1-x32b.google.com with SMTP id j14-20020a1c230e000000b002e748b9a48bso6850324wmj.0 for ; Fri, 27 Aug 2021 00:29:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=jzDxu2pFO7BBgmP0C9zKVcdRfuev/+1I/1OtO9kVX4c=; b=NIHbdyd1opmCLsyc/F8zWtIEkiXFqF5UrI/KtnTmzF7PXKEA1Yz000t2iowxQs/Qmx RCuBjg9BASfHUzo69vNbaDWjLUf2PdqeSC2QdwuK1aO3WwYPDYUiuk0RYW9W1jZDKkHn RST6jK4jW8kEwoOfsy323MzObG+wV7mlZOyNa3hrRZVTY6adpkj3I2FYK1p5rL2q+qdF kyjivw8VXqsVwX/QkMGiKaT3ZX3AP1SgoYGzOvDG5lozrnq3X/crbPlC5BADmDjRiCEF R9zkDVATqsAL289ZLe2Kglprl1bPVWl4DMA36WplqHhHXS7GtXf5SdnPyOuHZOnMCOHy 2i5w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=jzDxu2pFO7BBgmP0C9zKVcdRfuev/+1I/1OtO9kVX4c=; b=V+fynlq4oi7+/ZRbmxFVO6K12PQSeP5lPBpkLJXq4vkVhmGoThCe3xCkDkZJ5hfO+Q NeGrAlAIMA3f9qWXYZJ9qfQFiBmMF3dgZ7kbw3XAtKjNfsCDJvyZDNuoBKi24Zjxgshi fwPKReCKTK8rPCbEJyUxC418fJzQS150IHib6sRf8KkIkKkYg6sS8nY74UjGzInbIfKg YNFEKl+7jnwwO/5VO5k4bwlCFzQobfjxl2eJhRZzpb+4RlEt+xGyzPLBYEGj5EsAk/GA wrl5Qh6g+I+byHi+H4n9eCNRPtEoh4v/BPOpaxoRz1pKKf3PrlnPRgVst1N25C4JlOy2 gy0g== X-Gm-Message-State: AOAM533pHKIcJg1T/pDSoC626aSG6ro8Pv0l5Z7ox8zpIOPilmZ7nr+l B7OypjS5aPNMM7KG4bq09ncTeDC01EsZ8tXM X-Google-Smtp-Source: ABdhPJwn4UloOgzmQAFslKctrvimXanCvCwHtgwP3tNK04hSBEM7eVvDVKuWt6MUp58xRXS6dKC++A== X-Received: by 2002:a1c:40c:: with SMTP id 12mr17889009wme.158.1630049375814; Fri, 27 Aug 2021 00:29:35 -0700 (PDT) Received: from localhost.localdomain (dynamic-e41ynjkw44ykta3or-pd01.res.v6.highway.a1.net. [2001:871:5c:e82d:7c71:3f6d:7e60:5e2b]) by smtp.gmail.com with ESMTPSA id p11sm4943930wma.16.2021.08.27.00.29.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 27 Aug 2021 00:29:35 -0700 (PDT) Message-ID: <1e79ea171debe2b3ed9c297989f110cfccdf129b.camel@cybertec.at> Subject: Re: slave stops replica From: Laurenz Albe To: Pepe TD Vo , Pgsql-admin Date: Fri, 27 Aug 2021 09:29:34 +0200 In-Reply-To: <1415172523.18991.1630012160409@mail.yahoo.com> References: <1415172523.18991.1630012160409.ref@mail.yahoo.com> <1415172523.18991.1630012160409@mail.yahoo.com> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.40.4 (3.40.4-1.fc34) MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2021-08-26 at 21:09 +0000, Pepe TD Vo wrote: > I had master slave replica and yesterday the slave server's device was full on /var > where the archive copy from master.  After trying to figure out why the > pg_archivecleanup doesn't work, SA removed all wal files except the  current > > I tried to create a test table on master and didn't see it pick up from slave. > I found out again /var is full.  If you have deleted WAL that has no yet been applied to the standby, replication is broken and you have to build the standby from scratch. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com