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
32
votes
5 answers

Is it possible to autoformat / beautify SQL queries using pgAdmin4?

I would like to autoformat / beautify my SQL-queries directly in pgAdmin4. I know this feature from Java-developing in Eclipse, where I can beautify the whole code using a simple shortcut. I only found a command line solution so far that makes my…
coding_bird
  • 483
  • 1
  • 4
  • 5
30
votes
18 answers

pg Admin 4 - password for "postgres" user when trying to connect to PostgreSQL 13 server

I know that this question has been asked other times but I didn't find a solution to this problem! I downloaded PostgreSQL 13 with pg Admin 4 and when I open it for the first time after installation it asks me for the master password that I was…
Masso
  • 327
  • 1
  • 3
  • 6
30
votes
1 answer

AWS RDS to PgAdmin Error saving properties Unable to connect to server: timeout expired

Short description: AWS RDS connecting server to PgAdmin 4, PostgreSQL 11 Done: I have done similar to this guy or to this aws guide but at the end when I click save it does not accept it for me. instead gives the following ERROR: Error saving…
sogu
  • 2,738
  • 5
  • 31
  • 90
30
votes
1 answer

pgAdmin 4.7 displays blank popup screen on startup

I've just installed latest pgAdmin (4.7) and whenever I start it up I get this strange blank popup which I can not remove: I can use the application just fine I just need to move that empty window to the side which is annoying. I'm using Firefox…
Dalibor Čarapić
  • 2,792
  • 23
  • 38
28
votes
8 answers

Postgresql Transaction ID Not Found

Whenever I am executing a query in postgresql, this is the error message I receive Transaction ID not found in the session. Does anyone have any idea how to resolve this? I recently created a new user, but I was unable to find documentation that…
Molezz
  • 431
  • 1
  • 6
  • 7
27
votes
2 answers

Heroku pgAdmin4 hide databases which I am not allowed to access

As the title states, if I connect to my heroku posgresql DB via pgAdmin4 I see many other databases which I am not allowed to access. I know there must be a restrction DB field somewhere but I cant find it. In pgAdmin4 its not in the advanced tab as…
Roman
  • 3,563
  • 5
  • 48
  • 104
26
votes
13 answers

pg4admin 401 Unauthorized Error

I just installed the desktop version of pg4admin after having difficulty running it using my prior install. I used the following installing documentation to pull this off. However, when I run the pgadmin4 service, the page gives my the following…
Adam Steinberger
  • 545
  • 1
  • 5
  • 16
25
votes
3 answers

Avoid columns being displayed with their maximum width in the data output tab in pgAdmin

In pgAdmin4 (version 5.5), when a SELECT * FROM tablename; query is executed, one can see on the bottom panel, under a tab called "Data Output", the resulting records for the selected columns for the specified table. If this table is having columns…
swiss_knight
  • 5,787
  • 8
  • 50
  • 92
25
votes
6 answers

Remove pgadmin 4 from Windows

I am using pgadmin 4.1.2 and it is extremely slow. I installed pgadmin 3 and it works like a charm. How do I remove pgadmin 4 from my Windows 2008 R2 machine? Kr A.H.
LilleElefant
  • 422
  • 1
  • 5
  • 14
25
votes
2 answers

pgadmin4 query tool always shows message not connected

Q: How can I diagnose and correct problems with the Query tool connection. Using pgAdmin4 1.0-rc1 to connect to a local host "PostgreSQL 9.5.3, compiled by Visual C++ build 18..." In the browser pane I can connect and drill down to my schema. I use…
Richard
  • 25,390
  • 3
  • 25
  • 38
24
votes
2 answers

Unrecognized Config Parameter "bytea_output" pgAdmin 4

I'm trying to connect pgAdmin Version 4 to an existing Postgres instance. Previously I was using pgAdmin 3 and it was working fine. I'm not sure what I might be doing wrong. I have the following configurations: Not sure what I could be missing. I…
kya
  • 1,798
  • 8
  • 35
  • 61
23
votes
2 answers

In PgAdmin 4 Utility not found

Please help me resolve this error 'C:\Program Files\PostgreSQL\13\pgAdmin 4\runtime\pg_restore.exe' file not found. Please correct the Binary Path in the Preferences dialog
Soko Nafuu
  • 241
  • 1
  • 2
  • 3
23
votes
3 answers

Query field is disabled in edit mode in pgadmin 4

As the title already says: I am trying to make a SELECT statement in the "view/edit data" mode in pgadmin 4, but the query window is disabled. How can I enable it? (I am the owner of all the database, the schema and table and have all privileges for…
JoeBe
  • 1,224
  • 3
  • 13
  • 28
23
votes
5 answers

How do I save a query in pgAdmin 4?

How do I save a query in pgAdmin 4? No matter where I try to save it within the PostgreSQL file or the pgAdmin 4 file, the result is that I do not have access. C:\Program Files\PostgreSQL\9.6\pgAdmin 4\ I have tried both bin files, data files,…
Katydid
  • 331
  • 1
  • 2
  • 7
22
votes
2 answers

Adding postgress connections to pgadmin in docker file

Is there a way to pre-configure pgadmin (maybe via env variables) with some server connections? Say you have this docker-compose.yml, something like PGADMIN_CONNECTIONS env variable in this example? (PGADMIN_CONNECTIONS is probably not a valid ENV…
Pavel Schoffer
  • 492
  • 1
  • 3
  • 11
1
2
3
…
78 79