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
40 views

The pgAdmin 4 server could not be contacted error after upgrade to 23.04

I just upgraded to 23.04 from 20.04, and pgAdmin 4 stopped working. I tried reinstalling and autoremove, but it didn't work. The pgAdmin 4 server could not be contacted: Python Path: "/usr/...
tamthong.1115's user avatar
0 votes
0 answers
452 views

Pgadmin4 failed to start UBUNTU 22.04

So bascically I wanted to install postgresql and pgadmin4 gui to cooperate. Postgres was easy instead of pgadmin4 - which is nightmare for me. That's why I'm asking for help. I'm interested in ...
zawier's user avatar
  • 3
1 vote
1 answer
4k views

unable to connect to server: connection failed: connection refused is the server running on that host accepting tcp/ip connections?

I have postgres 13.10 and PGAdmin4 7.1 installed on Ubuntu 22.04 In PGAdmin4 UI, I want to "add new server" with these configurations name postgres-local username postgres pw postgres ...
Tms91's user avatar
  • 247
0 votes
1 answer
2k views

"Unable to connect to server: connection failed: FATAL: password authentication failed" on brandly installed postgres and PGAdmin4

I want to create a new server and a new postgres database from the PGAdmin4 UI just-installed on Ubuntu 22.04 I already did this before but I don't remember how did I do id. The server I created last ...
Tms91's user avatar
  • 247
1 vote
4 answers
1k views

Pgadmin4 stop working under 23.04

Pgadmin4 does not work after upgrading to version 23.04. Even after reinstalling from the official repository.
eLDe's user avatar
  • 11
0 votes
2 answers
738 views

Ubuntu 22.10 Cannot install pgadmin4

I follow this instruction sudo nano /etc/apt/sources.list.d/pgdg.list # add the following line: deb http://apt.postgresql.org/pub/repos/apt/ kinetic-pgdg main sudo wget --quiet -O - https://www....
Lev Kakalashvili's user avatar
0 votes
0 answers
17 views

Remote pgadmin4 from software updates

I would like to remote pgadmin4 from receiving upgrades in software updates, and maintain my current version even on installing updates from software updater. I would to keep using pgadmin4 v6.9 but ...
Amina Umar's user avatar
2 votes
1 answer
3k views

Cannot install Python old version(including ~3.9) in ubuntu 22.10

Recently, I updated my ubuntu version to 22.10. I researched online to install python old version in ubuntu 22.10. sudo add-apt-repository ppa:deadsnakes/ppa This command does not work 22.10. How can ...
Yery cs's user avatar
  • 133
7 votes
6 answers
9k views

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

While trying to launch pgAdmin4, I receive the following error: Failed to launch pgAdmin4. Error: Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT This is the runtime environment: Python Path: &...
Magsad Novruzov's user avatar
0 votes
0 answers
96 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$ ...
Petro Gromovo's user avatar
0 votes
0 answers
2k 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 ...
mlafl's user avatar
  • 1
1 vote
1 answer
3k 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/...
Garrett Simpson's user avatar
0 votes
0 answers
519 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 ...
vulkanovski's user avatar
0 votes
2 answers
2k 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: # ...
Denis Kotov's user avatar
4 votes
2 answers
4k 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/...
ingmbk's user avatar
  • 49
1 vote
0 answers
30 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 ...
Swastik Singh's user avatar
1 vote
1 answer
2k 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 ...
Saulo Felipe's user avatar
0 votes
1 answer
3k 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 ...
Mike M. Kaspin's user avatar
1 vote
2 answers
5k 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 ...
Khris_Al's user avatar
1 vote
0 answers
234 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/...
Karthik Arg's user avatar
0 votes
1 answer
6k 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 ...
s.k's user avatar
  • 1,200
3 votes
3 answers
82k 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? ...
B Noor's user avatar
  • 143
1 vote
0 answers
124 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 ...
kiabbo's user avatar
  • 73
0 votes
1 answer
470 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/...
Unique Ezra's 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 ...
Andrew James Ramirez's user avatar
3 votes
0 answers
11k 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 ...
Ahmed Rabea Smaha's user avatar
4 votes
2 answers
3k views

PostgreSQL admin tool behind nginx

I have a VPS with PostgreSQL installed. I have a nginx setup with a some reverse proxies to different tools, grafana, Node.js sites and so on. I'm trying to setup PostgreSQL right now, and I just can'...
Mockarutan's user avatar
19 votes
3 answers
49k 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-...
cjones's user avatar
  • 447
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: ...
Sarthak Kumar's user avatar
3 votes
1 answer
11k 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?
veenaMSL's user avatar
4 votes
1 answer
6k 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/...
Marc Johnson's user avatar
0 votes
2 answers
2k 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.
cguy's user avatar
  • 101
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 ...
Jorge Paladines's user avatar
1 vote
0 answers
519 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-...
DaniKR's 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 ...
Akhilendra's 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 ...
Neeraj Sewani's user avatar
24 votes
2 answers
18k 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 ...
Thomas Landauer's user avatar
1 vote
4 answers
24k 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 ...
KenetCh's user avatar
  • 21
0 votes
1 answer
398 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
fedora's user avatar
  • 57
2 votes
2 answers
6k 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....
HuLu ViCa's 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: ...
HuLu ViCa's user avatar
  • 125
1 vote
0 answers
442 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?
max5555's user avatar
  • 307
0 votes
1 answer
5k 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,...
Codester's user avatar
1 vote
3 answers
6k 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 ...
Thomas Landauer's user avatar
10 votes
5 answers
35k 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 ...
Thomas Landauer's user avatar
4 votes
1 answer
653 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 ...
Randyka Yudhistira's user avatar
8 votes
3 answers
7k 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 ...
Bobby Wibowo's 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 ...
XCeptable's user avatar
  • 153
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 ...
XCeptable's user avatar
  • 153
0 votes
1 answer
645 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 ...
B. Johnson's user avatar