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 1mifE5-0005WC-Sv for pgsql-admin@arkaria.postgresql.org; Thu, 04 Nov 2021 16:04:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mifE4-0007jt-RZ for pgsql-admin@arkaria.postgresql.org; Thu, 04 Nov 2021 16:04:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mifE4-0007ji-Es for pgsql-admin@lists.postgresql.org; Thu, 04 Nov 2021 16:04:28 +0000 Received: from mail.pscs.co.uk ([178.159.9.185]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mifE0-0006LR-Sm for pgsql-admin@lists.postgresql.org; Thu, 04 Nov 2021 16:04:27 +0000 Authentication-Results: mail.pscs.co.uk; spf=none; auth=pass (cram-md5) smtp.auth=pscs Received: from lmail.pscs.co.uk ([192.168.150.1]) by mail.pscs.co.uk ([192.168.150.185] running VPOP3) with ESMTPSA (TLSv1.3 TLS_AES_256_GCM_SHA384) for ; Thu, 4 Nov 2021 16:04:22 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pscs.co.uk; q=dns/txt; s=lmail; h=Content-Type:Message-ID:Date:MIME-Version:Subject:To:References:From :In-Reply-To:Cc:Content-Transfer-Encoding:Reply-to:Sender; t=1636041509; x=1636646309; bh=rsUIRYgRddwKuV4DDZzCzDBdFJWjUsbJ9CH7h3IymJo=; b=K9qd9voClsvnObYJmX4kXmntfXqo0JaiZHI959XQcisOYKgzPOCyEwp5lBSnZFf3Rlwh0kvY i7cORpLyCrFKaXnCdQOoaY8T6RCXVDL1Nqsc+rTbIGKHC4Jk6yBF/zoPIAbQMs0uHuFGzrDjGs sNwW6h/ahmUtzkK7y39ZBZVR8= Authentication-Results: lmail.pscs.co.uk; spf=none; auth=pass (cram-md5) smtp.auth=paul Received: from [192.168.57.136] ([82.68.48.206] (82-68-48-206.dsl.in-addr.zen.co.uk)) by lmail.pscs.co.uk ([192.168.150.70] running VPOP3) with ESMTPSA (TLSv1.3 TLS_AES_256_GCM_SHA384); Thu, 4 Nov 2021 15:58:29 -0000 Content-Type: multipart/alternative; boundary="------------XtGiP7xhW4W0cXsR060eiEUt" Message-ID: <9ca189ac-7a0a-2594-fb8d-c346443a630f@pscs.co.uk> Date: Thu, 4 Nov 2021 15:58:29 +0000 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101 Thunderbird/91.2.1 Subject: Re: Encoding error during database restore To: pgsql-admin@lists.postgresql.org References: From: Paul Smith In-Reply-To: X-Authenticated-Sender: paul X-Server: VPOP3 Enterprise V8.3 - Registered to: PSCS X-Organisation: Paul Smith Computer Services X-VPOP3Tester: 12 345 X-Authenticated-Sender: pscs 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. --------------XtGiP7xhW4W0cXsR060eiEUt Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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? -- Paul Paul Smith Computer Services support@pscs.co.uk - 01484 855800 -- Paul Smith Computer Services Tel: 01484 855800 Vat No: GB 685 6987 53 Sign up for news & updates at http://www.pscs.co.uk/go/subscribe --------------XtGiP7xhW4W0cXsR060eiEUt Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
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?


-- 
Paul
Paul Smith Computer Services
support@pscs.co.uk - 01484 855800

--

Paul Smith Computer Services
Tel: 01484 855800
Vat No: GB 685 6987 53

--------------XtGiP7xhW4W0cXsR060eiEUt--