Questions tagged [pgadmin]

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL

Filter by
Sorted by
Tagged with
0 votes
0 answers
19 views

Why I failed to install pgadmin?

I try to install pgadmin under ubuntu 20.04 reading article at https://linuxhint.com/best_gui_clients_postgresql_ubuntu/ but after some attempts I got error message : hoster@hoster-os:~/Downloads$ ...
user avatar
0 votes
0 answers
9 views

Download pgAdmin4 on Ubuntu 22.04 [duplicate]

I'm trying to download pgAdmin4 on Ubuntu 22.04 Desktop but it shows this: E: The repository 'https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/jammy pgadmin4 InRelease' is not signed. N: Updating ...
user avatar
0 votes
0 answers
566 views

Pgadmin 4 installation on ubuntu 22.04

Looking to install pgadmin4 to ubuntu 22.04. I used the following: curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add Warning: apt-key is deprecated. Manage keyring files ...
user avatar
  • 1
0 votes
0 answers
15 views

pgAdmin 4 data and application menu text dissapear

Has anyone experienced menu text and data in general disappearing (not rendering on the UI) in pgAdmin 4 on Ubuntu?
user avatar
1 vote
1 answer
1k views

Can't install pgadmin4 on Ubuntu 21.10 / SOLVED with how to make a terminal command alias

Alright folks, going a bit crazy here. I'm running Ubuntu 21.10 impish off of an external ssd. Things are working well, trying to install pgadmin4 by following the guide here: https://www.pgadmin.org/...
user avatar
0 votes
0 answers
205 views

Apache error running the pgadmin4

Suddenly my pgadmin4 web version crashed. After I tried sudo systemctl restart apache2.service I received following error: Job for apache2.service failed because the control process exited with error ...
user avatar
0 votes
2 answers
1k views

Cannot change PostgresSQL default user password

Recently I have faced with issue that I cannot change password that is used in pgAdmin for connection to remote database ... In pg_hba.conf (PostgresSQL 12) I have the following login capabilities: # ...
user avatar
4 votes
1 answer
2k views

The pgAdmin 4 server could not be contacted error on Ubuntu 21.10

i installed pgAdmin but when i open it i get this error : Failed to launch pgAdmin4. Error: Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT when i tap this command : sudo python3 /usr/share/...
user avatar
  • 41
1 vote
0 answers
29 views

How to install pgAdmin4 in ubuntu 21.10? [duplicate]

I am trying to install pgAdmin4 in my Ubuntu 21.10, I followed this official blog : https://www.pgadmin.org/download/pgadmin-4-apt/ after running # Create the repository configuration file: sudo sh -c ...
user avatar
1 vote
1 answer
635 views

How can I see only the database I have access to in pgAdmin 4?

I created a free postgres database on Heroku, when connecting it to my pgAdmin4 the connection is done normally, however, thousands of databases appear along with mine. All the databases that appear I ...
user avatar
0 votes
1 answer
2k views

Pgadmin4 installation fails on Ubuntu 18.04 Bionic Beaver

I am trying to install pgadmin4 on Ubuntu 18.04 Bionic Beaver but every time I try to run the sudo apt install pgadmin4 pgadmin4-apache2 it returns the following error: Building dependency tree ...
user avatar
1 vote
2 answers
3k views

FATAL: password authentication failed for user "postgres" Ubuntu v20.10

I already installed pgadmin4 following https://www.pgadmin.org/download/pgadmin-4-apt/ documentation on ubuntu 20.10. I created a user with an email and a password, then I logged and I got into the ...
user avatar
1 vote
0 answers
190 views

PgAdmin 4 in standalone desktop mode-Error

I have followed the steps mentioned here, the 2nd Answer: Install dependencies, create a virtual environment, download, install & configure When I execute the following command: $ python3 lib/...
user avatar
0 votes
1 answer
4k views

pgAdmin4 doesn't open the correct web browser

Context I've installed pgAdmin4 using the APT installation procedure on Ubuntu 18.04 (default package without this new apt repository ships pgAdmin in version 3, which is deprecated). This is how my ...
user avatar
  • 690
2 votes
1 answer
44k views

could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?

When I want to open pgAdmin 4, this message appears: could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? ...
user avatar
  • 133
1 vote
0 answers
106 views

pgAdmin4 will open as if it was a book after switching desktop environments

I use KDE Plasma on Ubuntu. I started a session on regular Ubuntu desktop then switched back. Now, pgAdmin will open on Calibre (ebook management sofware). I tried running pgadmin4 directly on the ...
user avatar
  • 73
0 votes
1 answer
265 views

Please help - error: Ignoring file 'pg' in directory

Good day, i am trying to install postgresql and pgadmin on my ubuntu 20.04... i was stocked with this error when i run: sudo apt-get update error: N: Ignoring file 'pg' in directory '/etc/apt/...
user avatar
4 votes
2 answers
5k views

pgAdmin4 stopped working after latest upgrade Ubuntu 16.04. 'Request' object has no attribute 'is_json'

