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.klaver@aklaver.com