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
-6
votes
1answer
38 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
0answers
13 views

Importing Access Database file to postgres by pgAdmin3

I have many tables in a MS access database file. I want those tables to directly import in postgres (pgAdmin3). Thanks in advance.
0
votes
0answers
42 views

PgAdmin3 connection to database failed with no error messages

I have a local postgres database with PgAdmin3 LTS by BigSQL on my laptop that until today I could access without any problems. When I tried to access it today by typing the password I get only a "...
0
votes
1answer
34 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/...
0
votes
1answer
1k 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
755 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
116 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
1k 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
1answer
3k 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 ...
3
votes
4answers
2k 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
288 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
440 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 "...
3
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
970 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
4k 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
36k 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: ...
40
votes
2answers
73k 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 ...