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 1pHBIA-0006NA-W0 for pgsql-general@arkaria.postgresql.org; Sun, 15 Jan 2023 22:15:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pHBI9-0001Va-JA for pgsql-general@arkaria.postgresql.org; Sun, 15 Jan 2023 22:15:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pHBI9-0001VR-4a for pgsql-general@lists.postgresql.org; Sun, 15 Jan 2023 22:15:53 +0000 Received: from outbound2b.ore.mailhop.org ([54.148.165.188]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pHBI2-0008L3-ID for pgsql-general@lists.postgresql.org; Sun, 15 Jan 2023 22:15:52 +0000 ARC-Seal: i=1; a=rsa-sha256; t=1673820945; cv=none; d=outbound.mailhop.org; s=arc-outbound20181012; b=NjmDJIGnEjLEZFDOQGXQAAJnvDwi1PCEGrJj8j2ItavTbjD9ZnjQuWgERfyeLep5uMRXZteDwoPdF D241EspNwP74LBcxyFRlAM5iobl2kN/uJrQc+2dJGkWmQ5BfZRG5fAz5fbiEOsMO1ND3QKwJcM2SED yJH8n3hM4CA2yTgvsM/TwbMkP76S4sNnhqmsmo0dTknvwjayqgeNR+gc+58+g27CCyQGZnFOgDTr75 bskjA1FHYxe3EVFt3gnmG0S/qZjs3zmZdaaIXsKj5ReHpBRiziNJWq0gGjjbIYUA12i8DKwkyNCYO6 YrKl0Ww/ToYiRou4mZGUVktfU/VdLxA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=outbound.mailhop.org; s=arc-outbound20181012; h=mime-version:content-type:references:in-reply-to:date:to:from:subject: message-id:dkim-signature:dkim-signature:dkim-signature:from; bh=c8vScG73otb2gTRjykhCidxS62QlgfUcqZvbOSpCEn8=; b=nk2XjheYm59r3VWM8W4G2LU0q4q4cIIBGuTUpbhB9pEUGuQDjKOER6wVbimKk4n3kmC0NnVheAB0d F7wlHaIbIFsToK6+ldf73r+kKI/kvHfCa3jHaJyQ/eVw99G6mSRW/M/UFvA/bsNSlDBDAd0rGH3Ao3 USYD4J0SMGfiyStwm/kkRYp8tKs4TuLGL8VB7kmvovTz8eNHKFPWtATy3iV3Gfdj50SX3RfZSBrcWs yybregy2Dh/amZQiobtmUMnajTvYc6psDf+k5NKDuVo9q+c0y5hqKYwPlXlCAfX6Zy73rRx2+JSx8U p/Ak+8ImG/uMaK8THKiPcig2LXxwaqA== ARC-Authentication-Results: i=1; outbound4.ore.mailhop.org; spf=pass smtp.mailfrom=lists.simkin.ca smtp.remote-ip=172.105.109.24; dkim=pass header.d=lists.simkin.ca header.s=athena header.a=rsa-sha256 header.b=mOTNxO4X; dmarc=pass header.from=lists.simkin.ca; arc=none header.oldest-pass=0; DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=lists.simkin.ca; s=duo-1610662143981-d3c4c825; h=mime-version:content-type:references:in-reply-to:date:to:from:subject: message-id:from; bh=c8vScG73otb2gTRjykhCidxS62QlgfUcqZvbOSpCEn8=; b=wA1oX+pefl4Jw/PTwatk2ZINRbnC+yfotm1o4JKSugAK4oXaYCbBI/8as6XVoSyd08qhbexrUOhcb m7s7SvdLK3bLk5X7u7ZTfLyj/kZ2J0AdpZqnT6rRPzGDf9C0PDfn0QLoch4b/dQL39ac5qFG3SDw75 XI73HDCw97JVKkh8= DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outbound.mailhop.org; s=dkim-low; h=mime-version:content-type:references:in-reply-to:date:to:from:subject: message-id:from; bh=c8vScG73otb2gTRjykhCidxS62QlgfUcqZvbOSpCEn8=; b=fLd4bRdYrkicoj4SQiKKB8zKNfR+v3QlHMYVU7kq54WFAIAUInHoL1gGU8OQVD0FFi08Z4M0DqT4y w/sWJ/dnTUgr8gVgS5FDXUgL5zb+za6lu66MHIRVJQj7sDRyXj9X6JaAu4Rf4I5zaixQJRsyIYFGAh kN3ns/t87oO7qtYW2Q0wrfog2T+ro9GqsFxEksYgrZ+it0qZXrxiz6HRrOXV68GMQ8tQ+5dqZkrkJu j0R/dZIRwlXBDt9aqrQQXx6ukG1WezIzTbkahgi9tzwf8JopuiQZz1f+CvPvroygkAysVWerA9mm+6 Cmds2jU7zX1BYfcxKrjL66Q5blTzsKg== X-Originating-IP: 172.105.109.24 X-MHO-RoutePath: c2lta2lu X-MHO-User: 267ae662-9522-11ed-9e7d-95702c074b68 X-Report-Abuse-To: https://support.duocircle.com/support/solutions/articles/5000540958-duocircle-standard-smtp-abuse-information X-Mail-Handler: DuoCircle Outbound SMTP Received: from athena.simkin.ca (athena.simkin.ca [172.105.109.24]) by outbound4.ore.mailhop.org (Halon) with ESMTPSA id 267ae662-9522-11ed-9e7d-95702c074b68; Sun, 15 Jan 2023 22:15:44 +0000 (UTC) Received: from skynet.simkin.ca (d154-20-71-66.bchsia.telus.net [154.20.71.66]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) server-digest SHA384) (No client certificate requested) by athena.simkin.ca (Postfix) with ESMTPSA id D74EAC6BB7CB for ; Sun, 15 Jan 2023 14:15:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=lists.simkin.ca; s=athena; t=1673820924; bh=c8vScG73otb2gTRjykhCidxS62QlgfUcqZvbOSpCEn8=; h=Subject:From:To:Date:From:To:Subject:Date:Reply-To; b=mOTNxO4XV02V0THe8VGDOPB0nFc8nwuIRH/PIWQZAJWcjTyI/WKzfUgJGjjag6hKh rpIsazWvWr3HrFu33GoM9u7tKNha1K3CH5RzZtHAttT84psQv7dlegh59hOOE9SQ89 6krLEtOI/nIJM5p5BpY63pmSftxjOZ90TSI0zwt0+UsB+pC1nnnM8oKrKHEcsGmD9r jqODtU2K6SLaoKYI5kaUHUkTzoiCEqh4Kw3qdigMZ2A2R+GSSupqm6fo1o2mUKLRTh o6LYs6R9wvH/GxoMLnlvdvXxML1OIvCEbJQgTHRrim/M0faBmRgynotpNYGr0X+m1E x9htrhLaFZyDA== Received: from skynet.simkin.ca (skynet.simkin.ca [IPv6:::1]) by skynet.simkin.ca (Postfix) with ESMTP id 08F1B22E22457 for ; Sun, 15 Jan 2023 14:15:41 -0800 (PST) Message-ID: <69a8f73e58126f8f70f9c51a8289ff99f466ef89.camel@lists.simkin.ca> Subject: Re: pg_upgrade 13.6 to 15.1? From: Alan Hodgson To: pgsql-general@lists.postgresql.org Date: Sun, 15 Jan 2023 14:15:40 -0800 In-Reply-To: <20230115165933.473a414f.pfortin@pfortin.com> References: <20230115142732.0ec38e2a.pfortin@pfortin.com> <1650559.1673812055@sss.pgh.pa.us> <20230115153919.6d21ea50@pfortin.com> <1693377.1673816360@sss.pgh.pa.us> <20230115163808.22072dfc@pfortin.com> <20230115165933.473a414f.pfortin@pfortin.com> Content-Type: multipart/alternative; boundary="=-0gVOjBCmxbCzAd3PtRZ6" X-PGP-Key: fp="EF82 6F8D A3BA A096 FFA3 05F2 A7A0 40A5 34E5 AA0B"; id="0x34E5AA0B"; get= User-Agent: Evolution 3.46.2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-0gVOjBCmxbCzAd3PtRZ6 Content-Type: text/plain; charset="ISO-8859-15" Content-Transfer-Encoding: quoted-printable On Sun, 2023-01-15 at 16:59 -0500, pf@pfortin.com wrote: >=20 >=20 > encodings for database "template1" do not match:=A0 old "UTF8", new > "SQL_ASCII" Failure, exiting You almost certainly don't want your new database to use SQL_ASCII. Init the new cluster with -E UTF8. --=-0gVOjBCmxbCzAd3PtRZ6 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable
On Sun, 2023-01-15 at 16:59 -0500, pf@pfortin= .com wrote:


<= div>encodings for database "template1" do not match:  old "UTF8", new<= br>
"SQL_ASCII" Failure, exiting

<= /div>
You almost certainly don't want your new database to use SQL_ASCI= I. Init the new cluster with -E UTF8.

--=-0gVOjBCmxbCzAd3PtRZ6--