Hello - About how to install PgAdmin4 on Debian 10

On 24/03/2021 17:17, Carlos Montenegro wrote:

Hello dear community.
your help !

I am trying to install PgAdmin4 on Debian 10 following the instructions
on here:
https://wiki.postgresql.org/wiki/Apt <https://wiki.postgresql.org/wiki/Apt&gt;

but when execute:

sudo apt-get install pgadmin4 or
sudo apt-get install pgadmin4 pgadmin4-apache2

the system says: The package pgadmin4 does not have any candidate for
installation.

On my laptop (Debian Buster), "apt-cache search pgadmin4" finds the
following:

pgadmin4-desktop
pgadmin4-server
pgadmin4-web
pgadmin4

I don't see "pgadmin4-apache2" there. I have pgadmin4-server and
pgadmin4-desktop installed and working fine.

Ray.

--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie

Hello dear Ray.
Thanks for your answer.

Yes, I see pgadmin4 and then tried, but any success.
How did you make the installation? Any advice?

Best,
Carlos

On Wed, Mar 24, 2021 at 12:36 PM Ray O'Donnell <ray@rodonnell.ie> wrote:

On 24/03/2021 19:08, Carlos Montenegro wrote:

Hello dear Ray.
Thanks for your answer.

Yes, I see pgadmin4 and then tried, but any success.
How did you make the installation? Any advice?

Hi Carlos,

I had forgotten - pgAdmin has its own apt repository, which you need to add:

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

Once you've done that, then "apt update" and "apt install..." should do
the job.

I hope this helps.

Ray.

--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie

Yes Ray,
I followed those instructions, but it seems the repository location
changed. It is not available, but thank you so much for your support.

Best,
Carlos

On Wed, Mar 24, 2021 at 1:55 PM Ray O'Donnell <ray@rodonnell.ie> wrote:

On 24/03/2021 20:17, Carlos Montenegro wrote:

Yes Ray,
I followed those instructions, but it seems the repository location
changed. It is not available, but thank you so much for your support.

It seems to be available for me:

$ sudo apt update

[....]

Hit:10 https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/buster
pgadmin4 InRelease

[....]

Sorry if it's a silly question, but are you sure that you added the
pgAdmin repo (at ftp.postgresql.org) as opposed to the main PostgreSQL
repo (at apt.postgresql.org)?

Best,

Ray.

--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie

On 3/24/21 1:17 PM, Carlos Montenegro wrote:

Yes Ray,
I followed those instructions, but it seems the repository location
changed. It is not available, but thank you so much for your support.

