RE: FW: Error!

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(dot)klaver(at)aklaver(dot)com>
Sent: Monday, May 29, 2023 12:12 PM
To: Arquimedes Aguirre<mailto:puntal8(at)hotmail(dot)com>; postgresql439848(at)heinz-it(dot)de<mailto:postgresql439848(at)heinz-it(dot)de>; pgsql-general(at)lists(dot)postgresql(dot)org<mailto:pgsql-general(at)lists(dot)postgresql(dot)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(dot)klaver(at)aklaver(dot)com