Questions tagged [pgadmin]
pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL
42
questions
0
votes
1answer
14 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 ...
1
vote
0answers
61 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/...
0
votes
1answer
609 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
vote
0answers
3k 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?
...
1
vote
0answers
90 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 ...
0
votes
0answers
130 views
Adding APT deb source for pgAdmin4 makes a lot of non-related packages obsolete
Context
My Ubuntu 18.04 (5.4.0-42-generic x86_64 GNU/Linux) system is freshly updated and upgraded;
$ sudo apt upgrade
Reading package lists... Done
Building dependency tree
Reading state ...
0
votes
1answer
89 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/...
0
votes
0answers
548 views
pgadmin4 installation error [Errno 2] No such file or directory
I am trying to install pgadmin4 on my Ubuntu 20.04 focal. I followed this link: https://linuxhint.com/install-pgadmin4-ubuntu/ . This website contains installation in two ways, one from the steps ...
4
votes
2answers
2k 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
0answers
3k 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
1answer
613 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'...
17
votes
3answers
17k 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-...
1
vote
1answer
943 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:
...
1
vote
1answer
4k 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?
4
votes
1answer
4k 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/...
0
votes
2answers
583 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
vote
1answer
1k 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
0answers
290 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-...
1
vote
1answer
4k 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 ...
1
vote
0answers
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 ...
14
votes
2answers
10k 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 ...
0
votes
4answers
10k 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 ...
0
votes
1answer
281 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
0
votes
0answers
914 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....
0
votes
1answer
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: ...
1
vote
0answers
390 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?
0
votes
1answer
2k 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,...
0
votes
2answers
2k 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 ...
7
votes
5answers
19k 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 ...
4
votes
1answer
563 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
3answers
5k 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 ...
0
votes
0answers
1k 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 ...
1
vote
1answer
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 ...
0
votes
1answer
544 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
0answers
12k 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 ...
1
vote
2answers
6k 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 ...
0
votes
1answer
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
vote
1answer
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 ...
0
votes
1answer
689 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
...
0
votes
1answer
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 ...
117
votes
4answers
259k 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.
2
votes
1answer
2k views
pgAdmin show object browser text white on white with dark theme
When using a dark theme, the object browser uses white background. Is there some way to change this? This question has been asked a few times, but no answer still.
The theme I am using is E17.
