public inbox for [email protected]
help / color / mirror / Atom feedconfiguration problems with Debian and derivates
6+ messages / 3 participants
[nested] [flat]
* configuration problems with Debian and derivates
@ 2020-07-28 09:19 [email protected]
2020-07-28 13:07 ` Re: configuration problems with Debian and derivates David G. Johnston <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: [email protected] @ 2020-07-28 09:19 UTC (permalink / raw)
To: [email protected] <[email protected]>
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: configuration problems with Debian and derivates
2020-07-28 09:19 configuration problems with Debian and derivates [email protected]
@ 2020-07-28 13:07 ` David G. Johnston <[email protected]>
2020-07-28 15:16 ` Re: configuration problems with Debian and derivates [email protected] <[email protected]>
0 siblings, 1 reply; 6+ messages in thread
From: David G. Johnston @ 2020-07-28 13:07 UTC (permalink / raw)
To: [email protected] <[email protected]>; +Cc: [email protected] <[email protected]>
On Tuesday, July 28, 2020, <[email protected]> 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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: configuration problems with Debian and derivates
2020-07-28 09:19 configuration problems with Debian and derivates [email protected]
2020-07-28 13:07 ` Re: configuration problems with Debian and derivates David G. Johnston <[email protected]>
@ 2020-07-28 15:16 ` [email protected] <[email protected]>
2020-07-28 15:47 ` Re: configuration problems with Debian and derivates David G. Johnston <[email protected]>
2020-07-31 09:17 ` Re: configuration problems with Debian and derivates [solved] [email protected]
0 siblings, 2 replies; 6+ messages in thread
From: [email protected] @ 2020-07-28 15:16 UTC (permalink / raw)
To: [email protected] <[email protected]>
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 <[email protected]> ha scritto:
>
>
> On Tuesday, July 28, 2020, < [email protected] mailto:[email protected] > 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.
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: configuration problems with Debian and derivates
2020-07-28 09:19 configuration problems with Debian and derivates [email protected]
2020-07-28 13:07 ` Re: configuration problems with Debian and derivates David G. Johnston <[email protected]>
2020-07-28 15:16 ` Re: configuration problems with Debian and derivates [email protected] <[email protected]>
@ 2020-07-28 15:47 ` David G. Johnston <[email protected]>
1 sibling, 0 replies; 6+ messages in thread
From: David G. Johnston @ 2020-07-28 15:47 UTC (permalink / raw)
To: [email protected] <[email protected]>; +Cc: [email protected] <[email protected]>
On Tue, Jul 28, 2020 at 8:16 AM [email protected] <
[email protected]> 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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: configuration problems with Debian and derivates [solved]
2020-07-28 09:19 configuration problems with Debian and derivates [email protected]
2020-07-28 13:07 ` Re: configuration problems with Debian and derivates David G. Johnston <[email protected]>
2020-07-28 15:16 ` Re: configuration problems with Debian and derivates [email protected] <[email protected]>
@ 2020-07-31 09:17 ` [email protected]
2020-07-31 09:41 ` pgadmin4 can't start [email protected]
1 sibling, 1 reply; 6+ messages in thread
From: [email protected] @ 2020-07-31 09:17 UTC (permalink / raw)
To: [email protected] <[email protected]>
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: "[email protected]" <[email protected]>
> A: "[email protected]" <[email protected]>
> 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 <[email protected]> ha scritto:
> >
> >
> > On Tuesday, July 28, 2020, < [email protected] mailto:[email protected] > 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.
> >
> > >
^ permalink raw reply [nested|flat] 6+ messages in thread
* pgadmin4 can't start
2020-07-28 09:19 configuration problems with Debian and derivates [email protected]
2020-07-28 13:07 ` Re: configuration problems with Debian and derivates David G. Johnston <[email protected]>
2020-07-28 15:16 ` Re: configuration problems with Debian and derivates [email protected] <[email protected]>
2020-07-31 09:17 ` Re: configuration problems with Debian and derivates [solved] [email protected]
@ 2020-07-31 09:41 ` [email protected]
0 siblings, 0 replies; 6+ messages in thread
From: [email protected] @ 2020-07-31 09:41 UTC (permalink / raw)
To: [email protected] <[email protected]>
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2020-07-31 09:41 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-07-28 09:19 configuration problems with Debian and derivates [email protected]
2020-07-28 13:07 ` David G. Johnston <[email protected]>
2020-07-28 15:16 ` [email protected] <[email protected]>
2020-07-28 15:47 ` David G. Johnston <[email protected]>
2020-07-31 09:17 ` Re: configuration problems with Debian and derivates [solved] [email protected]
2020-07-31 09:41 ` pgadmin4 can't start [email protected]
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox