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.96) (envelope-from ) id 1wzLf3-003xjC-1f for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Aug 2026 21:59:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wzLf1-00G1T7-2K for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Aug 2026 21:59:55 +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.96) (envelope-from ) id 1wzLf1-00G1Sz-1Q for pgsql-hackers@lists.postgresql.org; Wed, 26 Aug 2026 21:59:55 +0000 Received: from mail-qv1-xf33.google.com ([2607:f8b0:4864:20::f33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wzLez-00000001RTQ-1i0w for pgsql-hackers@lists.postgresql.org; Wed, 26 Aug 2026 21:59:55 +0000 Received: by mail-qv1-xf33.google.com with SMTP id 6a1803df08f44-90c776f6c13so14789176d6.1 for ; Wed, 26 Aug 2026 14:59:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1787781591; x=1788386391; darn=lists.postgresql.org; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:from:to:cc:subject :date:message-id:reply-to:content-type; bh=zXp5kcA2otBikfiRijLlndu1R7TpoxX+JNElY4i1+BM=; b=cvr7O21/X5JRmJbcLlUFjnWxECHWRQCmKtkyWvmUuZzO48kX26pzADGFkzYC1cCY7I 8hzodg/fkOMOA+88D3OJdGFndx0c+l2TAXsUQLemOO/AEcoQjqnS5zVr+W3wor8DVADs 1LxleZ1Z63paEFf39I758loA3GI2smxMz8U2HKyZRfhLFHHGlSkhi/Z/9u7vKOzvhQzF JwlBuZFksrI/t0GatrgR36E4sRn44VbT8w31/GpNEmaRlzmDYabpSKB7tp0zKrMQ65X/ 1/VxHlTRV+/a6o4mbx9aNVF2fh8SivhTF6A/ETWhqIP3w9eLHJ6ZSKrkgYgAkvaS0vZP 64vQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1787781591; x=1788386391; h=in-reply-to:content-disposition:content-type:mime-version :references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=zXp5kcA2otBikfiRijLlndu1R7TpoxX+JNElY4i1+BM=; b=JqoRt+DUJxy3UDd+niYyz8fYEfJn2aBPhD5ZlN1YSY2Ar/UxUFwE7nm36l7mUiIm9a qnhWxsnRC/8SIs2Og8m0VeMDJHP63y+ueZZD317XfpQ16PyYGF8p8ZXrkkFXzl2JdPHg OhHoyxibndl5Vyl+b8ckJVqXXIwzOziL+xEJKyNvTkSVjQ+guWriPTrgNbwUT3+GTuIO AOoVMlRNN9gp6PM2Ej4xeaM1xl80MW2AItTsZQ6LStpB1RC/EMgsIg2NDBLZ31MD0HsB fxju2+Qg1qToaZwWDcB/fhrzW5//vOym2ABvdIaKU0B3Guqg44RNr8lavIMjYk3rhWej rP6Q== X-Forwarded-Encrypted: i=1; AHgh+RrReaatyEiiQNJxeDMKnvcH5Q52ExRxVTponr6k7sC3aCVejmJDLApAsgoJIvUrzikQ5BBfRU39J83Yv04W@lists.postgresql.org X-Gm-Message-State: AFuF++k4tdNgopGn8PF6fqaYE8yD987RxFwq2L1ieMEDRM5DBQK7j1om Tls63riKFHXC8krX7WkDBjgbdl8UTPM1FZ9McpNLVXkJaNGT4Z4F0S3N X-Gm-Gg: AR+sD11a4sVGgDgHZig4jcJB+LI8uAphybuXw6g1GNvF9QAsDzUgu8CIOmqJ8i9VETo WUi4smG8dgvgptZ8nSAMLl5hGL2L0MI+DPQzQXt64hkZ5pbqUBae0n8eibKzCjqz3//p9T25xO5 EW+e6hPZIGpHU0dh5oBYPkxT9GYru/9HpgtullE1Qpdt5Oj6kTA+Y/Fh11G29+LPu/vVxEhRRTl iQVDvchiCUbdMIJ5XGyAw5gippPtq+vTSmv0NBQmSJAmgJdSxlwsYV133Y2W8mGmXVy270Wkzmn 9KhpGtOcw64ycdr6q7+W2CqqlHDQPc66zZ5/btyqP7O6BYkUTdOkKwuRBr/FEgjGmw1l6cKfW7Q YmE6KHRTf07GsbEG5ipHTkME9TvSiaZw3+I7rbE2+SGCT7vqdWapDnSKyMUQx++L0oS2o4ozYxb aRjd+/OgtG7l1GsO11Dmku9SRCAyNkWFNG5ew4JigtjcZ+psjCbKK978Q3X80Iuk460pT3c63St hKUL6WOWjg7TMUQw9lDKcrIbFOehuMb4n5LztrmWPn/GTdnmOGG2ntLB+nCvM6PeH1f4BgoZ1pK IRmr8wduFgiylRaG4N619bFKfQ== X-Received: by 2002:a05:6214:20a9:b0:8f3:e0ce:611e with SMTP id 6a1803df08f44-90cc79995b1mr105052576d6.19.1787781591573; Wed, 26 Aug 2026 14:59:51 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 6a1803df08f44-90cd7415bfasm614166d6.45.2026.08.26.14.59.50 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 26 Aug 2026 14:59:51 -0700 (PDT) Date: Wed, 26 Aug 2026 16:59:49 -0500 From: Nathan Bossart To: Daniel Gustafsson Cc: Zsolt Parragi , Alexander Lakhin , Tomas Vondra , "Jonathan Gonzalez V." , PostgreSQL Hackers Subject: Re: datachecksums: handle invalid and dropped databases during enable Message-ID: References: <28CF6FD9-E1C4-4C04-8270-E3305AC46171@yesql.se> <87pl049996.fsf@gmail.com> <38651C03-7582-44AD-9895-5784755E9E7C@yesql.se> <361531e2-52b5-499c-a126-815f277bbef2@gmail.com> <6C5BFC06-94D9-438D-9E4E-FE1CAAA17C23@yesql.se> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6C5BFC06-94D9-438D-9E4E-FE1CAAA17C23@yesql.se> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Aug 26, 2026 at 11:48:36PM +0200, Daniel Gustafsson wrote: >> On 25 Aug 2026, at 21:32, Nathan Bossart wrote: >> >> Does this one deserve a mention on the open items wiki [0]? > > I don't think this is an open item; the code as it stands reverts back to a > safe state in the case of a failed DROP. The same goes for if a user > terminates the worker process, maybe there is a UX change to consider in a > future version but it's not broken the way it is (as in, it reverts to a safe > state). Do you agree with this Zsolt or an I missing an active bug? Okay. I added one before you sent this message. Provided Zsolt agrees, I will remove it. -- nathan