From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: user credentials rejected by pgAdmin right after new install
Date: Mon, 21 Nov 2022 08:38:47 +0100
Message-ID: <adc05758-d860-a4e6-914d-348c0953ed6f@jakobs.com> (raw)
In-Reply-To: <CAB3gnPXv3ai4gPaT9VzvPwxub9FxxsPY+ZY15Si=EJ1hhvK4dg@mail.gmail.com>
References: <CAB3gnPXv3ai4gPaT9VzvPwxub9FxxsPY+ZY15Si=EJ1hhvK4dg@mail.gmail.com>
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
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
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: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: user credentials rejected by pgAdmin right after new install
In-Reply-To: <adc05758-d860-a4e6-914d-348c0953ed6f@jakobs.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