Обсуждение: 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>
> 
> 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

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

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/>
> 
>     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

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/>
>      >
>      > 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/>
>      >     <https://www.pgadmin.org/download/pgadmin-4-apt/
>     <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 <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

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/>

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

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], which the developers follow.

If you can, include the relevant bits from the pgAdmin log, which 
according to [2] 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