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@xxxxxxxxxxx
