From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: user credentials rejected by pgAdmin right after new install
Date: Mon, 21 Nov 2022 08:08:36 -0600
Message-ID: <79a5a7cf-ad30-6b22-70d2-c9092074a1f1@gmail.com> (raw)
In-Reply-To: <adc05758-d860-a4e6-914d-348c0953ed6f@jakobs.com>
References: <CAB3gnPXv3ai4gPaT9VzvPwxub9FxxsPY+ZY15Si=EJ1hhvK4dg@mail.gmail.com>
<adc05758-d860-a4e6-914d-348c0953ed6f@jakobs.com>
"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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: user credentials rejected by pgAdmin right after new install
In-Reply-To: <79a5a7cf-ad30-6b22-70d2-c9092074a1f1@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox