I read
https://medium.com/@wajeeh.ahsan/fatal-peer-authentication-failed-for-user-postgres-954e061c7368
then from terminal:
su
su - postgres
psql
\password postgres
now pgadmin3 finds local server
---------- Messaggio originale ----------
Da: "msm.scaglione@libero.it" <msm.scaglione@libero.it>
A: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Data: 28/07/2020 17:16
Oggetto: Re: configuration problems with Debian and derivates
I installed postgres following instructions in the pragraph
Included in distribution
in
https://www.postgresql.org/download/linux/ubuntu/
then
sudo apt-get install pgadmin3
because pgadmin4 is not in the repositories but a previou attempt adding pgadmin4 repositories gave the same relsults with pgadmin4 too
from terminal
su
su - postgres
psql
starts
but pgadminIII can't find local server
Il 28/07/2020 15:07 David G. Johnston <david.g.johnston@gmail.com> ha scritto:
On Tuesday, July 28, 2020, < msm.scaglione@libero.it> wrote:
I need to work with postgresql with Debian bat Pgadmin can't find the locahost server
I supposed it were only a problem of mine. I installed virtualbox and xubuntu on it: pgadmin can't find local server just like on debian
I followed the installation instruction in the official site
I use Ubuntu in VirtualBox just fine. You should provide more detail as to you exact setup, including what is running on the host and what is in the client. Installation commands. Skip pgAdmin and check with psql and show its command line. Etc...
David J.
