Re: user credentials rejected by pgAdmin right after new install

"Wrong credentials" means that pgAdmin successfully connected to the
Postgresql server.  OP just couldn't log in.

On 11/21/22 01:38, Holger Jakobs wrote:
>
> Hi Frank
>
> Using pgAdmin is generally fine, but not helpful in case you're trying to
> find an error regarding connecting to the server.
>
> Be aware that the pgAdmin mailing list isn't this one. pgAdmin is a
> different project.
>
> Try to connect using psql, which is the only "official" frontend.
>
> Watch out for the setting listen_addresses in postgresql.conf and
> appropriate entries in pg_hba.conf, as without correct values there no
> connection is possible. Often, listen_addresses doesn't allow remote
> connections with the default setting.
>
> If you are connecting with pgAdmin from the same machine (NOT via TCP/IP),
> then you can use a local socket (AF_UNIX) and enter the path of the socket
> files instead of the IP address or the name of the server. pgAdmin can
> handle this, as psql, but DBeaver for instance cannot.
>
> Best Regards,
>
> Holger
>
> Am 20.11.22 um 19:59 schrieb Frank Rueter:
>> Hi,
>>
>> I have to install postgres on my QNAP TVS-1271U-RP but am no pro, so
>> hopefully this is an easy beginners mistake:
>>
>> * via DockerStation on the QNAP I installed postgres and pgadmin via
>> this docker compose <https://github.com/khezen/compose-postgres>
>> * the only thing I changed in the process was the POSTGRES_PASSWORD in
>> the yml.
>> * after successful install I went to pgadmin, clicked "add new server"
>> and entered the server's ip address along with the POSTGRES_USER and
>> POSTGRES_PASSWORD values from the yml file.
>> * However, pgadmin says that those are the wrong user credentials.
>> * I logged into the docker terminal for my docker container and checked
>> the environment which confirms the above values are indeed correct.
>>
>>
>> I used to have this running once in the past but decided to uninstall
>> everything and start from scratch for several reasons. After several
>> hours of trying I just cannot figure out what I am missing to get this going.
>>
>> If someone would be able to assist with this, that would be amazing.
>>
>> Cheers,
>> frank
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

--
Angular momentum makes the world go 'round.