Stack Overflow
Stack Overflow

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
172
votes
18 answers

FATAL: password authentication failed for user "postgres" (postgresql 11 with pgAdmin 4)

I recently installed Postgresql 11, during the installation, there's no step to put password and username for Postgres. Now in pgAdmin 4, I wanted to connect the database to server and it's asking me to input password, and I haven't put any in the…
Michelley
  • 1,739
  • 2
  • 8
  • 9
168
votes
5 answers

What is "crypt key missing" error in Pgadmin4 and how to resolve it?

I am using pgadmin version 6.1. I am trying to connect to my postgres db hosted in docker with pgadmin on my local machine. I used the below command to get the docker container ip address: docker inspect -f…
akametta
  • 1,781
  • 2
  • 7
  • 4
151
votes
42 answers

pgadmin4 : postgresql application server could not be contacted.

I have installed PostgreSQL 9.6.2 on my Windows 8.1. But the pgadmin4 is not able to contact the local server. I have tried several solutions suggested here in stackoverflow, tried to uninstall and reinstall PostgreSQL 9.6.2 , tried to modify the…
Kaleab Woldemariam
  • 2,567
  • 4
  • 22
  • 43
140
votes
10 answers

pgadmin 4 3.1 retiling data output panel

In the Query Tool, when trying to raise or lower the border between Query Sql Editor and Data Output Panel it is very common that when you move the mouse over the Data Output panel's header it changes the vertical - horizontal arrow icon to a…
glicuado
  • 1,483
  • 2
  • 10
  • 11
65
votes
6 answers

pgadmin 4 v4.28 keeps loading

I installed pgadmin 4 v4.28 and it keeps loading but does not open, I tried opening it as administrator and it still does not open. I had the older version previously but I have deleted PostgreSQL DB and pg admin properly before I install the above…
Ashraf Yawar
  • 857
  • 1
  • 7
  • 15
47
votes
2 answers

PgAdmin 4: Cannot edit rows from one table

Something strange is happening with my new created tables in Postgres, I can add data to them, but I cannot use PgAdmin to edit the any row. This is my table columns description: After executing the query to view all table rows this is what I can…
Camilo Ortegón
  • 3,414
  • 3
  • 26
  • 34
46
votes
8 answers

PgAdmin: Package 'pgAdmin4' has no installation candidate

I just installed PostgreSQL and I am trying to install pgdmin4, but whenever I run the command below to install pgadmin4 and pgadmin4-apache2 sudo apt install pgadmin4 pgadmin4-apache2 I often get the error E: Package 'pgadmin4' has no…
Promise Preston
  • 24,334
  • 12
  • 145
  • 143
45
votes
10 answers

How to reset pgAdmin4 GUI?

I tried Ctrl++, Ctrl+-, then pgAdmin4 v1.1 (on Windows 10 Pro x64) error. Then, I tried re-install, but error still exist: How to fix this error?
Vy Do
  • 46,709
  • 59
  • 215
  • 313
44
votes
4 answers

Utility file not found. Please configure the Binary Path in the Preferences dialog

So I am setting up PostgreSQL on my PC by following Jose Portilla's Course on Udemy and when I had to restore a database by the name of dvdrental. It showed up the message `Please configure the PostgreSQL Binary Path in the Preferences dialog. What…
Dr Patrick Bateman MD
  • 553
  • 1
  • 4
  • 9
40
votes
7 answers

How can I solve 'ServerManager' object has no attribute 'user_info' error in postgresql pqAdmin

I'm trying to create a server for an existing database using postgresql but i'm getting this error 'ServerManager' object has no attribute 'user_info' can someone please assist me to overcome this error. Thanks in advance
Allie Moosa
  • 422
  • 1
  • 4
  • 12
39
votes
12 answers

PgAdmin4 unable to query or view data

I have a very basic PostgreSql table. Despite the simple table schema, I cannot query it via PgAdmin4. The View Data option is unresponsive; Query Tool option becomes unresponsive after a few attempts in opening and closing the panel. When the Query…
Cardin
  • 5,148
  • 5
  • 36
  • 37
38
votes
13 answers

pgAdmin won't start (eternal loading)

Once upon a time I had a Postgres database that worked with pgAdmin. I have a webservice running on a WildFly server that made connections to the DB and everything worked fine. After a while(a few months) I have tried to open pgAdmin again and it…
pedroth
  • 603
  • 1
  • 7
  • 16
37
votes
7 answers

How to export table data from PostgreSQL (pgAdmin) to CSV file?

I am using pgAdmin version 4.3 and i want to export one table data to CSV file. I used this query COPY (select * from product_template) TO 'D:\Product_template_Output.csv' DELIMITER ',' CSV HEADER; but it shows error a relative path is not allowed…
Dhouha
  • 661
  • 1
  • 8
  • 27
34
votes
5 answers

How to upgrade pgAdmin 4 on windows?

I installed pgAdmin 4 as part of the postgres installer for Windows. pgAdmin is now telling me there is a newer version (4.8, > 4.5 which I have). However, there is no built in upgrade functionality that I can see, and when I went to download and…
Anomaly
  • 932
  • 1
  • 10
  • 18
32
votes
10 answers

Pgadmin is not loading

i have recently installed pgadmin4 onto my laptop and when I launch the application, it just gets stuck on the loading. I had a look at the logs and this is what I see: The logs 2020-11-14 00:22:46: Checking for system tray... 2020-11-14 00:22:46:…
Yonis Mohamoud
  • 321
  • 1
  • 3
  • 3
1
2 3
…
78 79