Questions tagged [pgadmin]
The pgadmin tag has no usage guidance.
29
questions with no upvoted or accepted answers
5
votes
0
answers
3k
views
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:
...
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 ...
2
votes
1
answer
135
views
PGAdmin how to open straight tables submenu
Is there a way how to open straight tables submenu in PGAdmin? Actually if I want to see table in some database I need to click on
database->schema->public->tables
It's 4 clicks till I see ...
2
votes
0
answers
2k
views
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 ...
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 ...
1
vote
0
answers
2k
views
How to manually uninstall PGAdmin4 from macOS?
I have tried removing manually by removing PGAdmin4 from my applications folder. I also followed a few steps from this post here. To my surprise some of the files existed and I was able to remove them....
1
vote
1
answer
2k
views
ERROR: could not load library "/Library/PostgreSQL/11/lib/postgresql/rtpostgis-2.5.so":
Screenshot
I'm getting the following error when I'm trying to add postgis as an extension in pgAdmin.
Please help me out here.
1
vote
0
answers
2k
views
How can I completely remove PGAdmin from my Mac?
Problem: I've inadvertently installed both PGAdmin and PostgreSQL on my mac. Unfortunately, PGAdmin is now defaulting to port 5432 and I'm unable to start a database on that port from PostgreSQL.
I'...
1
vote
1
answer
2k
views
Copy fields from one column into another column with pgadmin 4 and sql?
I'm new to Postgresql and using pgadmin 4 on a mac. I have a table that has international and national addresses recorded in 4 columns for international, and four for national (country, state, city, ...
1
vote
0
answers
516
views
PgAdmin 4 does not see default database in AWS RDS PostgreSQL
I am using RDS Postgres as an analytical data warehouse and would like to connect to it via pgadmin. I was able to connect to the database, but pgadmin is not picking up my default database, i.e. the ...
1
vote
1
answer
4k
views
pgAdmin 4: Data Ouput tab allows only 1000 rows
I am using pgAdmin 4.5 on Mac. My data output tab shows only 1000 rows even though the selection shows no limit (and offers no other option).
It seems that the default value is 1000 (from pgAdmin 4.5 ...
1
vote
2
answers
2k
views
pgAdmin4 not starting on Ubuntu18.04(ModuleNotFoundError
enter image description hereI am having the following Issue, trying to run pgAdmin4.py
sudo python3 pgAdmin4.py
Traceback (most recent call last):
File "pgAdmin4.py", line 40, in
import ...
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: ...
1
vote
0
answers
2k
views
Can't view database structure via pgAdmin, while psql works ok
I have a PostgreSQL database. I can connect to it via psql no problem, however, when I do database listing:
my_database=>\l
there is no my_database in the list!
When I connect to this same ...
0
votes
0
answers
12
views
Dont see sql window and filters window in PGadmin
can somebody tell me why I dont see sql window and filters window in PGAdmin?
I accidentaly clicked on some btn which separate window with result from the parent window and then I clicked to maximize ...