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 1qg1vc-00EBnr-97 for pgsql-general@arkaria.postgresql.org; Tue, 12 Sep 2023 11:51:36 +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 1qg1uC-007zfD-2w for pgsql-general@arkaria.postgresql.org; Tue, 12 Sep 2023 11:50:07 +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.94.2) (envelope-from ) id 1qg1uB-007zf0-Na for pgsql-general@lists.postgresql.org; Tue, 12 Sep 2023 11:50:07 +0000 Received: from mout.kundenserver.de ([212.227.17.24]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qg1u7-0048pE-3L for pgsql-general@lists.postgresql.org; Tue, 12 Sep 2023 11:50:06 +0000 Received: from [192.168.1.9] ([78.141.12.8]) by mrelayeu.kundenserver.de (mreue106 [212.227.15.179]) with ESMTPSA (Nemesis) id 1M3DeV-1qjcP72dxt-003dWp for ; Tue, 12 Sep 2023 13:50:00 +0200 Content-Type: multipart/alternative; boundary="------------d9M0cm0fPy0woJQSKg46FamU" Message-ID: Date: Tue, 12 Sep 2023 12:49:57 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Content-Language: en-GB From: Graeme To: pgsql-general@lists.postgresql.org Subject: pg_update and encoding X-Provags-ID: V03:K1:rv/Deev07/32KrUA1OZYcxf5eHj0pqXcgMN6UAzTxq30NEKtMjX /HcL9+aLFspzdWDbBc56vxb0qY46UphlWaXJqNDvJykn7ftK23A1OzVLvZd7QfutsTht5HK ZvseVQV3/z6g+SXAEttbnahHpoQSE4xuLVdE6WPT8cjEe6TwysAmI3Hyw1anwkr3Gami1QT pt0z55jK+ePoYo72jK2DA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:A8rCwxiYdB0=;bUfR95RuaZDgszS9q5fqniRD0Jh /905ZJl04M7mdIFqzXkKrrdZSYZsQAqEMa4QCU43I5AEAmnZoKqLG783M/pdPT39lwaMhzkQY Yo6nKD0+q09tZWZodX6Lh2nuCOHmCPWmkhRkfFRbffLbkyC9HUP14xz1bPzHLwwouCdDCybEN TJxyxiMQNbXNJ8Wwnp0M8kQoHmU0NryVgP9HPXAT3wicULbZY91YVHk9c2+Vbt4gIcCd5rw+s w9cJIZMWLg8PPC5Qy3MmPw75XuEc8+g7Y1iqIcqUkyglN92qtv06NCLuvoHWoO0hdLeWtYDTt 4h2t6tcB+qHB2XN4Kisnojaj8QUI1XJvaHigGgeYMfBXImb+PcvO+LfYT0g8NQmqf3H1mvhYF fnhfeFttY76QeGoF/780Dt/myTt1jgau7zXomMz4q9t1+sfLBcOAuIHTbhOvUebEdaQb7xiaq 5KEnW/KyJZRtIqF2IPMiHxCHQ1x8AW4onCsnwYp5gRz6TdG8Fm+Om6NYc5LEJcUL5eHn271BY YR0vnXXqaqMmsauAK5pkog31ADG085iqzdls7jeNoJCHgWTPPMvVzKrcGpb+4lUuM/jc8T6ie APUQ5ls90vI01o5otV37LP/ReELjeCHuwfcdvH4z9l+mDvc++rucRvZ84TPHRAMql2s/CDT2/ t46lgQRXqVhs4kgpmvhkUUkIEeZYpyQ1z5HIVXMlGQSdrZdEZDeOkNr94ldamEFEmGgzYbv4Q 6+2or047abRjtKhXKhdFQSJM7IAn1cYpA1xEVCYpV8Xtl47gmlHt+4CRusyR3zA+cHnlJraJZ UGMEU06Lt0KzrcoXxajhCuYD1g8C9mRLkEEr7Kqzcafs5Qt4Rp6SGktdI/JRhTqn0A7CktpIm s3RkgMv8dqNXHdA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------d9M0cm0fPy0woJQSKg46FamU Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Preparing to use pg_update, I used initdb to create the new pgsql/data, but pg_update has exited with encodings for database "template1" do not match:  old "UTF8", new "SQL_ASCII" Should I delete pgsql/data and re-create with initdb -E "UTF8"? Thanks, Graeme --------------d9M0cm0fPy0woJQSKg46FamU Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

Preparing to use pg_update, I used initdb to create the new pgsql/data, but pg_update has exited with

encodings for database "template1" do not match:  old "UTF8", new "SQL_ASCII"

Should I delete pgsql/data and re-create with initdb -E "UTF8"?

Thanks,

Graeme

--------------d9M0cm0fPy0woJQSKg46FamU--