pgadmin4 is running perfectly before the system update of ubuntu 16.04 I didn't actually check what are those updates. But after the update and I tried running pgAdmin, it boots up and shows the ...
user avatar
3 votes
0 answers
9k views

pgadmin4 package has no installation candidate

1 - Create the file /etc/apt/sources.list.d/pgdg.list and add a line for the repository deb [arch=amd64] http://apt.postgresql.org/pub/repos/apt/ focal-pgdg main 2 - Import the repository signing ...
user avatar
4 votes
2 answers
3k views

PostgreSQL admin tool behind nginx

I have a VPS with PostgreSQL installed. I've nginx setup with a bunch of reverse proxies to different tools, grafana, Node.js sites and so on. I'm trying to setup PostgreSQL right now, and I just can'...
user avatar
19 votes
3 answers
40k views

Can't install pgAdmin 4 on 20.04 LTS

Basically, follow the steps as outlined here: https://wiki.postgresql.org/wiki/Apt. sudo apt-get install curl ca-certificates gnupg curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-...
user avatar
  • 437
1 vote
1 answer
2k views

pgAdmin4 got removed after upgrading from Ubuntu 18.04 to 19.10

I just upgraded from Ubuntu 18.04 to 19.10. After upgrade I noticed that pgAdmin4 got removed while other softwares are still present and now when I try to install pgadmin4 from the terminal, I get: ...
user avatar
1 vote
1 answer
8k views

How do I restart pgAdmin? [closed]

I'm using Ubuntu. I can't see any data and stuck on loading when pgAdmin window is idle for a while. How to restart pgAdmin in Ubuntu?
user avatar
4 votes
1 answer
5k views

Re-install of pgAdmin4 on Ubuntu 18.04 does not prompt for user/password and local pgAdmin site not found

I initially followed instructions to install postgres and pgadmin4 from https://tecadmin.net/install-pgadmin4-on-ubuntu/ successfully. I seemed to be able to get to the site at http://localhost/...
user avatar
0 votes
2 answers
1k views

Unable to start Apache2 server on Ubuntu 18.04

So the error says that the address is already in use. I have configured the /etc/hosts with some DNS mapping to a few domains. Not sure if this is causing the problem.
user avatar
  • 1
1 vote
1 answer
2k views

pgadmin4 401 Unauthorized in Ubuntu 18.04

I get the message: "The server could not verify that you are authorized to access the URL requested. You either supplied the wrong credentials (e.g. a bad password), or your browser doesn't understand ...
user avatar
1 vote
0 answers
418 views

403 Forbbiten error on pgadmin4

I follow tutorial from here "How To Install and Configure pgAdmin 4 in Server Mode" and everything is ok, only when I call in browser my server IP I get 403 Forbbiten error. My /etc/apache2/sites-...
user avatar
  • 123
1 vote
1 answer
5k views

Installed pgadmin4-apache2 package post-installation script subprocess returned error exit status 1

I'm trying to install pgAdmin4 desktop mode, Facing this Issue. It show pgAdmin4 and pgadmin4-apache2 installed. but while opening the pgAdmin4 application it display an error on popup Failed to ...
user avatar
1 vote
0 answers
2k views

Getting password authentication failed upon connecting to postgres db from pgadmin 3

I have an app deployed on Heroku that has a postgresql db added as an add-on, upon connecting to it from pgadmin3 for the first time it is getting connected but then afterwards on subsequent ...
user avatar
22 votes
2 answers
15k views

pgAdmin4 disable master password

When starting pgAdmin, I'm prompted: Please set a master password for pgAdmin This is a new feature of pgAdmin4 4.7: https://www.pgadmin.org/docs/pgadmin4/dev/release_notes_4_7.html How can I ...
user avatar
0 votes
4 answers
19k views

PgAdmin4 "the application server could not be contacted" Ubuntu 19.04

I updated my OS to Ubuntu 19.04. I had been using pgadmin4 on Ubuntu 18.10 and it worked without problems, but now that I have updated I get this error: the application server could not be ...
user avatar
  • 11
0 votes
1 answer
374 views

Installing pgAdmin 4 separately on Ubuntu 18.04

I've installed PostgreSQL on Ubuntu 18.04 and I want to install pgAdmin 4 on another Ubuntu box separately. Is it possible or any recommendation for that? Any help would be appreciated. Thanks
user avatar
  • 57
2 votes
2 answers
3k views

how to solve unmet dependencies with libpq5

I am trying to install pgAdmin4 in ubuntu 18.04, but I get the following error: The following packages have unmet dependencies: libpq-dev : Depends: libpq5 (= 10.6-0ubuntu0.18.04.1) but 11.2-1....
user avatar
  • 125
0 votes
1 answer
3k views

Can't install pgAdmin4

I am trying to install pgAdmin4 on Ubuntu 18.04 following this tutorial, but I get the following error with command pip install pgadmin4-2.1-py2.py3-none-any.whl: src/_fastmath.c:31:10: fatal error: ...
user avatar
  • 125
