I don’t understand, please could to be more specific in the step that I must to do for to solve this inconvenience.
Thanks for advance! Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows From: Adrian Klaver<mailto:adrian.kla...@aklaver.com> Sent: Monday, May 29, 2023 12:12 PM To: Arquimedes Aguirre<mailto:punt...@hotmail.com>; postgresql439...@heinz-it.de<mailto:postgresql439...@heinz-it.de>; pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists.postgresql.org> Subject: Re: FW: Error! On 5/29/23 09:45, Arquimedes Aguirre wrote: > Hi, please could update the information about my error with the > initialization of psql shell. I am trying to get a connection to develop > a web project. > > Thanks for your attention and collaboration. > > Best regards! > > testing: > - windows installer with default settings, password is quite simple 123456. > - in pgadmin create a new role with "special" password(i take the german > specialties üöä or even some symbols). no errors. > - in pgadmin add new server with credentials of new role ... automatic > try to connect. connected! > looks like there is nothing wrong at all. > > BUT > - start the "SQL Shell" or try psql directly. > - default settings(localhost:5432:postgres:postgres) and the simple > password 123456 > - connected. may be a warning about encoding/codepage, but connected. > > try credentials for new role. result: see TO first/last message. > try change codepage (the docs says 1252 is appropriate for german). same > result. > password file in ANSI, same result. What is the encoding/locale for the database? To find out, in psql do \l <database_name> and post the result here. > > conclusion: see above > > A.H. > -- Adrian Klaver adrian.kla...@aklaver.com
