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. 1. C:\Program Files(x86)\pgAdmin III\1.22\pgAdmin3.exe 2. C:\Program Files\PostgreSQL\9.4\bin\pgAdmin3.exe The problem is that when pgAdmin3 starts the pgAdmin splash screen will not dismiss and you cannot gain access to configure the postgresql.conf file. I'm assuming the log file its looking for is pgAdmin.log but if I navigate to

:\Users\\Documents\postgresql

I cannot find such a log file. I tied to create an empty pgAdmin.log file whith not luck of gaining proper entry into pgAdmin3.

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 tried to uninstall Postgres and install another version but still the behavior is same, no change. Please what do I do. Thanks

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?

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 phpadmin https://dba.stackexchange.com/questions/238903/postgresql-11-error-column-p-proisagg-does-not-exist Solution there does not work Note /usr/share/phpPgAdmin/classes/database/ does not exist in my installation

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 authentication failed for user "sam" FATAL: password authentication failed for user "sam" My system: Postgresql 9.2 on Ubuntu 12.04 Is there any way to fix this? (1): login with account postgres, right click user in Login Roles, go to tab 'Definition' and enter password

# Context I have a [PostgreSQL](https://www.postgresql.org/) 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 postgres peer I don't like to change this. If I follow what is written here: https://documentation.help/pgAdmin3/connect.html ; > The host is the IP address of the machine to contact, or the fully qualified domain name. On Unix based systems, the address field may be **left blank** to use the default PostgreSQL Unix Domain Socket on the local machine, or be set to an alternate path containing a PostgreSQL socket. If a path is entered, it must begin with a “/”. The port number may also be specified. I got this error on [pgAdmin3](https://www.pgadmin.org/) : I even tried not to leave the Host field blank but to write the name of the socket file in there: /var/run/postgresql -> the behaviour is the same. And if I insert postgresql:// instead, I get; An error has occurred: 07:55:28: Error: Error connecting to the server: could not translate host name "postgresql://" to address: Name or service not known And pgAdmin4 doesn't let me have the Host field blank: Until there, I was logged in as the normal Ubuntu user. So I decided to try while being postgres Ubuntu user, just like when I want to run a pg_* command using peer auth (e.g. $ sudo -u postgres pg_* -U postgres bla bla): pgAdmin3: $ sudo -u postgres pgAdmin3 Client is not authorized to connect to Server07:44:11: Erorr: Unable to initialize GTK+, is DISPLAY set properly? pgAdmin4: $ sudo -u postgres pgAdmin4 QStandardPaths: XDG_RUNTINE_DIR not set, defaulting to '/tmp/runtime-postgres' Client is not authorized to connect to Serverqt.qpa.screen: QXcbConnection: Could not connect to display :1.0 Could not connect to any X display. Next I decided to check this out on my local machine in order to by-pass these display related errors pgAdmin3: $ sudo -u postgres pgadmin3 No protocol specified 07:49:51: Error: Unable to initialize GTK+, is DISPLAY set properly? I do not have pgAdmin4 on my local machine, but I guess I will encounter some same kind of error. # Question How can I log to the local PostgreSQL server which is based on a peer authentication using pgAdmin3 or pgAdmin4? # Update: These three new lines were added to the log file in /var/log/postgres/postgresql-12-main.log after the unsuccessful connection using pgAdmin3: 2020-04-16 16:34:55.548 CEST postgres@postgres LOG: provided user name (postgres) and authenticated user name (ubuntumainusername) do not match 2020-04-16 16:34:55.548 CEST postgres@postgres FATAL: Peer authentication failed for user "postgres" 2020-04-16 16:34:55.548 CEST postgres@postgres DETAIL: Connection matched pg_hba.conf line 85: "local all postgres peer"

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 this, is there an alternative that I haven't been able to find, or is there a parameter/command I can add to my script in order to skip errors at runtime? In this instance the script is auto-generated and only renames tables/columns which may not exist so the error output is not required. I can still run the script in pgAdmin 3 but connecting to a version 9 or above database with pgAdmin3 raises several warnings which don't seem to cause any problems but I'd rather find a solution than a workaround Using: PostGreSQL 9.5, pgAdmin4 1.6 --- UPDATE: according to this : > >How do we execute pgScripts in pgAdmin4? > > You cannot I'm afraid. They've been more or less unsupported for years > as they really became obsolete when Postgres introduced the DO command > for executing anonymous blocks of code in v9.0. ...it looks like I might be able to use DO to force it to behave like pSQL?

