Questions tagged [pgadmin3]
12 questions
14
votes
2 answers
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 their settings (I have contacted them).
I am…
David
- 1,289
5
votes
1 answer
Install pgAdmin III on Windows 7 without administrator rights
I'm trying to install pgAdmin III, using the v1.20.0 package from pgadmin.org. I found a few sources that suggest I should be able to install it for the current user only without having to provide the administrator password, but I haven't been able…
Air
- 204
4
votes
1 answer
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 issue. I've tried simply deleting the app and…
user302183
4
votes
0 answers
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 there any option to control the row height? Somewhere…
Igor
- 163
3
votes
1 answer
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, but I noticed that psql was choking on these files…
2
votes
0 answers
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. However now when I run:
ps aux | grep…
Ahmed
- 121
1
vote
1 answer
Setting up postgresql server connection with pgadmin3 fails with Exception
I have installed postgresql database on Fedora 17.
When I create a new server connection through pgadmin3, I get this Error in a popup window:
postgresql The server doesn't accept the current user: The server report
Ident authentication failed
The…
Eric Leschinski
- 7,393
- 7
- 51
- 51
1
vote
1 answer
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. (anyway, can somebody with a reputation higher…
Jagger
- 151
0
votes
1 answer
Postgres DB table recovery
I was using PG Admin and modifying a table in my DB. I was actually adding two fields.
Once done, I hit the OK button and PG Admin hung up. I think this is the first time.
Now I cannot open that specific table through PG Admin. I'm not sure if this…
itsols
- 305
0
votes
1 answer
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 from the other system, but when I look at the…
0
votes
1 answer
PostgreSQL and PG Admin 3 Not Listening
I'm using PostgreSQL 9.4 with the PostGIS extension. Everything was working fine until I turned off my server to move it to a different location in my rack.
Now I get the error "Server doesn't listen". My .conf files have the "*" for listening range…
Kyle
- 1
0
votes
1 answer
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" field of Putty and 172.13.212.37:5432 under…
The Great
- 149