pgAdmin is a graphical administration and development tool for PostgreSQL.

learn more… | top users | synonyms

1
vote
1answer
22 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
10 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: ...
1
vote
2answers
61 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
80 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 ...
1
vote
1answer
42 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
58 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
50 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? ...
0
votes
2answers
70 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
150 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 ...
1
vote
2answers
60 views

How can I get PostgreSQL to not advance sequences when COPY fails?

I'm importing CSV files into a relatively simple PostgreSQL database. (The CSVs are sometimes created manually from information in a book, sometimes created from spreadsheets with a little massaging ...
0
votes
1answer
106 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 ...
1
vote
0answers
264 views

Setting password for 9.3 PostgreSQL server

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 ...
0
votes
1answer
720 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
308 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
147 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
45 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 ...
0
votes
1answer
235 views

Installing pgcrypto Extension

I have this password hash function that hashes a password to sha256. I've already got it running in pgadmin3 in a local database. I've done it by importing the extension, a feature that has been added ...
1
vote
1answer
85 views

Organizing Postgres Databases

Is there a way in pgAdmin to organize Postgres databases into "folders" or groups? Each Django project I'm creating has it's own Postgres database, and I would like to find a way to organize them. I ...
1
vote
1answer
122 views

Postgresql: When using SSH tunnel, I receive the fe_sendauth: no password supplied error

I am SSH Tunneling to my postgreql server. I have previously successfully configured 9 + win XP dev PCs to connect to this postgresql server, those PCs still connect successfully. I am now setting up ...
1
vote
1answer
202 views

How to edit `postgresql.conf` with pgAdmin?

How does one edit the 'postgresql.conf' file with the pgAdmin app? With pgAdmin 1.18.1 on Postgres 9.3.x, when I choose File > Open postgresql.conf I get a file picker dialog. And, yes, I'm connected ...
3
votes
2answers
1k views

PGAdmin3 connection with non standard SSH port and SSH tunnel

Hi I am trying to connect to Postgres from pgAdmin3 using SSH tunneling. However I am not using standard port 22. How can I do SSH tunneling using a non standard port?
0
votes
1answer
168 views

PostgreSQL: Cannot Connect to Server via PgAdmin, Password Auth Failed [closed]

I've been attempting to connect to my server's PostgreSQL database. The error message I am getting is "Error connecting to the server: FATAL: password authentication failed for user "postgres" I've ...
0
votes
1answer
1k views

How can I import a database dump (.sql) using pgAdmin without the PSQL Console plugin?

