Questions tagged [pgadmin]
The pgadmin tag has no usage guidance.
29
questions with no upvoted or accepted answers
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