The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
18 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 ...
0
votes
0answers
18 views

Pgpass gives error code

I have this code in my pgpass file 149.210.204.94:5432:mydatabasename:myusername:mypassword when I execute this i gives the error connection to database "mydatabasename" failed: invalid port ...
2
votes
1answer
207 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, ...
0
votes
1answer
195 views

pgadmin3 failed dependencies which are already installed?

I try to install pgadmin3 in a system with OpenSUSE 12.1 After download pgadmin3-1.14.0-2.1.2.i586.rpm I try rpm -ivh pgadmin3-1.14.0-2.1.2.i586.rpm and have the following errors: Failed ...
7
votes
1answer
5k 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 ...
2
votes
1answer
5k 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 ...
1
vote
1answer
1k views

How display result of multi select in PgAdmin III?

select 1 as a,4 as b, 5 as c; select 1 as a,3 as b; Result display only of `select 1 as a,3 as b; How display result of multi select in PgAdmin III?`
3
votes
2answers
5k 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 ...
0
votes
1answer
174 views

Why does PgAdmin III give warning that PgAdmin.exe has disappeared from C drive?

So I'm currently working with PostgreSQL, PostGIS, p-mapper, and QuantumGIS to build a web-mapping system. And earlier this morning, I opened PgAdmin III just to check on my database, no editing, no ...
4
votes
3answers
9k 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. ...
1
vote
2answers
3k 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?
0
votes
1answer
283 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 ...
1
vote
2answers
7k views

How to install pgAdmin

I use Ubuntu 12.04 64 bit. At first I installed pgAdmin through Software Center. But it seemed old. So, I decided to uninstal it. Then I downloaded graphic installer for PostgresQL. sudo ./...
1
vote
1answer
13k views

How do I restore a plain text postgres .backup file

I exported a postgres db from pgAdmin in a plain format because I wanted to search the whole db text. I then tried to restore the database back but it gives an error saying that the archive file is ...
2
votes
1answer
3k 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 ...
1
vote
0answers
560 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 ...