Questions tagged [pgadmin]
The pgadmin tag has no usage guidance.
57
questions
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.
- 55.6k
1
vote
1
answer
712
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....
- 55.6k
5
votes
1
answer
24k
views
How can I completely uninstall pgAdmin3 from OS X?
My pgAdmin3 install has run into a problem (windowing glitch that renders it unusable), and I want to try completely removing it from my system and installing it freshly to see if that resolves the ...
- 55.6k
0
votes
0
answers
10
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 ...
- 345
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 ...
CommunityBot
- 1
1
vote
1
answer
117
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 ...
- 345
0
votes
0
answers
67
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.
- 345
0
votes
0
answers
58
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'...
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
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?
0
votes
1
answer
94
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 ...
- 1,610
14
votes
2
answers
22k
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 ...
0
votes
1
answer
125
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 ...
- 280
0
votes
1
answer
172
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 ...
- 63.1k
2
votes
1
answer
19k
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 ...
CommunityBot
- 1
5
votes
3
answers
16k
views
Set default search path in pgAdmin
Every time I open pgAdmin I have to do this:
set search_path="schema";
Is there a way to set a default search path value?
- 111
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
357
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
19
votes
3
answers
9k
views
What is this blank white box in pgAdmin 4
From startup in pgAdmin 4, there is a large white box with no text or buttons on it centered over the screen in the browser.
I'm using firefox, but also tried Chrome, same result, large white window ...
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 ...
- 125
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 ...
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 ...
- 101
5
votes
2
answers
18k
views
Searching a whole postgres db for a string
In phpmyadmin, I can easily search for text in the tables in my databases using the search tab. Was wondering if I can do the same with the postgres installed locally on my computer. I have looked at ...
- 961
0
votes
1
answer
473
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?
- 1
0
votes
0
answers
145
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 ...
- 96
0
votes
3
answers
364
views
How can it be that most software for Windows treats each single update as if you are installing the software for the first time? [closed]
Notepad++ just nagged me about a new version for the millionth time. Finally giving in, this time I clicked "OK" with a sigh instead of "Cancel". And so it started downloading the latest version, but ...
- 1,688
0
votes
0
answers
428
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,733
1
vote
2
answers
1k
views
PGadmin V4 on Windows 10 - Can not create select, update scripts for table "Error message" error fetching SQl for script: 'attname'
I am running Pgadmin V4.17 on Windows 10.
When I try to create a select or update sql statement for a table(with the right click on table Scripts) I got an Error window with the text "Error message" ...
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, ...
- 4,044
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
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 ...
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"...
- 149
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.
CommunityBot
- 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 ...
- 209
9
votes
4
answers
5k
views
Undeterminable error with pgAdmin 4
I'm using pgAdmin 4 on a Debian OS. It was working fine about a month ago but today it the SQL Query Tool gives a cryptic error message: 'table_oid'. The "View/Edit Data" option in the right-click ...
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
0
votes
1
answer
985
views
PgAdmin connect to remote server
I am having trouble connecting with pgAdmin4 to a PostgreSQL database (version 9.5) running on Ubuntu 16.04. The connection times out when I attempt to connect. I think it is being refused/dropped at ...
1
vote
0
answers
507
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
421
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. (...
- 149
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
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:
...
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 ...
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 ...
0
votes
1
answer
282
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 ...
1
vote
0
answers
505
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: ...
- 7,601
12
votes
3
answers
32k
views
pgAdmin list of keyboard shortcuts
I've been using pgAdmin for several days and so far I like it. However, I can't find a list of keyboard shortcuts documented anywhere, either on the pgAdmin site, in the help, or in the options menu.
...
CommunityBot
- 1
3
votes
1
answer
676
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, ...
CommunityBot
- 1
4
votes
0
answers
797
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
9
votes
2
answers
21k
views
How to keep connection alive in pgAdmin
In pgAdmin, if I'm connecting to a host and leave it idle for a few minutes, the connection drops, and I have to reconnect again. On many occasions pgAdmin also hangs when I try to reconnect, so I ...
CommunityBot
- 1