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 1w7xZD-0004g0-1T for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2026 15:33:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7xZC-0013Ql-0s for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2026 15:33:14 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w7xZB-0013Qd-0H for pgsql-hackers@lists.postgresql.org; Wed, 01 Apr 2026 15:33:14 +0000 Received: from mail-dy1-x1331.google.com ([2607:f8b0:4864:20::1331]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7xZ9-000000001ym-2SM3 for pgsql-hackers@lists.postgresql.org; Wed, 01 Apr 2026 15:33:12 +0000 Received: by mail-dy1-x1331.google.com with SMTP id 5a478bee46e88-2c4db6bca03so650196eec.1 for ; Wed, 01 Apr 2026 08:33:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1775057591; x=1775662391; 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=s2+ItnKYWw1iKVIOB7VFMXdvXh/Ti5MZxo9vROy78Qo=; b=bhoH5Of4LEwHXEYC0BGL0Qjyrm7Upo95hIj49SNnFsjhH0w/jkVPCOSTH8zzyMIU7b 5zaUrvlrWZCxIUclpPn5AOvkzuTj1LgzI4CRCFwtyCpXku6Zo6cFvK462e5HB4EcNSUU bUztNVsGUMpQ5BIULJWidkD1ITHKraA0Qc7kGZ8NTsKmEVmzKSohcySCWuVkyGX4ipn5 ajvL994vv4MNUSNDDbuj2CP2Lz04AAEbONEdouz2P8kVOzoeBgalwogAs5yOB60O2KGf d97ok/8+WuXT5PI6qp0RFATAkkOeah4kNAHs5OEQ2VVK666Zusb/CaAL1Ic95VmT2CCR 88Hw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775057591; x=1775662391; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=s2+ItnKYWw1iKVIOB7VFMXdvXh/Ti5MZxo9vROy78Qo=; b=G0ChLdaO5PA3Guxm9qnNMuWE2RwHRAQn1yxsq/aVVlf8KKtFDTD0/1AY6H1pGKpLfO u8w7w3fU9B7FtzS1CVOyXS3LYc+XRMfikZSpDAki4K7VFHZchDZwwvjnsJdcDuwUbIec 8X1qN+dCMqjLEmLp8MwU0wgYlaEd31oB1f9AdxBXHXJPchZ4rIOt2LxqqKpouRuSaNBU 11/blwPc8rqEXLPvPNgEc01lq6OWk63t5mEDDVIc8u9VAJErQNByk/in8RI/2YM9V+jB rH0ahIRNMxpE6TVpH9frQdvQ34Li4+x+N1jw5c8kl/L2qLDKnJQB93i7U+XDWs6cUS7x RAvQ== X-Forwarded-Encrypted: i=1; AJvYcCXzOJsmUdOE11DhEDwePO0N48KqW6BaeqExGy1s3Rqatst/Vw9vYKA97ICIqOjAea3IkMmXDrl8VDDwC7EQ@lists.postgresql.org X-Gm-Message-State: AOJu0YwinV8Sljf0vjKJagoU8vjiD+ylVOJ9APY6wOpt0MrHc+PkObe6 dR94qwP1xeAj7pQNponZijsQxYCBR/zmwgZkVhoYGdnL7Dmb+rHKKaj2Y9DHNaLxjw== X-Gm-Gg: ATEYQzxtn3CMoqjAhqO1NqT4BX7I6pYdHMLmeMwOaswgUAU0jyEIXuATd0E9ZY0qAS+ 3E5TYoJzDEfR7+ellrWvOgrB5aKWv8pO1rnqXg0r5J6SH05oqIw9bEhvl0/Uii3xnVYR2uONz5X CrXLI1dWsZQSTodQOsoAi1UZIA/mYeONUPNN0TFg4/t86BAvDePtWZVVn5IkZZeoyNIsYr5AVFt rt/Ga0tBa42imfdvwnKvthg2WoJ3ihXwNbESkF8xUnx6BJOt1k7yg/wXfEovlZ4shFExs0ERSrt N+3MQVmLa/DbELJWcPvlIF6P9d88VRl9qKNwFdaZM3XxvpEDRV+xKBmTGXEMM+PkfDak5yJWZop Ojx+RuRsAAb9gJ55QfdDuOzPwJ2Y8wxjBF3R6HUEsizXvNNpUoT/3wuUooDF8/qILCxq91twufD N/2kuah7Bae7F+wkHACCMR9UZzFoW6v9O2LqwLhD7YvcvPiayq2uo= X-Received: by 2002:a05:7300:ed0e:b0:2a4:701a:b9ba with SMTP id 5a478bee46e88-2c92b21ae4dmr1827466eec.14.1775057586208; Wed, 01 Apr 2026 08:33:06 -0700 (PDT) Received: from jeff-laptop.lan (c-24-7-19-3.hsd1.ca.comcast.net. [24.7.19.3]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-2ca7c20b195sm23689eec.16.2026.04.01.08.33.05 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 01 Apr 2026 08:33:05 -0700 (PDT) Message-ID: <790a2e194c2d8cb03a2f1b8b580b64f25a5095b0.camel@j-davis.com> Subject: Re: Do we still need MULE_INTERNAL? From: Jeff Davis To: Tatsuo Ishii Cc: thomas.munro@gmail.com, pgsql-hackers@lists.postgresql.org, tgl@sss.pgh.pa.us Date: Wed, 01 Apr 2026 08:33:04 -0700 In-Reply-To: <20260401.083826.1947227822512469454.ishii@postgresql.org> References: <20260211.155236.1457492817322202220.ishii@postgresql.org> <20260401.083826.1947227822512469454.ishii@postgresql.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.3-0ubuntu1.1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2026-04-01 at 08:38 +0900, Tatsuo Ishii wrote: > In my case pg_upgrade does not fail. >=20 > Old clsuter: > - create pg18 cluster with SQL_ASCII encoding > - create MULE_INTERNAL encoding database > - drop the MULE_INTERNAL database >=20 > New cluster: > - create pg19dev cluster with SQL_ASCII encoding >=20 > Run pg_upgrade Repro of my case: cd pgsql18dbg ./bin/initdb -D data -N -E MULE_INTERNAL --locale=3DC ./bin/pg_ctl -D data -l logfile start PGCLIENTENCODING=3DSQL_ASCII ./bin/psql postgres \ -c 'create table x(t text);' ./bin/pg_ctl -D data stop cd ../pgsql19dbg ./bin/initdb -D data -N -E SQL_ASCII --locale=3DC ./bin/pg_upgrade -b ../pgsql18dbg/bin -B bin \ -d ../pgsql18dbg/data -D data =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D ... Performing Upgrade ------------------ ... Setting frozenxid and minmxid counters in new cluster =20 connection to server on socket ".../pgsql19dbg/.s.PGSQL.50432" failed: FATAL: invalid database encoding: 7 Failure, exiting =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D It's easy to fix by just rejecting MULE_INTERNAL during the "check" phase. Regards, Jeff Davis