Questions tagged [pgadmin]
The pgadmin tag has no usage guidance.
57
questions
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....
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 ...
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 ...
0
votes
0
answers
87
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.
0
votes
0
answers
72
views
How to access the local files to restore in remotely accessed PgAdmin4 in centos 8
I have one Web Server with PHP and one Database Server with PostgreSQL 15. Both with Cent OS 8. I have installed pgadmin4 in the web server to access the Remote Database server through browser and it'...
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 ...
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 ...
0
votes
1
answer
186
views
How does windows encodes non English path?
When providing a Filename of C:\א\Toc1.dump to the pgadmin's backup tool, it reproduces behind the scene an encoded path of C:\\0F04~1\\TOC1.DUMP as in the screen shot:
When I trigger the pg_dump.exe ...
0
votes
1
answer
130
views
Can I group or hide functions in pgAdmin4?
I am using PostGIS, so my database has about 1K functions.
Looking for "my" functions in that mess is annoying.
Can I somehow group or hide some functions? I was thinking of a functionality ...
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 ...
0
votes
0
answers
401
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 ...
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
1
answer
10k
views
pgAdmin not working on mac OS Big Sur
I updated my Mac to macOS Big Sur a few days ago and tried to run pgAdmin to work on some projects of mine. However, it seems there is a problem with pgAdmin 4 and Big Sur. I just cannot run it ...
0
votes
0
answers
160
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 ...
2
votes
1
answer
20k
views
How to shutdown pgAdmin 4 from the command line on Windows?
I already know how to do it in the GUI: you find the elephant icon in the Notification area, right-click it, and click "Shut down server". However, I have been unable to find any way to do the same ...