Questions tagged [pgadmin]
pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL
58
questions
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/...
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 ...
- 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
...
- 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 ...
- 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.
- 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....
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 ...
- 101
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 ...
- 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: &...
- 121
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$ ...
- 143
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 ...
- 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/...
- 137
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 ...
- 433
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:
# ...
- 247
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/...
- 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 ...
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 ...
- 83
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
...
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 ...
- 13
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/...
- 11
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 ...
- 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?
...
- 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 ...
- 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/...
- 11
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 ...
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 ...
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'...
- 91
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-...
- 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:
...
- 133
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?
- 33
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/...
- 53
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.
- 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 ...
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-...
- 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 ...
- 121
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 ...
- 111
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 ...
- 821
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 ...
- 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
- 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....
- 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: ...
- 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?
- 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,...
- 11
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 ...
- 821
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 ...
- 821
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 ...
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 ...
- 103
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 ...
- 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 ...
- 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 ...
