Search Postgresql Archives

RE: FW: Error!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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!

 

Sent from Mail for Windows

 

From: postgresql439848@xxxxxxxxxxx
Sent: Tuesday, April 25, 2023 9:05 PM
To: pgsql-general@xxxxxxxxxxxxxxxxxxxx; adrian.klaver@xxxxxxxxxxx; puntal8@xxxxxxxxxxx
Subject: Re: FW: Error!

 

Am 25.04.23 um 17:02 schrieb Adrian Klaver:

On 4/25/23 07:31, postgresql439848@xxxxxxxxxxx wrote:

Am 25.04.23 um 01:16 schrieb Arquimedes Aguirre:


No, it has not changed the error that I have been experiencing since the beginning. This is the error:

psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "punta" Press any key to continue . .

...


Hi,

is it possible that postgres is listening on ipv4(127.0.0.1) only and you trying connect to ipv6(::1)?

try connect to 127.0.0.1 as "server" instead of "localhost".


Then you would get this error:

psql: error: connection to server at "::1", port 5432 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?

OK, my mistake.
but is there a possibility to put in the same (may be copy/paste) credentials with different clients and cause this error?

spoiler: there are many and the password 123456 was invented for this case.
conclusion: after a few tests i would bet on a password which causes an ugly hiccup and this could be not users fail.

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.

conclusion: see above


the hardest fail:
i tried first of all something like "special" password for superuser during installation and get lost without any idea why.

error: "failed to load SQL modules into the database cluster."
next one follows, warning: "Problem running post-install step. Installation may not complete correctly
Error reading file C:/Program Files/PostgreSQL/15/data/postgresql.conf"
result: initialization failed, data directory doesn't exist.
the final shot is the installation-summary log, no errors, no comments about that even something could be not as expected.

how someone would see this and get to understanding that his/her keyboard has wrong keys to type right passwords?


PS to whom it may concern:
it's not my problem and i don't use it this way.
but other people have no choice.
safe the lost souls, do it better, please!

A.H.

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux