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.

Filter by
Sorted by
Tagged with
37
votes
3answers
43k views

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 ...
20
votes
3answers
158k views

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 ...
9
votes
3answers
43k views

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 ...
9
votes
3answers
2k views

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 ...
8
votes
0answers
4k views

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 ...
6
votes
3answers
10k views

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 ...
6
votes
1answer
935 views

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 ...
5
votes
2answers
11k views

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 ...
5
votes
2answers
2k views

Unable to output data from tables in pgAdmin4 due to missing oid operator

I am currently running Postgresql 10.6 locally which I interface with using PgAdmin 4.12, up until today everything was running fine. However today I ran the following query in the pgAdmin query ...
5
votes
1answer
21k views

Kill connection in pgadmin4 Postgresql [closed]

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 ...
4
votes
2answers
4k views

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?
4
votes
3answers
16k views

Stop restoring backup in pgAdmin

I am currently restoring a database and I tried to restore the database three times. The third time I succeeded but unfortunately it seems that the other two attempts at restoring the database are ...
4
votes
1answer
4k views

PGAdmin4 Browser: Autocomplete not working

I am using PGAdmin4 on my Firefox Browser(Mac). I am looking for auto-complete feature but could not get it work. The documentation says that the shortcut for auto complete is "Ctrl+Space" but it ...
4
votes
2answers
17k views

pgAdmin4 v4: TypeError: string indices must be integers

When I open pgAdmin4 v4 on Windows 10, the dashboard displays An error occured whilst rendering the graph on all charts. The link (1) told me that the logs on windows are at Windows log location: C:\...
4
votes
0answers
188 views

Could a query be still active after pgAdmin4 crashed?

