pgAdmin is a graphical administration and development tool for PostgreSQL.

learn more… | top users | synonyms

1
vote
0answers
16 views

pgAdmin is extremely slow on any remote operation

I run this query from my local pgAdmin connecting remotely to our dev server: select * from users order by random() limit 1; it hangs for 17 seconds and shows Total query runtime: 148 ms. 1 row ...
0
votes
0answers
16 views

is there a GUI client that can execute multiple queries and show its multiple results?

I'm currently using pgadmin and it appears that it is not possible to send more than one query and retrieve multiple data sets back. For example, if I try to do this: select travelerId, name from ...
1
vote
1answer
33 views

Is it possible to view a SQL query in the PgAdmin III Graphical Query Builder?

I often use pgadmin III's graphical query builder to design my SQL queries. I can then toggle back to the SQL Editor tab, and grab the SQL. Is it possible to paste a SQL query in to the SQL Editor ...
1
vote
0answers
69 views

Improve lookup of 1.5 million rows

I have this table with data but we need to get all the (unique) rdx and rdy values: CREATE TABLE public.positions ( datetime timestamp without time zone NOT NULL, unitid bigint NOT NULL, rdx ...
0
votes
1answer
19 views

Connecting existing Postrgres database with pgadmin

I have a pg database and recently I have installed pgadmin3 to view the table and data in it. After installing pgadin3, I am confused how to display my existing pg database in pgadmin3. How to link my ...
0
votes
1answer
28 views

pgAgent doesn't run on another database than “postgres”

I run a postgreSQL 9.3.3 database and I want to do some automatic Tasks with pgAgent, but it doesn't run on another database than "postgres" db. What can I do to run pgAgent on another db ? thanks ! ...
0
votes
1answer
57 views

How do I load a data-only dump created with pg_dump to another database?

I have two PostgreSQL databases on my development server, one I use for development and another for production where I test my web applications. When I was using an earlier version of PostgreSQL I was ...
0
votes
1answer
56 views

See entire string from a lengthy text field in pgAdmin?

Using pgAdmin, how can I see the entire string value for a row when the value is very long? For example, the value may be comma-separated values (CSV) content with hundreds or thousands of ...
0
votes
1answer
18 views

Returning results from many functions / statements

I have a function that I will be running 10-50 times at once: importsitechanges(33, 209703, 'Store Name', 'Addr', 'city', 'state', 'zip', 'phone') This function that I made returns the number of ...
0
votes
1answer
59 views

Keyboard shortcut to execute statement at cursor in pgAdmin

In MySQL Workbench, one can use the keyboard shortcut Ctrl + ENTER to execute the statement at cursor (delineated with semi colons). Is there a similar shortcut in pgAdmin?
0
votes
1answer
37 views

Checking whether my pgAdmin III is a 32 or 64 bits version

I need to check if my pgAdmin III is a 32 or 64 bits version. Where can I find this information? The About... menu in pgAdmin GUI does not mention it (only the version number like 1.20). I've looked ...
1
vote
1answer
48 views

Where can I see the exact row count of a table in pgAdmin III?

Where can I see the exact row count of a table in pgAdmin III? I know where to find the approximate row count: I am also aware I can SELECT COUNT(*) FROM my_table. But I want to know whether the ...
4
votes
1answer
65 views

DISTINCT ON vs ROW_NUMBER() for getting a row with a maximum value of a group

I have the following table in PostgreSQL 9.4: CREATE TABLE dpa( id serial NOT NULL, currency_id integer, amount numeric(14,3), date timestamp without time zone, plat_id integer, pl_id ...
1
vote
0answers
180 views

PgAgent unable to run a job

I am running PostgreSQL 9.4.5 on Ubuntu 14.04.3. I am trying to set up pgAgent job but I keep getting this error: DEBUG: Creating DB connection: user=xxx host=localhost port=5432 dbname=otherdb ...
0
votes
0answers
34 views

How to disable switch user option in PgAdmin

I have created read only user with following command (executed from postgres user) create user read_user with password 'read_pwd'; revoke all privileges on database db1 from public; revoke all ...
2
votes
1answer
426 views

PostgreSQL “size of temporary files”

I've imported data into a new database (about 600m rows of timestamp, integer, double). I then created some indexes and tried to alter some columns (got some out of space issues), the database is ...
1
vote
0answers
67 views

pgAdmin export line overflow on large field

Background: I have a database of significant geographical locations downloaded from GeoNames open database. The create script for the table is as follows CREATE TABLE populargeonameswiki ( geonameid ...
1
vote
1answer
109 views

PostgreSQL - pgAdmin - path to database

I am new to PostgreSQL and I can not found info about this. I am using pgAdmin III and my databse files are kept in instalation directory of PostgreSQL. So far so good. But now, I need to create huge ...
4
votes
1answer
699 views

RETURN TABLE is converted to RETURN SETOF int in Postgres function

In pgAdminIII I create a function that returns multiple rows in a single column named identifier using RETURN TABLE: CREATE OR REPLACE FUNCTION test( IN parm1 date, IN parm2 interval) ...
0
votes
0answers
29 views

Will pgAdmin III let me run an SQL command that works after detaching from my SSH tunnel?

I just discovered pgAdmin III and I am absolutely overwhelmed by the number of options it offers. I'd like to try to replace my traditional workflow (psql ran over an SSH session) with this tool. The ...
0
votes
1answer
184 views

How to execute two transactions concurrently in PostgreSQL?

I want to execute two transactions concurrently in pgAdmin: --The first transaction should modify the age of Paul BEGIN; DECLARE newage INTEGER; --the original age of Paul is 32 newage := Select age ...
3
votes
2answers
2k views

Error 42P01: relation does not exist

I'm new at creating databases, and this error has me dumbfounded, as I am super new with DB admin things (I mostly do reporting type queries). I created a new database through pgAdmin3 GUI, and I'm ...
0
votes
1answer
718 views

pgAgent : how to configure pgpass.conf for a local connection on Windows Server 2008

I try to configure pgAgent on Windows server 2008 to make automatic backup on the database. pgAgent is installed on the server and the service is running normally. I use PgAdmin3 and PostgreSql 9.3 I ...
0
votes
0answers
19 views

How to define Server Properties for pgadmin3 from command line?

With pgadmin3, File>AddSever... allows you to define a number of Properties for a Server using the GUI. Is there a command line method for doing this before invoking pgadmin3?
1
vote
1answer
2k views

Is there a timeout option for remote access to PostgreSQL database?

I'm working via pgAdmin III on a remote PostgreSQL database. After a not so long period (say 10-15 min.) without doing anything in pgAdmin, the connection automatically expires. I therefore have a ...
1
vote
1answer
85 views

PgAdmin III - Number of lines returned during insertion

Not crucial question here, just curiosity. I am inserting data via multiple scripts in a base running in PostgreSQL. I wanted to test the time requested to end the insert, so I requested many times ...
0
votes
1answer
105 views

How to use language PL/PythonU on a PostgreSQL database via phpPgAdmin?

I am used to PgAdmin III where I can simply create python functions like the following on a PostgreSQL database: CREATE OR REPLACE FUNCTION pyHello (x integer) RETURNS void AS $$ if x == 1: ...
1
vote
0answers
74 views

Pass a URI as a pgAdmin parameter

I can connect to Heroku with psql passing a URI: $ psql postgres://user:password@ec2-54-243-xxx-xxx.compute-1.amazonaws.com:5432/d7xkxididkdi I want to do the same with pgAdmin: $ pgadmin3 -qc ...
3
votes
0answers
130 views

XRC error when trying to access PostgreSQL view properties

I have strange problem, when trying to access PostgreSQL view properties through PgAdmin III: Error: XRC error: 197: invalid row index 1: must be less than 1 After this error is displayed, I am ...
1
vote
1answer
85 views

pgAdmin-III - Option to load a favorite automatically when opening query window

pgAdmin-III - Query window option Does pgAdmin-III has any option to load a default favorite file automatically when opening new query window? This would be much useful to have commit/rollback ...
2
votes
1answer
878 views

Connect to PostgreSQL via a ssh tunnel using Cygwin

I would like to connect to a Postgres server installed on a remote server using an ssh tunnel. I have Windows so I use cygwin for SSH. I do the following on cygwin: # Create the tunnel ssh -f ...
0
votes
2answers
614 views

pgAgent Job's “last result” is continuously “running”

I am using PostgreSQL-9.3 on Ubuntu-14.04 and using "/usr/share/pgadmin3/pgagent.sql" I have configured my pgAdmin3 to use pgAgent. postgres is my maintenance Db and I have run the pgagent.sql content ...
0
votes
0answers
501 views

How to enable implicit casts in PostgreSQL >=9.2?

Coming from this topic on SO a user suggest me to enable implicit casts in my PostgreSQL and I don't know how to do that. I also don't know if this is a good practice or if it's the solution to the ...
0
votes
1answer
43 views

Multiple queries and a report

im fairly new to databases. I have multiple query's that i normally run individually at the end of loading data to my table doing simple integrity checks like length ,char types and so on (see ...
3
votes
2answers
549 views

Postgresql - Do Foreign Key Constraints Automatically Create Indexes?

Per the PGSQL 9.3 docs: Because this is not always needed, and there are many choices available on how to index, declaration of a foreign key constraint does not automatically create an index on ...
6
votes
1answer
1k views

PGAdmin III Server Status Error: Could not read directory “pg_log” No such file or directory

Running PostgreSQL 9.3 on Ubuntu 14.04 and pgAdmin III 1.18.1 on Windows 7. I tried Tools->Server Status and I get an error: "Could not read directory "pg_log" No such file or directory" I ...
0
votes
1answer
790 views

remote postgresql 9.3 login using pgadmin3 and a public network server to connect to LAN-only machine

I want to connect to a machine running postgresql 9.3. The machine itself is not reachable via a direct IP but is in a LAN with another machine with a public IP address. My current approach is: ...
3
votes
2answers
9k views

Connect to PgAdmin III via localhost

I just want to login for first time, from pgAdmin III via localhost on openSuSE 13.1 64x. My pg_hba.conf: # TYPE DATABASE USER ADDRESS METHOD # "local" is for ...
0
votes
0answers
384 views

Having trouble configuring phpPgAdmin with PostgreSQL 9.3 on CentOS 6

Trying to hook up phpPgAdmin on my virtual box and having some issues with pg_hba.conf. I added the IP I SSH through, connecting through a VPN, in IPv4 and changed all the methods to md5. I then go to ...
2
votes
1answer
516 views

How to insert into view through GUI in pgAdmin?

I have some updateable views for inserting the data. The reason is not just "security layer", inserting into some 10 tables directly would be a pain without the view with INSTEAD OF trigger. In ...
0
votes
1answer
227 views

Issue working with Postgres on Windows

I am running PostgreSQL 9.3 on my machine. I have PhpPgAdmin running on a cloud, using which I exported the database I am supposed to be working on, selecting "Structure and Data" and "Download". ...
1
vote
1answer
177 views

Postgres: my “data/backup” directory is way too large

In my postgres 9.3 data directory, there exists a subdir called "backup" that is 6.1G compared to my pg_xlog which is only 130M. I understand that pg_xlog is the WAL logs, so what is in the backup? ...
6
votes
2answers
2k views

What is the Maintenance DB asked by pgAdmin?

pgAdmin dialog for adding new database connections asks for a "Maintenance DB". In order to be able to connect, I set it to the database I want to connect (and also, I have the rights to connect). ...
1
vote
0answers
701 views

pgAdmin goes “out of memory” with large queries

I am trying to run query with results stored in file from PostgreSQL. Now I am trying to use pgAdmin for this task: running query to file option. Problem starts with large queries. When I try running ...
0
votes
1answer
2k views

pgAdmin on a fresh OS X Server installation

I know for sure postgresql is running (checked with ps ax), but when I install pgAdmin and try to make a server connection to localhost I get this error: Server doesn't listen The server doesn't ...
2
votes
1answer
3k views

Setting password for 9.3 PostgreSQL server [closed]

I currently have a 9.3 server running (on Ubuntu 14.04) with "trust" set as the authentification method in pg_hba.conf. How can I set the password again. In pgadmin the server currently doesn't allow ...
1
vote
1answer
3k views

Authentification failure for PostgreSQL server (9.3)

I can currently not connect to my Postgresql server (9.3) from pgadmin (Running on Ubuntu 14.04). The server according to pg_lsclusters is on port 5433. Ver Cluster Port Status Owner Data ...
1
vote
0answers
1k views

Slony-I creation scripts not available; only joining possible

I try to start Slony replication. I have PostgreSQL 9.3.4, PgAdmin III 1.18.1 and Slony-I 2.2.0-1. I have set the path to Slony to D:\GIS\PostgreSQL\9.3\share where I have the Slony files. Whenever I ...
1
vote
0answers
440 views

How to apply a patch to pgAdmin III 1.18.1 on Windows?

A follow-up question to this one: How to apply a patch in PostgreSQL on Windows? There is a lot of .patch files distributed everywhere, but no hints how to apply them (at least no hints that wouldn't ...
0
votes
1answer
117 views

Guru hints not working in pgAdmin

Guru hints don't work on my pgAdmin (1.18.1) - no hint was ever shown, "Hints" item in "Help" menu is grey and even though I can set options for the hints, the changes won't save - when I open ...