Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [pgadmin-4]

pgAdmin is an open source management tool for Postgres. pgAdmin 4 is a completely new client, intended to replace the older pgAdmin III.

pgAdmin 4 is designed to meet the needs of both novice and experienced Postgres users alike, providing a powerful graphical interface that simplifies the creation, maintenance and use of database objects.

It is a management tool for PostgreSQL and derivative relational databases such as EnterpriseDB's EDB Advanced Server. It may be run either as a web or desktop application.

[source: https://www.pgadmin.org/ ]

143 questions
40
votes
3 answers

pgAdmin 4 version 3 fails to open a second time

I just installed pgAdmin 4 version 3.0.0 for macOS Sierra, replacing the pgAdmin that came bundled with Postgres 10.3 running locally on the same Mac. I opened the pgAdmin 4.app app icon, which caused Safari browser to come to the front with a tab…
Basil Bourque
  • 11,188
  • 20
  • 63
  • 96
38
votes
3 answers

Binary path in the pgAdmin preferences

I installed PostgreSQL because I need to restore a large .backup file I received for upload to another platform (it's 38 million rows which was apparently too large for the person to export any other way). When I try to "restore" in pgAdmin 4 I get…
randodatauser
  • 381
  • 1
  • 3
  • 3
20
votes
4 answers

Is it possible to disable new version checking in pgAdmin 4?

New versions of pgAdmin 4 are being released every month, and it's so annoying to see a popup with notification about another update. There's no option in preferences to disable it. Is there a trick to disable this particular popup, except…
Yaroslav
  • 405
  • 5
  • 10
17
votes
2 answers

What does it mean when a session is highlighted in red in the PgAdmin dashboard?

I've noticed sessions being highlighted in red recently though this never occurred in the past which leads me to believe it is a new feature. It appears to only occur on hanging queries. I looked through the PgAdmin documentation as well as change…
joepcash
  • 171
  • 1
  • 1
  • 3
13
votes
1 answer

How to backup some selected tables, but not all, in pgAdmin 4?

In pgAdmin 3, the dialog to perform a backup allowed you to check and un-check the tables you wanted to be part of your backup. In pgAdmin 4, either I am unable to find this feature, or it is not there. Is there any method of backing up only a…
mg1075
  • 755
  • 3
  • 12
  • 22
12
votes
3 answers

pgAdmin 4: How to establish a connection through an SSH tunnel/interface in Windows

I installed the latest pgAdmin 4 (v2.1) but I found out that (related thread), for the moment, the only way to establish a connection through an SSH tunneling is using another outside process, an example in the pgAdmin's forum says: I setup a…
CPHPython
  • 339
  • 1
  • 3
  • 11
10
votes
3 answers

Cannot do a restore using PgAdmin4 after a new install of PostgreSQL - pg_restore.exe file not found

I am new to PostgreSQL. I installed the software. Almost everything works. Then I tried to follow a tutorial for dvdrental. All instructions for using from command line worked. Then there is instruction for creating a DB using pgAmdin 4, which also…
M. Saleem Yusuf
  • 139
  • 1
  • 1
  • 5
10
votes
1 answer

PgAdmin 4 - How to connect to database using unix socket via ssh tunnel?

Even though it might sound related to this question, it isn't, because I'm intreseted in the use of unix sockets instead of TCP/IP ones. However, I am unable to connect to a remote PostgreSQL database using unix sockets and an ssh tunnel with…
Migsi
  • 103
  • 1
  • 4
9
votes
3 answers

pgadmin dashboard is gone

The Dashboard option is gone from the menu. Now I can't see the nice graphs anymore. What do I need to get it back I'm using version 4.17?
Bart Jonk
  • 357
  • 1
  • 3
  • 11
9
votes
1 answer

Kill connection in pgadmin4 Postgresql

Can you tell me how to kill connection in pgadmin 4 web postgresql without executing any scripts? How can I limit the number of connection to database in order to kill the active connection (My case I want to rename database already used !)
BOUKANDOURA Mhamed
  • 215
  • 2
  • 4
  • 7
7
votes
2 answers

How to turn off autocomplete in PgAdmin4?

How do you turn off the autocomplete/help-tips in PgAdmin4? They're driving me insane. Every cursor movement and keypress causes a "Loading..." overlay to appear, which either displays nothing or displays a useless "help" dropdown, in case I want to…
Cerin
  • 1,425
  • 6
  • 29
  • 38
7
votes
1 answer

How can I change the master password of pgAdmin 4 without resetting it?

pgAdmin 4 has a master password which is required to secure and later unlock the saved server passwords. This is applicable only for desktop mode users. I know my current master password, however, I want to change it without resetting it,…
Glorfindel
  • 2,205
  • 5
  • 19
  • 26
7
votes
1 answer

Is it possible to refresh PgAdmin 4 query without restarting a new query after disconnect?

Sometimes I leave a PgAdmin session alone for a while and when I come back to issue a query, I get an error Server closed the connection unexpectedly. This probably means the server terminated abnormally before or while processing…
user55570
  • 409
  • 4
  • 5
6
votes
5 answers

How to fix "your account is locked. please contact admin" error in pgAdmin?

I'm new to PostgreSQL.I'm using postgreSQL locally. I used it last time without any issues. Now, when I try login with my login credentials it shows the account is locked message all the time.
gowtham6672
6
votes
2 answers

AttributeError: 'NoneType' object has no attribute 'value' - pgAdmin4

I Ctrl+C'd out of the initial pgAdmin4 setup aka. python pgAdmin4.py and now if I try to rerun the install, I get a mountain of errors. I'm using pgAdmin3 for now but I would like to know how to fix this. The full traceback is below: Traceback (most…
Sean Kelley
  • 63
  • 1
  • 1
  • 5
1
2 3
…
9 10