As i am asking in the title, I am wondering if a query can be still active after pgAdmin4 crashed ? Indeed I was running a very long-time query.. CREATE TABLE intersection as ( SELECT buff.rownum ...
3
votes
1answer
12k views

How to edit `postgresql.conf` with pgAdmin 4?

Same Question as this: How to edit postgresql.conf with pgAdmin 3? but updated for the completely new (total re-write) pgAdmin 4. ➥ How does one edit the configuration files with the pgAdmin 4 app? ...
3
votes
1answer
3k views

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 ...
3
votes
0answers
441 views

In pgAdmin 4, show multiple lines of a TEXT column

A have a TEXT column in which the values contain newlines. When I query the column in pgAdmin, I only see the first line of each value. Can I make pgAdmin show multiple lines in a cell?
3
votes
1answer
3k views

Why pgAdmin4 invoke "'utf8' codec can't decode byte 0xe9 in position 42: invalid continuation byte" error?

I'm newbie in postgreSQL ,when I'm trying to create a new local server using pgAdmin4 ,it shows me this error : 'utf8' codec can't decode byte 0xe9 in position 42: invalid continuation byte I'm ...
3
votes
0answers
699 views

Problem: Remote connection with pgAdmin4

I just installed the Java and PostgreSQL environment on a server (for remote testing) CentOS 7 From the command line using ssh would seem that there are no problems in the sense that I can access the ...
3
votes
1answer
209 views

pgAdmin4 Hide Alerts

pgAdmin4 has introduced 'alerts' or 'toasts' in the UI that display the status of certain tasks. There seems to be no way to dismiss these alerts, which obscure other parts of the UI, without first ...
2
votes
1answer
4k views

pgAdmin4 or pgAdmin3? [closed]

I've seen a lot of hate directed to pgAdmin4, but honestly I can't see why. It worked out of the box from a docker image, connected right away to the database and perfectly managed every maintenance ...
2
votes
1answer
233 views

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 ...
2
votes
1answer
27 views

In PgAdmin, what does `[...]` refer to in a result set?

Sometimes my query results include a cell containing the pattern [...]. When I export such results, they render as a blank string. However, when I try to filter on them with where column_b = '', there'...
2
votes
1answer
2k views

PgAdmin 4.14 connection error in cloudSQL : could not send data to server, socket is not connected, could not send ssl negotiation packet

I am trying to connect cloud sql with pgadmin but it throws error when I try to execute query. "Could not send Data to server, socket is not connected, could not sent SSL negotiation pocket" ...
2
votes
1answer
2k views

How can I disable the notifications shown at bottom right corner in pgAdmin 4?

The notification window at bottom right corner is pesky. Is it possible to disable it?
2
votes
1answer
1k views

How to change pgAdmin 4 to display rows retrieved and runtime?

I've just switched from pgAdmin III to pgAdmin 4, and while overall it seems a lot slicker in terms of UI and presentation, I'm missing a few things from the previous version. In particular, I would ...
2
votes
1answer
2k views

Overcome Runtime error when exporting large data table from PostgreSQL

I am very new to using PostgreSQL. I have created a query that compiles a table with more than 100,000 rows and 20 columns of data. The query works and loads the table fine in the PostgreSQL preview ...
2
votes
1answer
425 views

pgAdmin 4 including <U+FEFF> in all copied strings

I'm having trouble using copy/paste from pgAdmin 4. The symptom is that I get the character <U+FEFF> aka Zero Width No-break Space aka Byte Order Mark (BOM) prepended to any string I copy. The ...
2
votes
0answers
25 views

pgAdmin 4 - Can't do anything after connection lost

I'm using pgAdmin 4.5 on Windows 10. When I connect to a database, things going well. Then after some idle time, pgAdmin says "The connection is lost", then refuse to do anything, including ...
2
votes
0answers
471 views

PG4Admin "local variable 'debugger_version' "?

My Postgres version is 9.6, running on Windows 7 Professional. I have just upgraded to pgAdmin 4.2.3 since I was not able to get the debugger to work at all with my previous pgAdmin. I installed ...
2
votes
0answers
460 views

What are the .pgAdmin4.2123502176.addr and .log files?

I recently installed pgAdmin4 on Win 10 64-bit. At the top of my main User directory it makes two tiny files, .pgAdmin4.2123502176.addr and .pgAdmin4.2123502176.log. (I'm assuming the numbers change ...
2
votes
1answer
662 views

When trying to connect to an external postgres database using pgAdmin, I get an error [closed]

I get the following error when trying to connect: "FATAL: no pg_hba.conf entry for host "", user "postgres", database "postgres", SSL off" The db is installed on an Ubuntu machine in Azure. I have ...
1
vote
2answers
748 views

DBEaver Vs PG Admin

When I ran a query in Postgres database using the Pg Admin tool it took only 2 SECS ( I can see the parallel workers being used in the plan) but when I ran the same query in DBeaver, it took around 3 ...
1
vote
2answers
468 views

Will my query continue to execute after I shut off my computer

I am running a very expensive query that I executed via pgAdmin 4 which is installed on my laptop. I am executing the query on a cloud server. The message that I see is 'Waiting for query execution ...
1
vote
1answer
3k views

ERROR: ROWS must be positive

Why the error when I run the below in pgAdmin 4 query editor? I copied the create statement in one database and trying to move to a new server. So I right clicked the function in pgAdmin and ...
1
vote
1answer
73 views

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 ...
1
vote
1answer
31 views

Is the "comments" field in pgAdmin 4 a pgAdmin thing, or is it a PostgreSQL feature?

If I right-click a table (or any object) in pgAdmin 4 and select "Properties", it brings up a GUI window which allows me to change the name of the table and many other things. One of the ...
1
vote
1answer
538 views

How to take backup of schema postgresql?

Hi I am currently using postgresql and deleting some of the tables for testing purpose and I want to take backup of schema. can any one let me know how to do that ?
1
vote
1answer
793 views

Copying a DB or tables from a local Postgres database to Heroku [closed]

I'm almost a novice with databases. I created a PostgreSQL database with the python programming language. I am pleased to note that the database was created as I wished. I could easily verify it from ...
1
vote
1answer
5k views

getting insert queries from pgAdmin 4

I am using pgAdmin 4 and am looking to download query results as INSERT statements rather than as a CSV (the only option I can find). I am used to doing this with MySQL Workbench, but maybe I have ...
1
vote
0answers
43 views
+50

How to open pgAdmin 4 v6.0 in browser instead of running as a desktop app

It looks like PgAdmin 4 v5.4+ (I have v6) works as a standalone desktop app and the option to open in a browser window is not there by default. I am using macOS Big Sur. How can I open PgAdmin UI in ...
1
vote
0answers
117 views

How do I run pgadmin in a web browser by default?

I'm running pgadmin 5.4 on macOS Big Sur. When I open the application, pgadmin launches in Desktop Mode, as a standalone app. My goal is to force pgadmin to run within a browser instead, but I'm ...
1
vote
0answers
32 views

How to get rid of PGAdmin 'Notifications' panel

I pushed some key combination by mistake that made this panel pop up: Now I can't find how to make it disappear. The solution is not evident at all, and it is really bothering because it covers a big ...
1
vote
0answers
374 views

pgAdmin 4, force "The application has lost the database connection:"

Whenever I put my computer in sleep mode pgAdmin 4 loses the connection to the remote Postgresql database (and that's fine). When I start up the computer again I have two options. Either restart ...
1
vote
1answer
34 views

Administrator can't view tables ("server refused to connect")

I'm quite experienced with MSSQL and MySQL/MariaDB, but I'm a newbie re PostgreSQL. I got everything to work, except for the odd detail that the admin user which I set up during installation can't &...
1
vote
0answers
3k views

Persistent problems importing CSV files via pgAdmin 4 to PostgreSQL 12 on Mac OS - Failing with Exit Code -6

I've been trying for several days to import CSV files into a PostgreSQL 12 database hosted on Mac OS 10.15.5, using the Import/Export tool in pgAdmin 4. I am consistently getting an error message ...
1
vote
0answers
198 views

pgAdmin 4 restore ignores "Clean before restore"

I am using pgadmin v4.22 to backup and restore a database. This works fine the first time, but when I want to restore it again to a backup with deleting the old data, pgAdmin seems to ignore the Clean ...
1
vote
0answers
415 views

Is it possible to change the browser that pgadmin4 uses?

I have Debian 10, pgadmin4, and KDE. When I open pgadmin4, it opens with Firefox. I have several other browsers installed. If I try to paste the link in any other browser, I get this error message: ...
1
vote
0answers
50 views

Can't reach my servers on pgAdmin4

I have an issue on pgAdmin 4.14: I can't open the servers anymore. Whenever I open it I have this never-ending wheel. Furthermore, I have this weird pop-up that I can't close. I was able to reach my ...