Questions tagged [pgadmin]
pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL
51
questions
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$ ...
- 141
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 ...
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 ...
- 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?
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/...
- 137
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 ...
- 347
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:
# ...
- 237
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/...
- 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 ...
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 ...
- 63
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
...
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 ...
- 13
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/...
- 11
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 ...
- 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?
...
- 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 ...
- 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/...
- 19
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
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 ...
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'...
- 91
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-...
- 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:
...
- 133
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?
- 13
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/...
- 53
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.
- 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 ...
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-...
- 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
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 ...
- 741
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 ...
- 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
- 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....
- 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
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?
- 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,...
- 11
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 ...
- 741
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 ...
- 741
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 ...
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 ...
- 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 ...
- 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 ...
- 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 ...
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 ...
- 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 ...
- 257
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) ...
- 1
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 ...
- 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
...
- 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 ...
- 111
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.
- 9,173