I am trying to import a database dump (.sql) using pgAdmin. I want to do it using only the GUI, not the PSQL Console (where I can import the sql dump using \i /path/to/yourfile.sql on Unix or \i ...
0
votes
1answer
280 views

PostgreSQL - pgAdmin error creating a server

I have the latest versions of PostgreSQL and its GUI-frontend, pgAdmin, installed. When I try to register a new server a fatal error appears when pgAdmin tries to connect to the newly created server - ...
0
votes
1answer
2k views

PostgreSQL Error : server closed the connection unexpectedly

I cannot connect to PostgreSQL server from PgAdmin III , so i get this error: Error connecting to the server: server closed the connection unexpectedly This probably means the server ...
3
votes
3answers
2k views

save/export PGAdmin server list configuration settings

I have a ton of configured connections listed in the Server Groups, is there a way I can save this? not just save the passwords but the Server Group Settings
1
vote
1answer
93 views

Listing all databases in PostgreSQL [closed]

I have a basic question about PostgreSQL: When connecting to my database server via pgadmin3, I can see that there are multiple databases. For example, let's say I can see "test", "test1", and ...
1
vote
2answers
562 views

How can I keep a result set without keeping the transaction open?

The following documentation describes how to see the refcursor returned from a function, here, like this: CREATE FUNCTION reffunc(refcursor) RETURNS refcursor AS ' BEGIN OPEN $1 FOR SELECT ...
1
vote
1answer
82 views

Why are query results shortened in pgAdmin 1.18.1?

I've recently installed pgAdmin 1.18.1 and noticed a strange thing: Long json query results are shortened to 256 symbols and then ' (...)' is added. Could someone help me disable this shortening?
0
votes
0answers
161 views

Unable to push table from pgadmin to heroku

I have tried https://devcenter.heroku.com/articles/heroku-postgresql#local-setup but heroku pg:psql keeps returning "not found" heroku pg:psql app::databaseName returns The local psql command could ...
0
votes
1answer
59 views

Query Pane Docking in pgAdmin3

I just started using pgAdmin3. I do not like having to have a new window when I want to run ad hoc SQL queries. Is there a way to do dock it within the top level app and actually show in the main ...
2
votes
1answer
3k views

pg_restore error from pgadmin3 - Postgresql

i have taken a backup of a postgresql db from a system1 using pgadmin3 tool. The backup file created is of extension ".backup" I am trying to restore it on an another system2 installed with ...
0
votes
2answers
604 views

Backup with pgAdmin ordered by ID

I want to backup a postgres table with pgAdmin and have the dump ordered by ID (or any other column). How do I do that? [EDIT] The dump should contain INSERT queries, not the pure data! [/EDIT] What ...
2
votes
2answers
5k views

Connecting to an external database with pgAdmin III

I'm trying to connect to an external database from pgAdmin III (which is installed on both machines). The client complains: Access to database denied The server doesn't grant access to the ...
1
vote
1answer
311 views

How can I speed up PgAdmin III Queries?

I've been noticing that PgAdmin III isn't as responsive as I expected it to be. For instance a query to select * ... from a table containing 20,397 rows takes 19.531 seconds in PgAdmin III and 7.383 ...
0
votes
0answers
28 views

Calculating the row size of a table [duplicate]

Is there a way to calculate the row size (in bytes) of a particular table in postgresql / pgadmin3?
2
votes
1answer
271 views

pgAdmin to display multiple result sets

With MS SQL Query Browser I can run multiple queries at the same time and each result set will display in it's own window. Does PostgreSQL/pgAdmin have this functionality? Plugin perhaps?
1
vote
1answer
293 views

Profiling a PostgreSQL function [duplicate]

if I use explain (analyze true, verbose true, costs true, buffers true) select * from mystoredprocedurefunction(arg1, arg2); I do not get any information about what the server is actually doing ...
0
votes
1answer
500 views

Query result with X rows discarded

In a transaction, if I select results to display to the screen, I get the message Query result with x rows discarded. How can I view those results? Something is amiss with my query and I want to see ...
0
votes
1answer
2k views

pgAdmin3 can't connect properly to Postgres 9.2

I have installed pgadmin3 version 1.10.2, however when it connects to PostgreSQL server version 9.2, it says: Warning: This version of pgAdmin has only been tested with PostgreSQL version ...
0
votes
0answers
784 views

Server doesn't listen

I try in Win7 by means of PGAdmin 3 to be connected to a host 192.168.1.8 with the virtual machine with linux. Already which time I receive the message Server doesn't listen The server doesn't accept ...
0
votes
1answer
269 views

No way to set maximum retrieved rows in pgadmin query tool

I'm using version 1.16.1, and I can't find a "max(imum) rows" param to tweak. Any help would be appreciated.
3
votes
1answer
6k views

Usage of COPY FROM STDIN in postgres

I just started using Postgres and I'm trying to create a sample db to understand its functions, looking around, I found some scripts in pgfoundry.org. I understand the commands, since I previously ...
2
votes
2answers
2k views

Creating a PostgreSQL SERIAL column using pgAdmin3

When I use pgAdmin3 to create a column of type serial, why does it instead create nextval('prices_id_seq'::regclass)? Should we keep this type defined by pgAdmin? Manually create the table with SQL ...
1
vote
1answer
645 views

Why does pgAdmin3 set OIDS=FALSE and owner to postgres by default?

Why does pgAdmin3 automatically set the table owner to postgres when its created and set OIDS=FALSE? I am new to PostgreSQL and want to know the rational behind this default behavior. -- Table: ...
1
vote
3answers
493 views

PostgreSQL newbie - how to create objects in a database

I've just finished installing PostgreSQL and pgadmin3 on Ubuntu. Using pgadmin, I've been able to create a new user called 'test' and also a new database with 'test' as the owner. Now I'm trying to ...
0
votes
1answer
227 views

Retrieving all PK and FK with pgadmin

I have a big database that I need to extract all primary keys and foreign keys from each table. I have pgAdmin III. Is there a way to do this automatically and not go over each table manually?
1
vote
1answer
231 views

postgresql pgadmin3 queryconnect attribute does not work

I'm using Fedora 17 and pgadmin3 to auto-connect to a postgresql database with one button click. Every time I want to run an SQL statement, I have to do 4 steps, (open pgadmin3), (connect to the ...
2
votes
2answers
6k views

PostgreSQL not working, pgAdmin always says server not listening

I am brand new at this so maybe it's a simple mistake. I was given a very large .sql file with the instructions to make a copy of a database locally on a computer. I was told "to be able to install ...
4
votes
2answers
6k views

Connecting pgAdmin3 to Postgres on Heroku

I'm running a Heroku Postgres database (Database) in assosciation with a Django app. The docs that refer to the add-on are here. I thought this would be a worthwhile question for the community ...