Re: The postgres server don't work - Mailing list pgsql-general

From Mohammed falih
Subject Re: The postgres server don't work
Date
Msg-id CADqaUh_hF2HpUdx-yhFx8daUFnLQO1=VzpNONfLjNCN3758cpw@mail.gmail.com
Whole thread Raw
In response to Re: The postgres server don't work  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
yes sorry I wrote this sentence before try the solution you offered 

yes by deleting the changes (the Autorun) 

and thank you so much for your efforts ,I  have gone through this solution before but didn't help me to solve the problem ,when I  go to command prompt as administrator and insert chcp 1252 the command says 1252 is activated 
 and changed the font from the properties/font then click apply then open the sql shell the error still there even though the font look looks different than before 

On Sun, 9 Jan 2022, 2:40 am Adrian Klaver, <adrian.klaver@aklaver.com> wrote:
On 1/8/22 15:29, Mohammed falih wrote:
> yes I think the service doesn't even start

Yet below you said it does.

>
> I have only the default protection that comes with the operating system
>
> wow the postgres started working!! but the problem came back that talks

Did you revert the change you made earlier to get it to work?


> about console code " WARNING: Console code page (437) differs from
> Windows code page (1252)
>
> 8-bit characters mightnot  work correctly. See psql reference
>           page "Notes for Windows users"for  details."
>

So follow the instructions here :

https://www.postgresql.org/docs/current/app-psql.html

"
Notes for Windows Users

psql is built as a “console application”. Since the Windows console
windows use a different encoding than the rest of the system, you must
take special care when using 8-bit characters within psql. If psql
detects a problematic console code page, it will warn you at startup. To
change the console code page, two things are necessary:

     Set the code page by entering cmd.exe /c chcp 1252. (1252 is a code
page that is appropriate for German; replace it with your value.) If you
are using Cygwin, you can put this command in /etc/profile.

     Set the console font to Lucida Console, because the raster font
does not work with the ANSI code page.
"

In the terminal before running psql do:

cmd.exe /c chcp 1252



--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Mohammed falih
Date:
Subject: Re: The postgres server don't work
Next
From: Mohammed falih
Date:
Subject: Re: The postgres server don't work