configuration problems with Debian and derivates

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

configuration problems with Debian and derivates

msm.scaglione

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


Is there a configuration problem with Debian and derivates?


thank you in advance



Reply | Threaded
Open this post in threaded view
|

Re: configuration problems with Debian and derivates

David G Johnston
On Tuesday, July 28, 2020, <[hidden email]> 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.
Reply | Threaded
Open this post in threaded view
|

Re: configuration problems with Debian and derivates

msm.scaglione

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 <[hidden email]> ha scritto:


On Tuesday, July 28, 2020, < [hidden email]> 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.
Reply | Threaded
Open this post in threaded view
|

Re: configuration problems with Debian and derivates

David G Johnston
On Tue, Jul 28, 2020 at 8:16 AM [hidden email] <[hidden email]> wrote:

I installed postgres following instructions in the pragraph

Included in distribution 

in

https://www.postgresql.org/download/linux/ubuntu/

starts


So PostgreSQL itself is functioning correctly.

but pgadminIII can't find local server

That is a third-party application which has been replaced with pgAdmin4.

You can probably solve the addressing problem by altering the configuration of the server to match what pgAdmin* is trying to communicate with, whether that be a the socket file or listening on a tcp/ip socket and connecting via the same.  That's a bit outside what I am able to provide help with at this time though.  But at least the server is running.

David J.

Reply | Threaded
Open this post in threaded view
|

Re: configuration problems with Debian and derivates [solved]

msm.scaglione
In reply to this post by msm.scaglione

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 ----------
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 <[hidden email]> ha scritto:


On Tuesday, July 28, 2020, < [hidden email]> 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.
Reply | Threaded
Open this post in threaded view
|

pgadmin4 can't start

msm.scaglione

I'm working on debian buster

I installed pgadmin4-desktop following instruction:

https://www.pgadmin.org/download/pgadmin-4-apt/

from terminal

cd /usr/pgadmin4/bin
./pgadmin4

Python path: "/usr/pgadmin4/venv/lib/python3.7:/usr/lib/python3.7/lib-dynload:/usr/pgadmin4/venv/lib/python3.7/site-packages"
Python Home: "/usr/pgadmin4/venv"
Webapp path: "/usr/pgadmin4/web/pgAdmin4.py"
Failed to connect to the server: "Connection closed" ( request URL: "http://127.0.0.1:5432/misc/ping?key=f600e8c7-9b4e-45f7-88c7-88e6fce18345" ).
Failed to connect to the server: "Connection closed" ( request URL: "http://127.0.0.1:5432/misc/ping?key=f600e8c7-9b4e-45f7-88c7-88e6fce18345" ).
Failed to connect to the server: "Connection closed" ( request URL: "http://127.0.0.1:5432/misc/ping?key=f600e8c7-9b4e-45f7-88c7-88e6fce18345" ).
Failed to connect to the server: "Connection closed" ( request URL: "http://127.0.0.1:5432/misc/ping?key=f600e8c7-9b4e-45f7-88c7-88e6fce18345" ).
Failed to connect to the server: "Connection closed" ( request URL: "http://127.0.0.1:5432/misc/ping?key=f600e8c7-9b4e-45f7-88c7-88e6fce18345" ).
Failed to connect to the server: "Connection closed" ( request URL: "http://127.0.0.1:5432/misc/ping?key=f600e8c7-9b4e-45f7-88c7-88e6fce18345" ).
Failed to connect to the server: "Connection closed" ( request URL: "http://127.0.0.1:5432/misc/ping?key=f600e8c7-9b4e-45f7-88c7-88e6fce18345" ).
Failed to connect to the server: "Connection closed" ( request URL: "http://127.0.0.1:5432/misc/ping?key=f600e8c7-9b4e-45f7-88c7-88e6fce18345" ).
Failed to connect to the server: "Connection closed" ( request URL: "http://127.0.0.1:5432/misc/ping?key=f600e8c7-9b4e-45f7-88c7-88e6fce18345" ).
* Serving Flask app "pgadmin" (lazy loading)
* Environment: production
WARNING: Do not use the development server in a production environment.
Use a production WSGI server instead.
* Debug mode: off

and then hundreds of rows like:

Failed to connect to the server: "Connection closed" ( request URL: "http://127.0.0.1:5432/misc/ping?key=f600e8c7-9b4e-45f7-88c7-88e6fce18345" ).


What's wrong in your opinion?

Pgadmin3 works well