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.
20
questions
1
vote
0
answers
354
views
PostgreSQL 12.5/ pgAdmin - postgis. Error: column p.proisagg does not exist [duplicate]
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 ...
- 11
1
vote
1
answer
715
views
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 ...
- 13
0
votes
2
answers
2k
views
Connect to a local PostgreSQL server using peer auth with pgAdmin
Context
I have a PostgreSQL server running on a remote machine, but I'm connected locally through VPN.
Its pg_hba.conf file is accepting peer auth for local connections;
local all ...
- 300
6
votes
1
answer
12k
views
PostgreSQL 12: column proisagg does not exist [duplicate]
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 ...
- 165
2
votes
1
answer
6k
views
pgAdmin4 or pgAdmin3? [closed]
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 ...
- 167
-6
votes
1
answer
46
views
Subquery with IN clause [closed]
I have a table named “groups” whose projects have been funded as shown
I have written a query giving the names of all groups that were funded in both 2014 and 2018 using the INTERSECT clause as ...
0
votes
1
answer
143
views
adding pgadmin3 to windows start menu
I have installed postgres (different versions actually) as well as pgadmin3 on windows using the package manager:
https://www.openscg.com/bigsql/package-manager/
https://www.openscg.com/bigsql/docs/...
- 848
1
vote
1
answer
3k
views
Error on starting pgadmin3 [closed]
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 ...
- 111
0
votes
1
answer
5k
views
Unable to add a new connection to server in PostgreSQL using pgAdmin
I am new to PostgreSQL and trying to configure it. After installing the PostgreSQL. I am trying to add a new connection to server using pgAdmin. I know there is a by default created on port 5432 but I ...
- 167
1
vote
1
answer
512
views
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 ...
1
vote
1
answer
2k
views
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. ...
- 305
0
votes
2
answers
9k
views
Execute pgScript in pgAdmin 4 while skipping errors
In pgAdmin3, via the SQL Editor, there is an Execute pgScript button which (unlike Execute Query) would run through the entire script, skipping errors. The SQL editor in pgAdmin4 doesn't appear have ...
- 133
10
votes
4
answers
12k
views
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....
- 203
1
vote
2
answers
363
views
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 ...
- 113
1
vote
1
answer
773
views
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 "...
4
votes
2
answers
3k
views
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.
- 143
1
vote
2
answers
2k
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 ...
- 317
2
votes
2
answers
5k
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 ...
- 344
11
votes
6
answers
51k
views
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:
...
- 603
61
votes
3
answers
103k
views
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 ...
- 729