1 vote
0 answers
418 views

Pgadmin4: No module named 'idna'

Why do I get the error No module named 'idna' from Pgadmin4 when I try to save server properties?
user avatar
  • 287
0 votes
1 answer
4k views

Updating Pgadmin4 from 3.4 to 4.2

I have installed pgadmin4 and i can access it from browser everything is okay but it is showing a popup that the version is 3.4 and latest version is 4.2.I have to update it from 3.4 version to 4.2,...
user avatar
0 votes
2 answers
4k views

Root path for saved queries in pgAdmin 4

When I save or load a query in pgAdmin4 3.4, the file dialog shows just an empty directory named /. I can create folders inside it and I can save the query inside it. But I have no idea where this ...
user avatar
10 votes
5 answers
32k views

pgAdmin4 error "Failed to launch the application server, server thread exiting."

I'm getting this error on startup of pgAdmin4 on Kubuntu 18.04: An error occurred initialising the application server: Failed to launch the application server, server thread exiting. In the ...
user avatar
4 votes
1 answer
626 views

Problem with qt5 while trying to run pgadmin4

I have ubuntu bionic upgrade from xenial recently. After the upgrade, I didn't find my pgadmin4 application, so I reinstalled it. After clicking the pgadmin4 icon, the program not shown. So I try to ...
user avatar
8 votes
3 answers
6k views

Stop pgAdmin 4 from launching on boot (ubuntu 16.04)

Lately, pgAdmin would automatically launch on boot. I'm using KDE, and there is no entry for pgAdmin in Autostart, nor was there any in ~/.config/autostart (tho' I'm guessing Autostart uses the file ...
user avatar
0 votes
0 answers
2k views

pgAdmin4 not working - How to solve not listening 5432 on postgresql after set config file correctly

I am a novice ubuntu user. I am working on an ubuntu 18.04 VM on Windows10 machine through Putty. I installed postgreql & I am trying to install pgadmin4 but it's not working. When I run the ...
user avatar
  • 143
1 vote
1 answer
3k views

How to install PgAdmin4 on Ubuntu 18.04 Server mode

I am using an ubuntu 18.04 server through putty on windows 10. I am trying to install PgAdmin4 on it. I am using this tutorial for that: How to install PgAdmin4 on Ubuntu 18.04 Server mode When I ...
user avatar
  • 143
0 votes
1 answer
627 views

Problems with Ubuntu 18.04, Python 3.6.5, psql 10.4 and pgAdmin 1.22.2

Code did run with: Lubuntu 16.10, Python 3.5.2 (python3), psql 9.5.7 and pgAdmin 1.22.1. .... Also installed: Python 2.7.12 (python) Code does not run with: Ubuntu 18.04, Python 3.6.5 (python and ...
user avatar
5 votes
0 answers
13k views

Pgadmin 4 Not working in ubuntu 18.04 [closed]

I have installed postgres 10 and pgadmin4 in my Ubuntu 18.04 version. everything went fine. I cannot open the pgadmin gui. what might be the reason. it simply wont open. Does it require Qt? how do i ...
user avatar
  • 59
2 votes
2 answers
8k views

Run Pgadmin4 behind reverse proxy

I'm trying to run pgadmin4 behind an Nginx reverse proxy but I'm having an issue because I need for pgadmin to know it is at myhost.com/pgadmin and not simply at myhost.com.... or at least I think ...
user avatar
0 votes
1 answer
1k views

Pgadmin4 not running in python 3.6 and Ubuntu 17.10

I am new for pgadmin4. I have installed python 3.6. I try to install pgAdmin4 with this guide. But I am not able to run the pgadmin. Here are the commands I ran with the error messages: (pgadmin4) ...
user avatar
1 vote
2 answers
4k views

Error while installing pip install pgadmin4-1.4-py2.py3-none-any.whl

I am new to Ubuntu and I am trying to install pgadmin4 with pip install pgadmin4-1.4-py2.py3-none-any.whl But received the following error while installing pgadmin4: Command "python setup.py ...
user avatar
  • 11
0 votes
1 answer
847 views

Python 3 is crashing in Ubuntu 17.10 when using Firefox v57

While I was using firefox 57, python crashed and took a while to come back. Here's the apport report. ProblemType: Crash DistroRelease: Ubuntu 17.10 Package: apport-gtk 2.20.7-0ubuntu3.4 ...
user avatar
  • 91
0 votes
1 answer
3k views

pgadmin3 doesn't detect postgres

I successfully installed and downloaded pgadmin and postgresql. When I boot pgadmin3, The interface comes up successfully, but I can't see postgres, or any other servers. I tried changing ...
user avatar
118 votes
4 answers
268k views

How to install pgAdmin 4 in desktop mode on Ubuntu

How to install pgAdmin 4 in desktop mode? The documentation only details server mode.
user avatar
  • 9,173