Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u21tb-00Bqv4-Qd for pgsql-general@arkaria.postgresql.org; Tue, 08 Apr 2025 05:53:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u21ta-00670U-6c for pgsql-general@arkaria.postgresql.org; Tue, 08 Apr 2025 05:53:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u21tZ-00670M-Sd for pgsql-general@lists.postgresql.org; Tue, 08 Apr 2025 05:53:14 +0000 Received: from mail-wm1-x330.google.com ([2a00:1450:4864:20::330]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u21tX-0044RD-2n for pgsql-general@lists.postgresql.org; Tue, 08 Apr 2025 05:53:13 +0000 Received: by mail-wm1-x330.google.com with SMTP id 5b1f17b1804b1-43cfb6e9031so46721605e9.0 for ; Mon, 07 Apr 2025 22:53:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1744091591; x=1744696391; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=YlUXRpVqsNPafkpFX+kq1086GeVZGxEYO6k6NbtIOvI=; b=JUjuoGBhnu3oBnGbvq6nzP7VKOVL0qgPZn1fzq8fSTx09PHfIEkxbqLrvLrSFyRX/y WAPfZjg18J6zOBnJUhk7S+A1oPbirZRbMpV5I/Lig2MAeZvHVdzj5lgyjlECgbohIBoT oYDMH3k/sOHLuYxIjzd2sNx/t5fTYT60CNwocZLqgLwU1RrKX2V+MTw0mKwuei8k5NrB m0AqQbUqLRq7BzrWLUOW7ge9ebvwb7SblysgP/76ScMwcYDIvZuJ8YwMt114+aL7Bdc7 whT2H0ulBarc9+vinDIw0aP+Tm3zGNXSDhs3EYoxVHZyZlj20NTOnc3Zt1SeaEe01RYo HgZw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744091591; x=1744696391; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=YlUXRpVqsNPafkpFX+kq1086GeVZGxEYO6k6NbtIOvI=; b=WH1xJmWEapKk/EGbPxbYvaHhJKjOzuXtl+mNzv2bHLB3a/IhxxYKNp6SeNnt5PW3kL L9PtuI9ylw2pkFWyy74b7cYzMOz8c3WLRFDO/Ms7pjLXKzu2CNaMB58lguuerFSOCLaK TDKlU9RN1neZ2AF1oz1x/Jq37gEb4GZW/FLjRuFEyF6hUFDMFFgSuoQmmCBqA7gcIlOW SR4828s6DEwxA17Wm9ZNDQCFh7SWWwA5c/NtAtJiKHB7S8yJBgkF0E80xDyMqXJUwLWu 48J9zTJbi72HehXPCHSqgBiMnLyo93Oh3P5eONxIMED6m7LRsNH0TYhmYh3nAEhPK0uV 6Blg== X-Forwarded-Encrypted: i=1; AJvYcCUwQcBeNMlpFlmtG6wu3AnwrDmgkGehoIzEzr+S76dS7EovKA+/OsrA8DvzfaTBW7WOmFtMlFImhpve6pbD@lists.postgresql.org X-Gm-Message-State: AOJu0YyZBTn/Wo9NNiifl/yBSF8M9n+CIdAtp468fkeWQSHdVV131Ezq cQKs4DnmNxYFvOgxyprDERlRmwl0M9ziAmZqNn0kdU1zuyiRlw+gfDyMtZ3j0cIwV82jKm9JsZb KnpFKTA== X-Gm-Gg: ASbGnctyfpdELUZjc7vzorUr2LjHkOyYxGhULIRkkRefPtFs/0+bsTUbnAL9xnfr1rL IUhuHpmMK4AsE6nk3RgdNY7J0Cu1QtypVD6Eb9tLbzwqIOfoad5+6qqNgj4S3x8psjWzhynJSQr Lm7RTrlIpqIOl3z56qOmXhdG4U6kDWhi0jvuz7Jln0dLH6ZQbUlzwMUObjpPRaxqinRGXHWjVpt wDzQL+jcMEB6LXJ42NL7DZ1H+qjrVrd9Rn1wxW8h3DyENo1nrXUcWoSlD7u2tko5mwDWqfKWZM8 7zPHbdJm1tMYC//gOMusftiXUCOgtOxVmpHRLanyq/FrcCOCvkSUwtBS5mcwuQ== X-Google-Smtp-Source: AGHT+IGcTA32tTZcHBnhao7tfIrNLmymrjpWbQtqDxLlSkodLClCAVPVWmNiXXkyCNH0JOjp7lJenw== X-Received: by 2002:a05:600c:848d:b0:43c:f969:13c0 with SMTP id 5b1f17b1804b1-43ecfa1874emr132011965e9.29.1744091590749; Mon, 07 Apr 2025 22:53:10 -0700 (PDT) Received: from localhost.localdomain ([41.66.99.137]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-43ec1795782sm153195185e9.26.2025.04.07.22.53.10 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 07 Apr 2025 22:53:10 -0700 (PDT) Message-ID: Subject: Re: find replication slots that "belong" to a publication From: Laurenz Albe To: Willy-Bas Loos Cc: Justin , pgsql-general Date: Tue, 08 Apr 2025 07:53:09 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2025-04-07 at 22:32 +0200, Willy-Bas Loos wrote: > I find it very strange, because the publication is needed to make a subsc= ription, which makes the slot. Right, but that information is only on the subscriber. Yours, Laurenz Albe