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 1sltI6-001mGx-Mv for pgsql-bugs@arkaria.postgresql.org; Wed, 04 Sep 2024 16:55:34 +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 1sltI5-00CR7w-7t for pgsql-bugs@arkaria.postgresql.org; Wed, 04 Sep 2024 16:55:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sltI4-00CR6z-VM for pgsql-bugs@lists.postgresql.org; Wed, 04 Sep 2024 16:55:33 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sltI3-0009Ib-2Y for pgsql-bugs@lists.postgresql.org; Wed, 04 Sep 2024 16:55:32 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 484GtO4w1661517; Wed, 4 Sep 2024 12:55:24 -0400 From: Tom Lane To: =?UTF-8?Q?Fran=C3=A7ois_Jourdain?= cc: pgsql-bugs@lists.postgresql.org Subject: Re: bug when using special caracter in password for folder. In-reply-to: References: Comments: In-reply-to =?UTF-8?Q?Fran=C3=A7ois_Jourdain?= message dated "Wed, 04 Sep 2024 10:13:26 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <1661515.1725468924.1@sss.pgh.pa.us> Content-Transfer-Encoding: 8bit Date: Wed, 04 Sep 2024 12:55:24 -0400 Message-ID: <1661516.1725468924@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk =?UTF-8?Q?Fran=C3=A7ois_Jourdain?= writes: > I used a é in the password. Also, you can see the interface doesn't > support well french caracters. you should read S'il vous plaît in the > prompt. > the error i had, caused by é in the password, was : > postgresql l'installation peut avoir échoué l'initialisation du cluster > de bases de données a échoué What this sounds like is an encoding problem. Non-ASCII characters such as é have different bit-level representations depending on whether you are using UTF-8, ISO 8859-1, WIN1252, etc. Unfortunately there's usually not a lot Postgres can do about this kind of thing, since it's impossible to guess reliably what encoding a chunk of text is meant to be in. You have to be careful to configure your operating system environment so that the same encoding assumptions prevail throughout. In any case, we definitely can do nothing about it with zero context information. You didn't even mention what OS you're using. regards, tom lane