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
807
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 ...
- 163
2
votes
1
answer
138
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 ...
- 355
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 ...
- 1,976
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....
- 111
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.
- 21
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'...
- 11
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, ...
- 11
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 ...
- 11
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 ...
- 11
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 ...
- 11
1
vote
0
answers
534
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: ...
- 135
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 ...
- 173
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 ...
- 355
0
votes
0
answers
92
views
PGAdmin does not show indexes
How can I see indexes in PGAdmin via properties dialog? I am sure index is there as you can see on the picture, but in properties dialog I can not find that index.
- 355
0
votes
1
answer
96
views
Cannot view postgres database on one system in another
I am trying to view a database created on a different system in my current installation of postgres.
I downloaded the same version of postgres (9.6) and replaced the data folder with the data folder ...
0
votes
1
answer
26
views
Firefox (cannot save history), PgAdmin4 sqlite issue, Signal, ... may be caused by kernel >5.13 and wrong F2FS file system check
If you face not working Firefox webDeveloperTools or some history issue, or pgAdmin4 complaining about some weird sqlite issue and even Signal messenger doesn't start, then the problem isn't related ...
- 101
0
votes
0
answers
406
views
Recover old PostgreSQL database after reinstalling Windows
My Windows hard drive died and I transferred the secondary hard drive (on which my PostgreSQL 9.4 database was installed) to my new PC.
Since all programs needed to be reinstalled, I then downloaded ...
- 577
0
votes
1
answer
3k
views
Importing large volume of dummy data into pgAdmin 4 by csv - Failed (exit code:1)
I am trying to upload a large amount of dummy data into my pgadmin tables. I was able to use a csv for the smaller tables however I have a larger spreadsheet of data that includes descriptions (with ...
0
votes
0
answers
163
views
How to show messages before rollback?
I want to test transaction like
begin;
delete from A;
delete from B where B.A in (select guid from A);
rollback;
and see how many records would be deleted. But in pgadmin I see only
ROLLBACK
Query ...
- 399
0
votes
1
answer
487
views
PGAdmin 4 v4 doesn't render correctly in my browser
I've installed PGAdmin 4 v4 but when I try to launch it, the Google Chrome tab open but the page is not formatted as the following image:
How can I show correctly this administrative page?
- 215
0
votes
0
answers
441
views
Unable to install pgAdmin4 on CentOS 8
I am trying to install pgAdmin4 on CentOS 8. It is throwing these errors. I checked python and version 3.6 is already installed.
- 2,753
0
votes
2
answers
279
views
CentOS pgAdmin page is naked HTML, without CSS and JavaScript due to ERROR flask.app
I'm running pgAdmin v4.8 on CentOS 7. After last 'yum update', pgAdmin doesn't work. The logfile /var/log/pgadmin/pgadmin4.log has the following error messages:
ERROR flask.app: make_conditional() ...
- 1
0
votes
1
answer
2k
views
777 permission folder is permission denied
I'm trying to set up a pgadmin4 server mode panel and it needs access to the directory var/lib/pgadmin4/sessions, this folder has 777 permission and the owner is apache (parent folders too). Yet it ...
- 101
0
votes
1
answer
299
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 ...
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 ...
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.
- 403
0
votes
1
answer
1k
views
Hide some functions from display in PG Admin III
I have installed modules (XML2, UUID) in Postgres.
In PG Admin III, all the functions contained in those modules display under the "Functions" tree.
The list is lengthy, and it slows down my work ...
- 753