Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [pgadmin-3]

pgAdmin is an open source management tool for Postgres, the world’s most advanced open source database. pgAdmin III is still a stable and widely used product.

Use this tag if you have a question about the usage of pgAdmin III.

20 questions
67
votes
3 answers

How to view data in pgAdmin III

I can't believe they make it this hard. I am at a loss about how to view the data in my database. Is there an easy way to see what data is in my tables with pgAdmin III? Alternatively, is there a program that I could use that does not suck?
Alexis K
  • 789
  • 1
  • 5
  • 5
11
votes
4 answers

PgAdmin III -- how to merge output pane and query pane

Somehow, I clicked on something the wrong way and popped the output pane out into a separate window from the query pane. I've tried restarting my computer, restarting PgAdmin III, but nothing fixes it. It's really annoying, and very hard to work…
dlb8685
  • 213
  • 1
  • 2
  • 5
10
votes
6 answers

PostgreSQL user can not connect to server after changing password

I've met this with 4 roles I created: After changing password for a user in pgAdmin III using the GUI (1), that user can not log in any more. pgAdmin III show error message: An error has occurred: Error connecting to the server: FATAL: password…
Cao Minh Tu
  • 613
  • 1
  • 6
  • 8
7
votes
1 answer

PostgreSQL 12: column proisagg does not exist

I created a PostGIS database using the following images here (i.e. 9.3-2.1, 11.0-2.5 and 12.0 tags), however I'm getting the following errors when I try to open the 'public' schema: An error has occurred: 11:43:59: Error: ERROR: column…
rmmariano
  • 175
  • 1
  • 4
  • 9
4
votes
2 answers

Why is Server Configuration in Pgadmin3 inaccessible for me?

My Postgres server is running (localhost:5432), but Tools > Server Configuration is greyed out for me as below. I was attempting to access it to edit/locate my postgres.conf file.
Rome_Leader
  • 143
  • 1
  • 5
2
votes
2 answers

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 space (to the right of the connection hierarchy view…
amphibient
  • 354
  • 1
  • 6
  • 17
2
votes
1 answer

pgAdmin4 or pgAdmin3?

I've seen a lot of hate directed to pgAdmin4, but honestly I can't see why. It worked out of the box from a docker image, connected right away to the database and perfectly managed every maintenance and query I've made. Is there a good reason to…
Balbinator
  • 197
  • 2
  • 10
1
vote
0 answers

PostgreSQL 12.5/ pgAdmin - postgis. Error: column p.proisagg does not exist

pgAdminIII reports errors related with a column missing after installing postgis in postgres 12.5 and ubuntu 20.04 Error column proisagg does not exist where perhaps you meant pr.proisagg people reported this error en previous versions and…
Leo Bravo
  • 11
  • 1
1
vote
1 answer

pgAdmin - "cannot open logfile!" (WINDOWS 10; Postgres 9.4)

Our Windows 10 clients have both PostgreSQL 9.4 and pgAdmin3 (v1.22) installed. I keep receiving the FATAL: "Cannot open the logfile!" error by invoking pgAdmin3 in either of the following EXE locations. C:\Program Files(x86)\pgAdmin…
user9491577
  • 13
  • 4
1
vote
1 answer

Error on starting pgadmin3

When starting pgadmin3 I get the following error messages. This is the log file placed in my documents folder after starting: 2018-06-04 13:30:26 ERROR : ERROR: function pg_last_xlog_receive_location() does not exist LINE 1: ...E NULL END as…
blabbath
  • 111
  • 1
  • 5
1
vote
1 answer

PgAdmin 3 crashed when font size was increased

I am using PgAdmin 3 on Postgresql 9.4 on Windows 7. All things work well until I resized browser fonts from 12 to 18. I cant create database, rename table and even change the font size to what it was before. Many things stopped working. I have…
Chris Chukwuemeka
  • 21
  • 3
1
vote
1 answer

Why can't pgAdmin3 connect to Postgres?

I added a new user to posgresql (amanda) which is the same as my linux system user. At the console, I can open psql just fine -- I don't need a password because I'm already authenticated as amanda. But when I try to set up pgAdmin III without a…
Amanda
  • 305
  • 1
  • 3
  • 13
1
vote
2 answers

Problem with foreign key between 3 tables. (PgAdminIII)

I'm using pgAdmin III for PostgreSQL but I have a problem with foreign keys between 3 tables. My tables are: Locale with a primary key IDnegozio (integer type, no need to make it serial type) Orario with a primary key IDorario (integer type, no need…
JEricaM
  • 113
  • 4
1
vote
1 answer

Error with pgAdmin III and pg_hba.conf

I have a problem with my Pgadmin3.. I used to use the last year, but this year I can't connect with the localhost server with pgadmin This is the message error: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "postgres", database "postgres",…
Lucuano Alzugaray
  • 11
  • 1
1
vote
2 answers

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 for this on the net, without success... EDIT: I…
wiltomap
  • 317
  • 1
  • 4
  • 16
1
2