Super User Stack Exchange
Super User Stack Exchange

Questions tagged [pgadmin]

54 questions
19
votes
3 answers

What is this blank white box in pgAdmin 4

From startup in pgAdmin 4, there is a large white box with no text or buttons on it centered over the screen in the browser. I'm using firefox, but also tried Chrome, same result, large white window of some sort. I can drag it out of the way but…
Hugh_Kelley
  • 401
  • 1
  • 7
  • 14
14
votes
2 answers

Any way to keep connection alive in pgAdmin without setting it on the server?

I am using postgres.heroku.com to host my databases. This means that I have no way of changing server settings. Therefore, the answer to this question does not help me. Heroku is not willing to change their settings (I have contacted them). I am…
David
  • 1,279
  • 3
  • 16
  • 23
12
votes
3 answers

pgAdmin list of keyboard shortcuts

I've been using pgAdmin for several days and so far I like it. However, I can't find a list of keyboard shortcuts documented anywhere, either on the pgAdmin site, in the help, or in the options menu. I stumbled into one myself that is nowhere in the…
user2100746
9
votes
2 answers

How to keep connection alive in pgAdmin

In pgAdmin, if I'm connecting to a host and leave it idle for a few minutes, the connection drops, and I have to reconnect again. On many occasions pgAdmin also hangs when I try to reconnect, so I have to force close it and open it again. This is…
Chin
  • 7,883
  • 22
  • 69
  • 95
9
votes
4 answers

Undeterminable error with pgAdmin 4

I'm using pgAdmin 4 on a Debian OS. It was working fine about a month ago but today it the SQL Query Tool gives a cryptic error message: 'table_oid'. The "View/Edit Data" option in the right-click menu works fine as well as running queries from the…
Arban Nichols
  • 111
  • 1
  • 3
7
votes
9 answers

How to Fix the pgAdmin 4 v3.0+ Port Number

I just installed PostgreSQL 10.4, and noticed that the pgAdmin 4 v3.0 interface packaged with that version uses a local web server and browser interface. By default, the application appears to use an ephemeral port (49152 to 65535) assigned by the…
Jeff G
  • 368
  • 1
  • 4
  • 12
5
votes
3 answers

Set default search path in pgAdmin

Every time I open pgAdmin I have to do this: set search_path="schema"; Is there a way to set a default search path value?
Chin
  • 7,883
  • 22
  • 69
  • 95
5
votes
2 answers

Searching a whole postgres db for a string

In phpmyadmin, I can easily search for text in the tables in my databases using the search tab. Was wondering if I can do the same with the postgres installed locally on my computer. I have looked at the menus there but I can't find anything like…
yankitwizzy
  • 299
  • 3
  • 5
  • 10
5
votes
0 answers

Invalid length of startup packet docker compose postgresql

I am trying to install/setup pgadmin4 on a linux fedora 28 machine and when I try running this command docker-compose -f docker-compose.yml -f docker-compose.dev.yml up I get these errors: postgres_1 | 2019-05-24 13:50:15.903 UTC [125] LOG: …
everydayprogrammer
  • 51
  • 2
4
votes
1 answer

How can I completely uninstall pgAdmin3 from OS X?

My pgAdmin3 install has run into a problem (windowing glitch that renders it unusable), and I want to try completely removing it from my system and installing it freshly to see if that resolves the issue. I've tried simply deleting the app and…
Eldan Goldenberg
  • 43
  • 1
  • 1
  • 5
4
votes
5 answers

Change the font size for the the browser tree in pgAdmin4?

The font size can be changed for sql editor in preferences. Is there a way to change the font size of the browser tree in the left frame?
Don
  • 277
  • 2
  • 4
  • 13
4
votes
0 answers

How to change the row height in pgAdmin on 4K monitors with scale >1

the row height in pgAdmin is controlled by the font size, but on my 2160p screen I'm using scale factor x2 to render readable UIs. The font is cut in the result grid, I can expand manually. Are there any option to control the row height? Somewhere…
Igor
  • 163
  • 8
3
votes
1 answer

pgAdmin III writes files with junk in them, which causes PSQL to fail

I encountered the dilemma of needing to run some psql console commands because a colleague needed to use psql's \i directive in a saved script to execute additional SQL-statements from another file, but I noticed that psql was choking on these files…
Seldom 'Where's Monica' Needy
  • 260
  • 2
  • 9
3
votes
1 answer

How display result of multi select in PgAdmin III?

select 1 as a,4 as b, 5 as c; select 1 as a,3 as b; Result display only of `select 1 as a,3 as b; How display result of multi select in PgAdmin III?`
D T
  • 131
  • 1
  • 3
2
votes
0 answers

How create new server connection in pgAdmin 4 by pasting PostgreSQL connection string (URI)

See https://stackoverflow.com/a/20722229/470749 It's very common for server connections to be specified in just one URI, which is more convenient than needing to type out a bunch of values into separate form fields like this: How can I create a…
Ryan
  • 1,736
  • 11
  • 41
  • 68
1
2 3 4