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 1krHqd-0008If-8R for pgsql-admin@arkaria.postgresql.org; Mon, 21 Dec 2020 09:51:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1krHqc-00010Z-75 for pgsql-admin@arkaria.postgresql.org; Mon, 21 Dec 2020 09:51:22 +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 1krHqb-00010S-SD for pgsql-admin@lists.postgresql.org; Mon, 21 Dec 2020 09:51:22 +0000 Received: from mail-ed1-x535.google.com ([2a00:1450:4864:20::535]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1krHqV-00041p-Nx for pgsql-admin@lists.postgresql.org; Mon, 21 Dec 2020 09:51:21 +0000 Received: by mail-ed1-x535.google.com with SMTP id g24so8968023edw.9 for ; Mon, 21 Dec 2020 01:51:15 -0800 (PST) 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=7zvAWU8EwtRUTOL4P+wN3rJcg1kjLA6MFjjk8wpDhSk=; b=tZbgdW3KXm4X66XbgWE+Jkx2tKW6WgNf25gn+oYJP770BeXPgKlA6mFlVijRf1zORS vbq7HbMTugiO7JIDpYa9Obv2Am49vK7oTOClo94gYkiW/VbMfD/b0ERWXn65kXWQRaSw J3ujlUyHGyxmwbRRLayn8D7pk6UcQF0C0HTRZZoSJHBvZDbUSFBAMb4BRgxJJ3JSHFVx JV1rq+/1o74cKEiL2c6BMlVhjbMFknYurTm/xZbx+/6FOb/hkP2oFyIYeQGdPNOvRpD5 KfHv+Q+bimxUS5NYmAMY84j5uMo3JsXFHw9r6Xl4SpJ549EIw4lMND4Bwt/MgCcqMJ3l LWeA== 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=7zvAWU8EwtRUTOL4P+wN3rJcg1kjLA6MFjjk8wpDhSk=; b=IqV5lbhTqAt5mnY9qHGpiy9G2+5gcnK7IN9oSd6TutnZREmDdnhvXgRqEm/MM56A6Y 6+Hp3tAXZjyVWrGOSAwdsCq7NAz9NLGzFtTmIWZxWG1zJayL6zyfBs7XFbSZA50p6hfz kVJ15LeMk/GpeRA3OXtZlKr3pX3j5M3P/enGoABKlRsIuau7kS7nhPSXsR5rD/nhq+dS w8gq6FA1obzXnAQ6yGrSVbXIpCNCt+6lYxQZtWvU9XQnu1WCztNQskEM03H7CV9BsHlt B6vHeg9ssSF/XDQAnQq65PYxPvsun3EpkFtwxdmVAcPnydFLxB02QQ35WrngxlilxreV FhSg== X-Gm-Message-State: AOAM533S08BBfQULqag5dklIrlyG8JeBCEusKjJvxYEIGEdVRHkfOt18 ttZ5eqPupBHxbXlbQa1HH9fahA== X-Google-Smtp-Source: ABdhPJwxgYjctysZSsdg8fR9oNHL9vLtSKdmvThFMQgTJd0Z7zZ4dAUzatDGc/pm7J+XKnHUY6rwZA== X-Received: by 2002:a50:8163:: with SMTP id 90mr14933220edc.142.1608544274729; Mon, 21 Dec 2020 01:51:14 -0800 (PST) Received: from localhost.localdomain (217-149-168-145.nat.highway.telekom.at. [217.149.168.145]) by smtp.gmail.com with ESMTPSA id dg10sm6490375edb.63.2020.12.21.01.51.13 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 21 Dec 2020 01:51:14 -0800 (PST) Message-ID: Subject: Re: Logical replication stops updating From: Laurenz Albe To: Yambu , Pgsql-admin Date: Mon, 21 Dec 2020 10:51:13 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Mon, 2020-12-21 at 11:48 +0200, Yambu wrote: > My logical replication stopped updating, how do i make it start again? Read the standby log file and fix the problem you see there. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com