I created a PostGIS database using the following images [here](https://hub.docker.com/r/kartoza/postgis/tags) (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 "proisagg" does not exist
LINE 9:  WHERE proisagg = FALSE AND pronamespace = 2200::oid
HINT:  Perhaps you meant to reference the column "pr.prolang".

An error has occurred:

11:46:24: Error: ERROR:  column rel.relhasoids does not exist
LINE 1: ...t_userbyid(rel.relowner) AS relowner, rel.relacl, rel.relhas...

I found possible solutions [here](https://dba.stackexchange.com/a/238906/181099) and [here](https://sourceforge.net/p/phppgadmin/bugs/469/) . I tried to ask how should I update the query, but I need at least 50 reputation to comment. Would anyone know how should I fix this question? Or how should I change the definition of the query on pgAdmin? Thanks in advance. **System:** - PostgreSQL 12.0 (Ubuntu 12.0-2.pgdg16.04+1) - pgAdmin III - Ubuntu 16.04 LTS

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 keep using pgAdmin3?

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 follows SELECT group.NAME FROM group WHERE group.YEAR = 2014 EXCEPT SELECT group.NAME FROM group WHERE group.YEAR = 2018 I want to write this same query using a sub-request with the IN clause but I am unable to write the condition. This is what I have SELECT group.NAME FROM group WHERE group.YEAR IN (SELECT group.YEAR FROM group WHERE group.YEAR = 2014 AND group.YEAR = 2018)

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 with if I have more than one query window open. Hopefully the image shows what I'm talking about. What can I do to pop the output pane back into the bottom of the query pane?

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/pgcli/pgcli/ I also added the bin directories into the path environment on windows. Is there any way I can install program shortcuts to the start menu in windows?

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.

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", SSL on FATAL: no pg_hba.conf entry for host "127.0.0.1", user "postgres", database "postgres", SSL off My pg_hba.conf file have this content: TYPE DATABASE USER ADDRESS METHOD local all all trust I can connect without problems with psql. My user is postgres and my pass is postgres too. I have information in the database, i don't have idea what's happen. My OS is Linux Lubuntu 14.04

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 inrecovery, CASE WHEN usesuper THEN > pg_last_xl... > ^ HINT: No function matches the given name and argument types. You might need > to add explicit type casts. 2018-06-04 13:30:34 ERROR : Column not > found in pgSet: usecreatedb 2018-06-04 13:30:36 ERROR : Column not > found in pgSet: usesuper 2018-06-04 13:30:37 ERROR : Column not found > in pgSet: upsince 2018-06-04 13:30:37 ERROR : Column not found in > pgSet: confloadedsince 2018-06-04 13:30:37 ERROR : Column not found > in pgSet: inrecovery 2018-06-04 13:30:38 ERROR : Column not found in > pgSet: replayloc 2018-06-04 13:30:39 ERROR : Column not found in > pgSet: receiveloc 2018-06-04 13:30:39 ERROR : Column not found in > pgSet: replay_timestamp 2018-06-04 13:30:40 ERROR : Column not found > in pgSet: isreplaypaused 2018-06-04 13:30:41 ERROR : Column not found > in pgSet: rolcatupdate 2018-06-04 13:30:41 ERROR : Column not found > in pgSet: rolcatupdate 2018-06-04 13:30:42 ERROR : Column not found > in pgSet: rolcatupdate 2018-06-04 13:30:43 ERROR : Column not found > in pgSet: rolcatupdate 2018-06-04 13:30:44 ERROR : Column not found > in pgSet: rolcatupdate 2018-06-04 13:30:45 ERROR : Column not found > in pgSet: rolcatupdate What do I have to do to avoid these errors in the future? EDIT I am running on MacOS 10.13

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 change this port to 5433. And trying to configure all my database on this port. And through terminal this is working. But when I am trying to add a new connection to a server it throws 09:56:56: Error: Error connecting to the server: FATAL: password authentication failed for user "tars" FATAL: password authentication failed for user "tars" I have already followed this thread here. And also tried configuring pg_hba.conf. Changed this line local all all peer to local all all md5 But couldn't add a new connection. This is the screenshot, the way I am trying to configure Can someone help me to create a new server ? And also help me to understand this little bit.

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 password, I get an error: An error has occurred: 01:18:47 PM: Error: Error connecting to the server: fe_sendauth: no password supplied And if I provide my system password, I get a password error: An error has occurred: 01:15:30 PM: Error: Error connecting to the server: FATAL: password authentication failed for user "amanda" FATAL: password authentication failed for user "amanda" How do I get pgAdmin3 talking to postgres as amanda? This is all @ localhost. I read this: https://dba.stackexchange.com/questions/8111/pgadmin-iii-how-to-connect-to-database-when-password-is-empty but the answer there discusses trust authentication. My read of the [auth methods](https://www.postgresql.org/docs/9.1/static/auth-methods.html#AUTH-TRUST) section of the manual suggests that what I want is for pgAdmin3 to use Ident Auth.

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 get a win32 error when pgAdmin crashes (connection lost). See image below (sorry my Windows is a french version):

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 to make it serial type) **OrarioToLocale** with two columns: **IDlocaleT** & **IDorarioT** (both integer). I'm trying to make a foreign key between IDlocale -> IDlocaleT and IDorario -> IDorarioT so, I can have the relation that a Shop can have multiples time. The problem is that when I try to make these foreign keys, and an error occurs me: "no unique constraint matching is given keys for referenced table" and I don't understand why. I tried to google but I didn't find any answer! How can I do? This is the code of the three tables: CREATE TABLE public."Locale" ( "IDnegozio" integer NOT NULL DEFAULT nextval('"Locale_IDnegozio_seq"'::regclass), CONSTRAINT "Locale_pkey" PRIMARY KEY ("IDnegozio"), ) CREATE TABLE public."Orario" ( "IDorario" integer NOT NULL DEFAULT nextval('"Orario_IDorario_seq"'::regclass), CONSTRAINT "Orario_pkey" PRIMARY KEY ("IDorario") ) CREATE TABLE public."OrarioToLocale" ( "IDlocaleT" integer NOT NULL, "IDorarioT" integer NOT NULL ) How can I do? Thank you advice!

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 on the left)?