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.

Filter by
Sorted by
Tagged with
0
votes
2answers
57 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 ...
4
votes
1answer
4k 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 ...
1
vote
1answer
2k 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 ...
-6
votes
1answer
42 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
1answer
68 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/...
1
vote
1answer
2k 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 ...
0
votes
1answer
2k 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 ...
1
vote
1answer
243 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 ...
0
votes
1answer
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. ...
0
votes
2answers
5k 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 ...
6
votes
4answers
6k 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....
1
vote
2answers
343 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 ...
1
vote
1answer
531 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
2answers
2k 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.
1
vote
2answers
1k 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 ...
2
votes
2answers
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 ...
10
votes
5answers
41k 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: ...
47
votes
2answers
80k 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 ...