Questions tagged [pgadmin-4]

pgAdmin 4 is an Open Source administration and development GUI for PostgreSQL.

pgAdmin 4 is a complete rewrite of pgAdmin 3.

pgAdmin4 is cross platform (i.e., Linux, FreeBSD, Solaris, macOS and Windows) and supports PostgreSQL v9.2 and above.

It is available as separate download https://www.pgadmin.org/, but also included in PostgreSQL https://www.postgresql.org/.

1180 questions
13
votes
4 answers

pgAdmin 4 v3.1 How can I use another browser? (Win 7)

I'd like to change my default browser to IE (as that one has most of our internal sites programmed for). But currently, I can only get pgadmin4 to work well with Opera. Is there a way to tell pgAdmin4 to use a different browser apart from the stock…
Tony5
  • 131
  • 1
  • 1
  • 6
13
votes
6 answers

OSError: [Errno 13] Permission denied: '/var/lib/pgadmin'

Ubuntu 16.04.3 I'd like to install pgAdmin: I hvae created a virtualenv with python 2. Then install pgAdmin 4 v2.0: pip install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.0/pip/pgadmin4-2.0-py2.py3-none-any.whl It's time to run…
Michael
  • 4,273
  • 3
  • 40
  • 69
13
votes
4 answers

Connection with my db using pgAdmin4

I am study with this tutorial: https://www.youtube.com/watch?v=Ho3DKKopC2E&list=PLDmvslp_VR0xlwr5lAx2PDsZLu7oIOhpX&index=20 When I connect to db, I want to connect the db like the turorial: But I failed, because I don't know how to do with it: …
aircraft
  • 25,146
  • 28
  • 91
  • 166
13
votes
2 answers

PgAdmin 4: Terminate database backup process

I am attempting to back up a PostgreSQL database from pgAdmin 4, but a pg_dump backup process is already running, and I am unable to stop it. I've restarted the postgres server, restarted the server OS, and restarted pgAdmin, but the pg_dump backup…
Michael
  • 251
  • 1
  • 2
  • 13
12
votes
0 answers

Is there a close tab shortcut in PgAdmin 4?

Is there a shortcut to close a View Data tab in PgAdmin 4 (v5.0) ? Ctrl+W doesn't work for this.
DevonDahon
  • 7,460
  • 6
  • 69
  • 114
12
votes
3 answers

pgadmin can't log in after update

Just updated pgadmin4 to version 4.8 and now it won't accept ssh tunnel password into server, I get the following error message: Failed to decrypt the SSH tunnel password. Error: 'utf-8' codec can't decode byte 0x8c in position 0: invalid start…
iFunction
  • 1,208
  • 5
  • 21
  • 35
12
votes
2 answers

pgAdmin 4 v3.0 Query Tool Initialize Error

I recently got a new laptop and downloaded pgAdmin 4 v3.0. Before now, I had been running pgAdmin 4 v2.0 with no issues. However, now whenever I try to open the Query Tool (just by going through the drop down Tools menu), I receive the error message…
scook
  • 159
  • 1
  • 2
  • 9
12
votes
4 answers

pgAdmin 4 ver. 1.5 - no error messages

I use pgAdmin 4 ver. 1.5. When I run an SQL query that has some issues (e.g. a column or a table does not exist) I can only see a message saying "Query returned successfully" but I cannot see any error message. pgAdmin III 1.22.2 However, pgAdmin…
12
votes
1 answer

pgadmin4 is very slow to open empty tables of database

I installed PostgreSQL 9.6.3-1 on my windows 10 laptop. The processor of my laptop is Intel(R)Core (TM)i7-5500U CPU @ 2.4GHZ and installed Memory is 8.00GB. pgadmin 4 is too slow to open table of my databases. I have just made schema of table and i…
Negin Zarbakhsh
  • 167
  • 1
  • 3
  • 13
11
votes
7 answers

Can't install pgadmin4 repository does not have file

I was use command sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update' But I was got this Err:2…
vladislav
  • 133
  • 1
  • 2
  • 8
11
votes
4 answers

pgAdmin Docker Error: 'Incorect username or password'

Have some simple docker-compose.yml file configuration, but I am not sure why I can't not login to pgAdmin using pgadmin4@pgadmin.org as email and admin as a password. Does it need more configuration or am I using wrong credentials? version:…
galvakojis
  • 408
  • 1
  • 5
  • 19
11
votes
6 answers

docker pgAdmin4 connection refused while connecting local postgres database

I am trying to connect my local postgres database using pgAdmin4 docker container. When I open http://localhost:5050/ and login after create new server connection I got Unable to connect to server: could not connect to server: Connection refused…
Jaykumar Patel
  • 26,836
  • 12
  • 74
  • 76
11
votes
7 answers

Package 'pgadmin4' has no installation candidate, for Ubuntu 20.04

After Upgrading to Ubuntu-20.04 I am unable to install pgadmin4. Also, any other version of pgadmin is not working. It is showing below error: Package pgadmin4 is not available, but is referred to by another package. This may mean that the package…
Shubham Soni
  • 111
  • 1
  • 1
  • 5
11
votes
11 answers

Failed to open the system default web browser. Is one installed? Pgadmin4

Just wondering has anyone come across this issue with pgadmin4? Every time I go to open it, I get the following: Failed to open the system default web browser. Is one installed?. Thanks
user1655130
  • 419
  • 1
  • 3
  • 13
11
votes
1 answer

pgadmin4 - Download Query result as CSV

I wrote a query using the query tool in pgadmin 4. Now I want to download the results as a csv. I´ve got two problems with that. The 'Download as CSV'-button does not work sometimes. Especially when the result contains 1000+ rows. When I finally…
StackAsk
  • 121
  • 1
  • 1
  • 5