Thread: configuration problems with Debian and derivates
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
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 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.
I installed postgres following instructions in the pragraph
Included in distribution
in
https://www.postgresql.org/download/linux/ubuntu/
starts
but pgadminIII can't find local server
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:16Oggetto: Re: configuration problems with Debian and derivatesI 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.
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