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 1mirZ8-0006Vg-IE for pgsql-admin@arkaria.postgresql.org; Fri, 05 Nov 2021 05:15:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mirZ7-0008Io-HE for pgsql-admin@arkaria.postgresql.org; Fri, 05 Nov 2021 05:15:01 +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 1mirZ7-0008IM-1m for pgsql-admin@lists.postgresql.org; Fri, 05 Nov 2021 05:15:01 +0000 Received: from mail-wm1-x336.google.com ([2a00:1450:4864:20::336]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mirZ4-00036E-D8 for pgsql-admin@lists.postgresql.org; Fri, 05 Nov 2021 05:15:00 +0000 Received: by mail-wm1-x336.google.com with SMTP id y196so6136450wmc.3 for ; Thu, 04 Nov 2021 22:14:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=WZl6T67z93h04KWjRuXFDx6HVXrEC2TEIA2ZYYzUt0g=; b=tRP/RMNsbYIKH6LLygnuqsfKK3nnGgsdBt+Lh5hPLyf0xWR319lCtU00ganhXIFpg4 zggqw6W71mOkPLznnWMB518WaRgUyhCwC2TPT/56Q28QQP/TEAxbe/t+gtoCRPNvjtoT fPFA4Ci3TfsFag2mMPLUrMrRiOc1nUtFwnVTvtr0CsGqTZU35jWu1oFf1WR4COzuX2N9 /U1qPEihBgMrPj5Ybe1tG7zOuXQr5DpJ7YW7wSUsL1ZzMjW9xcb75PoFwcgqRTOm1FzH lFgGKQzziAcrt35EcnPeZm9NLF2aakZtTsbgKuqD7IVWTR2cQa22MNLAAX7uvOYt1Qar QzWA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=WZl6T67z93h04KWjRuXFDx6HVXrEC2TEIA2ZYYzUt0g=; b=KzVTnYoKg+ij2tQa0ZqJQrCrqHqzJms5E1hb9TXVyXgoQlHjzRXuPHIU/vvsZvx3h9 GlpZaa6p4t9o2VF6JFwTUSPbweCVDzwNxlynF9rLMhWdsfJcDGQPooudXXnBwr2y8SqH J74Xq/d9gQnhD/R9L9t5CJzi+JxaoaOv8j7ICV0qRE1n1j/FDtdus08nk08xM2v0C/Ya pwO3gFGDy6B/EVA6iwdddwZp+iwn9U2TAkIRBiAarmvUebmpF73T7C5PeMkZMuh8X+5F XMTL/uwTqD7+63O9syAMvFLYUJst5R9jXY4COfILklLLQMzwx3k8lcZgjUADxfFAYixB X35g== X-Gm-Message-State: AOAM530mlnL+3wpscnj8MVSUD60XkdHAAmX93FOO3pCTHdfHuBE1Ddvv poLnncea9tOa9pmyAtxrH0wQSg== X-Google-Smtp-Source: ABdhPJxOoTUK0yWJEKYAAEE8gUQo8dRJnjgDGgMxcLc/1ob7HcnuIEDjdLcU0Fsj9KjFT1emDRQGuA== X-Received: by 2002:a1c:cc0f:: with SMTP id h15mr28503402wmb.37.1636089295650; Thu, 04 Nov 2021 22:14:55 -0700 (PDT) Received: from localhost.localdomain (178-190-178-186.adsl.highway.telekom.at. [178.190.178.186]) by smtp.gmail.com with ESMTPSA id f18sm6892953wre.7.2021.11.04.22.14.55 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 04 Nov 2021 22:14:55 -0700 (PDT) Message-ID: <631ef09ca7455fec3c26d1dd914a71b669793ba5.camel@cybertec.at> Subject: Re: Encoding error during database restore From: Laurenz Albe To: Paul Smith , pgsql-admin@lists.postgresql.org Date: Fri, 05 Nov 2021 06:14:54 +0100 In-Reply-To: <9ca189ac-7a0a-2594-fb8d-c346443a630f@pscs.co.uk> References: <9ca189ac-7a0a-2594-fb8d-c346443a630f@pscs.co.uk> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.40.4 (3.40.4-2.fc34) MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2021-11-04 at 15:58 +0000, Paul Smith wrote: > On 03/11/2021 21:03, Marc Fromm wrote: > > Is there an alternate way to set --locale=C using the “postgresql-setup --initdb --unit postgresql” command? > > have you tried using 'SQL_ASCII' instead of 'C'  for the locale? That is very bad advice. Never use SQL_ASCII! Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com