It worked for me using the instructions listed here(per Ray's post):

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

Best,
Carlos

On Wed, Mar 24, 2021 at 1:55 PM Ray O'Donnell <ray@rodonnell.ie
<mailto:ray@rodonnell.ie>> wrote:

On 24/03/2021 19:08, Carlos Montenegro wrote:

Hello dear Ray.
Thanks for your answer.

Yes, I see pgadmin4 and then tried, but any success.
How did you make the installation? Any advice?

Hi Carlos,

I had forgotten - pgAdmin has its own apt repository, which you need
to add:

https://www.pgadmin.org/download/pgadmin-4-apt/
<https://www.pgadmin.org/download/pgadmin-4-apt/&gt;

Once you've done that, then "apt update" and "apt install..." should do
the job.

I hope this helps.

Ray.

--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie <mailto:ray@rodonnell.ie>

--
Adrian Klaver
adrian.klaver@aklaver.com

Hello dear Adrian and Ray.
Good day !

Thank you both for helping me.
It has worked and have installed pgadmin4, but have this issue when try to
open the server:

pgAdmin4 server could not be contacted
Any suggestions?
Best

On Wed, Mar 24, 2021 at 4:10 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 3/25/21 12:49 PM, Carlos Montenegro wrote:

Hello dear Adrian and Ray.
Good day !

Thank you both for helping me.
It has worked and have installed pgadmin4, but have this issue when try
to open the server:

What packages did you install?

Define open server.

What is the complete text of the actual error message?

pgAdmin4 server could not be contacted
Any suggestions?
Best

On Wed, Mar 24, 2021 at 4:10 PM Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:

On 3/24/21 1:17 PM, Carlos Montenegro wrote:

Yes Ray,
I followed those instructions, but it seems the repository location
changed. It is not available, but thank you so much for your support.

It worked for me using the instructions listed here(per Ray's post):

https://www.pgadmin.org/download/pgadmin-4-apt/
<https://www.pgadmin.org/download/pgadmin-4-apt/&gt;

Best,
Carlos

On Wed, Mar 24, 2021 at 1:55 PM Ray O'Donnell <ray@rodonnell.ie

<mailto:ray@rodonnell.ie>

<mailto:ray@rodonnell.ie <mailto:ray@rodonnell.ie>>> wrote:

     On 24/03/2021 19:08, Carlos Montenegro wrote:
      > Hello dear Ray.
      > Thanks for your answer.
      >
      > Yes, I see pgadmin4 and then tried, but any success.
      > How did you make the installation? Any advice?

     Hi Carlos,

     I had forgotten - pgAdmin has its own apt repository, which

you need

     to add:

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

<https://www.pgadmin.org/download/pgadmin-4-apt/&gt;

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

<https://www.pgadmin.org/download/pgadmin-4-apt/&gt;&gt;

     Once you've done that, then "apt update" and "apt install..."

should do

     the job.

     I hope this helps.

     Ray.

     --
     Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie <mailto:ray@rodonnell.ie>

<mailto:ray@rodonnell.ie <mailto:ray@rodonnell.ie>>

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

Hello Adrian.
First I installed postgresql version 12.6 then for pgadmin4 followed this
guide: https://www.pgadmin.org/download/pgadmin-4-apt/

So, when try to open pgadmin have the next message:

The PgAdmin4 server could not be contacted:

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "/usr/pgadmin4/venv/bin/python3"
Runtime Config File: "/home/ics-debian/.config/pgadmin/runtime_config.json"
pgAdmin Config File: "/usr/pgadmin4/web/config.py"
Webapp Path: "/usr/pgadmin4/web/pgAdmin4.py"
pgAdmin Command: "/usr/pgadmin4/venv/bin/python3 -s
/usr/pgadmin4/web/pgAdmin4.py"
Environment:
- USER: ics-debian
- LANGUAGE: es_NI:es
- XDG_SEAT: seat0
- XDG_SESSION_TYPE: x11
- SSH_AGENT_PID: 1330
- HOME: /home/ics-debian
- DESKTOP_SESSION: lightdm-xsession
- XDG_SEAT_PATH: /org/freedesktop/DisplayManager/Seat0
- GTK_MODULES: gail:atk-bridge
- DBUS_SESSION_BUS_ADDRESS: unix:path=/run/user/1000/bus
- GLADE_MODULE_PATH: :
- LOGNAME: ics-debian
- XDG_SESSION_CLASS: user
- XDG_SESSION_ID: 2
- PATH: /usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
- GLADE_PIXMAP_PATH: :
- XDG_SESSION_PATH: /org/freedesktop/DisplayManager/Session0
- XDG_RUNTIME_DIR: /run/user/1000
- XDG_MENU_PREFIX: xfce-
- LANG: es_NI.UTF-8
- XDG_CURRENT_DESKTOP: XFCE
- XDG_SESSION_DESKTOP: lightdm-xsession
- XAUTHORITY: /home/ics-debian/.Xauthority
- XDG_GREETER_DATA_DIR: /var/lib/lightdm/data/ics-debian
- SSH_AUTH_SOCK: /tmp/ssh-7U4tMKJqlRu8/agent.1299
- GLADE_CATALOG_PATH: :
- SHELL: /bin/bash
- GDMSESSION: lightdm-xsession
- QT_ACCESSIBILITY: 1
- XDG_VTNR: 7
- PWD: /home/ics-debian
- XDG_DATA_DIRS: /usr/share/xfce4:/usr/local/share/:/usr/share/:/usr/share
- XDG_CONFIG_DIRS: /etc/xdg
- SESSION_MANAGER: local/ics-debian:@
/tmp/.ICE-unix/1340,unix/ics-debian:/tmp/.ICE-unix/1340
- DISPLAY: :0.0
- GDK_BACKEND: x11
- NO_AT_BRIDGE: 1
- PGADMIN_INT_PORT: 5433
- PGADMIN_INT_KEY: f6b73bcd-abb3-42b8-9bf2-c8d47536c80e
- PGADMIN_SERVER_MODE: OFF
--------------------------------------------------------

Failed to launch pgAdmin4. Error:
Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT

Thank you in advance,
Carlos

On Thu, Mar 25, 2021 at 4:14 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 3/26/21 11:00 AM, Carlos Montenegro wrote:

Hello Adrian.
First I installed postgresql version 12.6 then for pgadmin4 followed
this guide: https://www.pgadmin.org/download/pgadmin-4-apt/
<https://www.pgadmin.org/download/pgadmin-4-apt/&gt;

There are three choices in the above as to what mode to install as,
please indicate which one you chose as well as the command executed.

So, when  try to open pgadmin have the next message:

The PgAdmin4 server could not be contacted:

pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "/usr/pgadmin4/venv/bin/python3"
Runtime Config File: "/home/ics-debian/.config/pgadmin/runtime_config.json"
pgAdmin Config File: "/usr/pgadmin4/web/config.py"
Webapp Path: "/usr/pgadmin4/web/pgAdmin4.py"
pgAdmin Command: "/usr/pgadmin4/venv/bin/python3 -s
/usr/pgadmin4/web/pgAdmin4.py"
Environment:
  - USER: ics-debian
  - LANGUAGE: es_NI:es
  - XDG_SEAT: seat0
  - XDG_SESSION_TYPE: x11
  - SSH_AGENT_PID: 1330
  - HOME: /home/ics-debian
  - DESKTOP_SESSION: lightdm-xsession
  - XDG_SEAT_PATH: /org/freedesktop/DisplayManager/Seat0
  - GTK_MODULES: gail:atk-bridge
  - DBUS_SESSION_BUS_ADDRESS: unix:path=/run/user/1000/bus
  - GLADE_MODULE_PATH: :
  - LOGNAME: ics-debian
  - XDG_SESSION_CLASS: user
  - XDG_SESSION_ID: 2
  - PATH: /usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
  - GLADE_PIXMAP_PATH: :
  - XDG_SESSION_PATH: /org/freedesktop/DisplayManager/Session0
  - XDG_RUNTIME_DIR: /run/user/1000
  - XDG_MENU_PREFIX: xfce-
  - LANG: es_NI.UTF-8
  - XDG_CURRENT_DESKTOP: XFCE
  - XDG_SESSION_DESKTOP: lightdm-xsession
  - XAUTHORITY: /home/ics-debian/.Xauthority
  - XDG_GREETER_DATA_DIR: /var/lib/lightdm/data/ics-debian
  - SSH_AUTH_SOCK: /tmp/ssh-7U4tMKJqlRu8/agent.1299
  - GLADE_CATALOG_PATH: :
  - SHELL: /bin/bash
  - GDMSESSION: lightdm-xsession
  - QT_ACCESSIBILITY: 1
  - XDG_VTNR: 7
  - PWD: /home/ics-debian
  - XDG_DATA_DIRS:
/usr/share/xfce4:/usr/local/share/:/usr/share/:/usr/share
  - XDG_CONFIG_DIRS: /etc/xdg
  - SESSION_MANAGER:
local/ics-debian:@/tmp/.ICE-unix/1340,unix/ics-debian:/tmp/.ICE-unix/1340
  - DISPLAY: :0.0
  - GDK_BACKEND: x11
  - NO_AT_BRIDGE: 1
  - PGADMIN_INT_PORT: 5433
  - PGADMIN_INT_KEY: f6b73bcd-abb3-42b8-9bf2-c8d47536c80e
  - PGADMIN_SERVER_MODE: OFF
--------------------------------------------------------

Failed to launch pgAdmin4. Error:
Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT

Thank you in advance,
Carlos

--
Adrian Klaver
adrian.klaver@aklaver.com

Install docker and pull dpage/pgadmin4.

Seriously. It just works. All of the time, every time, with updates. Docker
is amazing.

On Fri, Mar 26, 2021, 2:55 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 3/26/21 1:21 PM, Benedict Holland wrote:

Install docker and pull dpage/pgadmin4.

Seriously. It just works. All of the time, every time, with updates.
Docker is amazing.

Or better yet use psql. No containers and greater productivity.

--
Adrian Klaver
adrian.klaver@aklaver.com

Hello Carlos,

This sounds like a different issue, and you would have more luck asking
about it on the pgadmin-support list [1]https://www.pgadmin.org/support/list/, which the developers follow.

If you can, include the relevant bits from the pgAdmin log, which
according to [2]https://www.pgadmin.org/faq/#8 should be here:

~/.pgadmin/pgadmin4.log

Ray.

[1]: https://www.pgadmin.org/support/list/

[2]: https://www.pgadmin.org/faq/#8

--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie

On 27/03/2021 14:59, Ray O'Donnell wrote:

If you can, include the relevant bits from the pgAdmin log, which
according to [2] should be here:

 ~/.pgadmin/pgadmin4.log

A quick find + grep also found me these:

~/.local/share/pgadmin4.startup.log
~/.local/share/pgadmin/pgadmin4/.pgAdmin4.startup.log

...though the second one is much older.

Ray.

--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie

The containers for postgres and pgadmin4 are incredible. This entire
thread, worrying about configurations settings and options, it all
disappears. You just run the container. There are tutorials to help you get
it set up with nginx. It just works. The developers and maintainers have
done an incredible job making it ridiculously easy to just make it work.

Thanks,
Ben

On Sat, Mar 27, 2021, 11:15 AM Ray O'Donnell <ray@rodonnell.ie> wrote: