Re: BUG #18098: Console code page issue Postgresql 14.7

Hi Laurenz,
I have shared all the required details in previous mail, Kindly provide a
solution for this issue.

*Thanks & Regards,*
Gokul

On Fri, Sep 8, 2023 at 3:51 PM Gokul Krishnan <gokulkrishnan99102(at)gmail(dot)com>
wrote:

> Hi Laurenz,
> Apologies for the inconvenience,I have shared the detailed
> description below. Kindly provide a solution for this issue.
> I have tried to initialize data directory using this below command,
> *initdb.exe -D "..\data" -U postgres --no-locale -E UTF8*
>
> Exact error returned by postgres,
>
>
> *initdb: error: The program "postgres" was found by
> "E:\pgsql\bin/initdb.exe"but was not the same version as initdb.Check your
> installation.*
> [image: image.png]
>
>
> I have tried with different chcp values(1252,437.. etc) that are supported
> by postgres <https://www.postgresql.org/docs/current/multibyte.html> but
> doesn't work for my case(encoding command also changed according to
> registry chcp value) .If I remove the *Active code page : 65001* from the
> registry editor, then the above mentioned initdb command executes
> successfully.
>
> Successful execution log for your reference,
>
>
>
>
>
> *Microsoft Windows [Version 10.0.19045.3324](c) Microsoft Corporation. All
> rights reserved.E:\pgsql\bin>initdb.exe -D "..\data" -U postgres
> --no-locale -E UTF8The files belonging to this database system will be
> owned by user "gokul".*
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *This user must also own the server process.The database cluster will be
> initialized with locale "C".The default text search configuration will be
> set to "english".Data page checksums are disabled.creating directory
> ../data ... okcreating subdirectories ... okselecting dynamic shared memory
> implementation ... windowsselecting default max_connections ...
> 100selecting default shared_buffers ... 128MBselecting default time zone
> ... Asia/Calcuttacreating configuration files ... okrunning bootstrap
> script ... okperforming post-bootstrap initialization ... oksyncing data to
> disk ... okinitdb: warning: enabling "trust" authentication for local
> connectionsYou can change this by editing pg_hba.conf or using the option
> -A, or--auth-local and --auth-host, the next time you run initdb.Success.
> You can now start the database server using: pg_ctl -D ^"^.^.^\data^" -l
> logfile start*
>
> [image: image.png]
>
> Registry Editor key I have removed,
> *Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Command Processor\Autorun
> -> *Removed the *Value data(chcp 65001)* content.
>
> [image: image.png]
>
> My Current System locale is *English (United States)*
>
> [image: image.png]
>
> *Thanks & Regards,*
> Gokul
>
>
> On Fri, Sep 8, 2023 at 12:17 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
> wrote:
>
>> On Fri, 2023-09-08 at 12:02 +0530, Gokul Krishnan wrote:
>> > Kindly provide the solution accordingly.
>>
>> Kindly provide a good problem description. Don't say "I run initdb.exe",
>> tell us how exactly you ran it, and what you ran before that to provoke
>> the error.
>> What was your OS locale at that time? What was the exact error message?
>> What exactly did you have to change in the registry to make the problem
>> go away?
>>
>> Yours,
>> Laurenz Albe
>>
>