Re: configuration problems with Debian and derivates [solved]

From: msm(dot)scaglione(at)libero(dot)it
To: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: Re: configuration problems with Debian and derivates [solved]
Date: 2020-07-31 09:17:24
Message-ID: 967284319.120795.1596187044423@mail1.libero.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(dot)scaglione(at)libero(dot)it" <msm(dot)scaglione(at)libero(dot)it>
> A: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)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(dot)g(dot)johnston(at)gmail(dot)com> ha scritto:
> >
> >
> > On Tuesday, July 28, 2020, < msm(dot)scaglione(at)libero(dot)it mailto:msm(dot)scaglione(at)libero(dot)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.
> >
> > >

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message msm.scaglione 2020-07-31 09:41:24 pgadmin4 can't start
Previous Message Stephen Frost 2020-07-30 14:36:00 Re: PGSQL returning into in insert statement