Skip to main content

Questions tagged [pgadmin]

The tag has no usage guidance.

2 votes
1 answer
1k views

how to solve pgadmin4 Increment value cannot be empty

my pgadmin4's version is V4.5. modify table warning me Increment value cannot be empty. but pgadmin4 document dont have incremententer image description here but my pgadmin4 have a tag that named ...
只是修电脑's user avatar
2 votes
0 answers
2k views

how can I get pgAdmin4 to open as a standalone desktop application on MacOS?

I recently installed Postgres and pgAdmin4 and in it's default it opens on the browser. On PC I was able to "force" it to open as desktop app by entering the path to Chrome in the configuration popup ...
atlasofcoffee's user avatar
1 vote
2 answers
8k views

pgAdmin4 "Unauthorized" error

I am using kUbuntu 18.04(bionic) on my local machine and I installed postgresql11 and pgadmin4 step by step from this guide https://wiki.postgresql.org/wiki/Apt. And when i start pgAdmin4 firefox ...
Ivanov Svetoslav's user avatar
0 votes
1 answer
2k views

Port forwarding - How to connect to remote postgresql server - No public IP

I would like to connect to postgresql server which is not a public IP. I need to do port forwarding to access the server. I used SSH client putty to do port forwarding. I keyed in 6666 under "source"...
The Great's user avatar
  • 149
0 votes
1 answer
298 views

pgadmin 4 nav tree highlight color

Apologies in advance if this isn't the place to ask this question. I can't figure out how to fix the highlight color of the left navigation tree in pgadmin 4. ~See attached image.~ I don't have enough ...
user3233946's user avatar
0 votes
0 answers
3k views

Using pgAdmin 4 to access a remote PostgreSQL server

Sorry for the long post.. I wanted to be as detailed as possible to make it easier to spot a problem.. So I've followed the instructions on the PostgreSQL download page and started running a ...
Young-Chan Park's user avatar
1 vote
0 answers
529 views

Error launching pgadmin in ubuntu

I installed pgadmin4 on xenial as it was mentioned in the site. I did as instructed, and the installation was successful, but, the following two errors cycle around and I can't launch pgadmin at all: ...
juztcode's user avatar
  • 135
7 votes
9 answers
48k views

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 ...
Jeff G's user avatar
  • 420
0 votes
1 answer
7k views

How to delete a row with pgAdmin III?

For something so obviously obvious I just can't do it at all. How can I just delete one row without doing the command manually.
Jamie Hutber's user avatar
4 votes
5 answers
11k views

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's user avatar
  • 287
1 vote
1 answer
427 views

PgAdmin4 does not restore previous environment

There was a nice feature in pgAdmin3 that automatically restored the previous environment while connecting to a server. It seems to be missing in pgAdmin4 though or is somehow deactivated by default. (...
Jagger's user avatar
  • 151
4 votes
0 answers
805 views

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 ...
Igor's user avatar
  • 163
3 votes
1 answer
681 views

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, ...
Seldom 'Where's Monica' Needy's user avatar
0 votes
1 answer
385 views

pgadmin3 failed dependencies which are already installed?

I try to install pgadmin3 in a system with OpenSUSE 12.1 After download pgadmin3-1.14.0-2.1.2.i586.rpm I try rpm -ivh pgadmin3-1.14.0-2.1.2.i586.rpm and have the following errors: Failed ...
Tiana987642's user avatar
14 votes
2 answers
23k views

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 ...
David's user avatar
  • 1,279

15 30 50 per page