**Problem:** I've installed the latest web version of pgAdmin4: 9.6, using the official pgAdmin Docker image: dpage/pgadmin4, and all seems to be working fine, except the main tool: "query tool", when I click on "query tool" icon, it just keeps opening blank tabs. (can't even close them) **Tried:** - logging off - restarting image - resetting layout - reinstalling 9.6 - trying with 9.5 - trying with 9.1 **Notes:** - I've tested the DB and connection string of the same DB on my Desktop version of pgAdmin(also 9.6) and everything works, including "query tool" (so the DB and connection string are fine...have only issues with this docker web versions)

I was sitting on pg14 for some time, while the postgresql package updates accumulated all the way up to 17, so the result of pg_lsclusters looks like this:

Ver Cluster Port Status Owner    Data directory              Log file
14  main    5432 online postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main.log
15  main    5433 online postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log
16  main    5434 online postgres /var/lib/postgresql/16/main /var/log/postgresql/postgresql-16-main.log
17  main    5435 online postgres /var/lib/postgresql/17/main /var/log/postgresql/postgresql-17-main.log

I only have a connection to version 14 in my pgAdmin panel, but how do I add connections for other servers? They require the password for postgres which I either don't know or don't remember.
The thing tripping me up is I think I had a setup step a while ago where I created a copy of postgres user with the same name as the admin account in the OS, or the package created it for me on install. Thus I've used that admin role in place of postgres for superuser needs and forgot about original superuser. Possibly I've set a password for postgres (most likely generated one) within old version of pgAdmin, saved it and completely forgot about it afterwards.
But now I need to actually migrate my database to the newest version and thus the problem at hand. Versions: - postgreSQL - 17.4 - pgAdmin - 9.1 - Ubuntu - 22.04.5 LTS **EDIT**: I can "enter" into the other cluster with sudo --user=postgres psql --port=5435 (without a password), but not when calling it with TCP/IP socket sudo --user=postgres psql --host=localhost --port=5435. However sudo --user=postgres psql --host=localhost, which enters into 5432 server, does ask for password, which matches password of the OS admin account.
This does confirm that I in fact changed the password for postgres db user of 5432 server in order to create a connection in pgAdmin, and other clusters were created by the package updates according to their mystical rules.
It still begs the question what IS the proper way of handling default postgres user for pgadmin connection while also preserving linux way of handling it as an OS user? Because now I think setting a password for it to connect was not a right call.

I'm working with a Windows application that uses a (local) postgres Database and stores some information in a temporary table. I'd like to have a look at the temporary table, but pgadmin and dbVis tell me: ERROR: cannot access temporary tables of other sessions when trying to query the data. I tried changing the permissions of the schema and table, but this didn't seem to help, even though I'm accessing the database with the same user as the program itself (at least in dbVis). Is there a setting I can change in my database that allows me to have "root" access to all session in my database?

After a few months away from pgAdmin 4, I attempted to open the program - first time, it failed, second time it started up - but the database, called 'athome4' was missing. I checked in QGIS and the database and files still exist. So I would like to know how I can recover the connection to pgAdmin 4 so I can work with this database again. I simple step by step explanation would be best. I am very concerned that if I start work on a new project that this may happen again.

I am running pgadmin via Docker desktop. I am unable to restore a sql file in the database. I get the following message - "Please configure the PostgreSQL Binary Path in the Preferences dialog." In the case of PostgreSQL installed in the device, I am aware about assigning the binary path. However in this case, pgadmin is accessed via docker. how can I resolve this issue?

I am asking about *pgAdmin* internal user management , not *Postgres* users-and-roles. For teaching a beginning database class, I am trying to procedurally configure *pgAdmin* in Server Mode, using shell scripts, *Podman*, etc. In addition to the Administrator and User roles, I want to create a Student role with restricted permissions. The setup.py feature offers a command-line interface for configuring pgAdmin. It offers commands like: - add_user - get_role 👉🏽 Is there some procedural way to define a Role with Permissions? I need a console command equivalent for the *Permissions* tab in the *pgAdmin* GUI: I want to procedurally create a Role that effectively has some of those checkboxes unchecked.

I have a webapp I'm developing using Symfony 6.4 and Postgres 15. My Employer has given me a windows machine that is locked down and I can not get raised privileges. Anytime i want anything done i have to go through service desk. I have noticed that my PHP/Symfony app runs poorly compared to another (contract) developer who uses a linux distribution - so i figured I would set up WSL2 with ubuntu and try a full app set up there to see if there is a performance issue. I would really like my WSL Postgres AND my Windows Postgres to be accessible in pgAdmin4. I need them both for now while I complete this investigation. Without the admin privileges I cannot stop the windows PostgreSQL service. Has anybody achieved this, or knows how to achieve this? * I have the postgres installed on WSL2 Ubuntu * I have opened the conf file and set listen_addresses = 'localhost' * I have also tried 127.0.0.1 * I have tried setting the port on ubuntu to 5431 (instead of 2) Results:  

I have a ton of configured connections listed in the Server Groups, is there a way I can save this? not just save the passwords but the Server Group Settings

Can I have two different Query Editor panels in PGAdmin, side by side? If not, is there another way of avoiding the pain point that's making me want two panels? That is: When I'm building up a complex query, there's so much back-and forth that using the Scratch panel to swap queries gets cumbersome. It's like: * Start with a basic query. * Test run it. * Add a where clause * Cut-paste the query to the scratch panel * Run a little SELECT to find a valid value to test the new where clause with. * Move the query back from the scratch panel, plug in the testing value, retest. * Add a JOIN clause, retest * Add a WHERE clause using the new join * Again copy the query over to the scratch panel * Run another little select line to find a valid value to plug into the WHERE for testing. * Copy the query back from the scratch panel, plug in the new value, run the test again. * Repeat this iteration cycle until the query is where it needs to be. And the steps where I just move the query being built over to the scratch panel and back over and over and over feels like a distraction and needless busy work. If I could just have two Query Editor panes, and run my little SELECTs to find values in the second panel, there's be one less little chore dragging me out of flow state. Is there some way of getting a second Query Editor panel in pgAdmin? Or is there some alternate development habit I could be using so I wouldn't feel the need for one?

I have a big database that I need to extract all primary keys and foreign keys from each table. I have pgAdmin III. Is there a way to do this automatically and not go over each table manually?

I was running a query in pgAdmin III and it was taking a long time. After 9 minutes I decided to cancel it using the stop button. The UI stated that it was cancelling and stayed in that state for slightly over an hour before it reported as cancelled. For all that time the CPU was around 98-99%. The statement that was running was a call to a function. It was only part way through the function when it got stuck and all the time was taken on the following statement: SELECT ST_UNION(shape) FROM descendant_areas INTO best_fit_areas; where descendant_areas is a temporary table with no indexes containing nine records. Shape is of type geography. Versions: PostgreSQL=PostgreSQL 9.5.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.2 20140120 (Red Hat 4.8.2-16), 64-bit PostGIS=POSTGIS="2.2.2 r14797" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 2.0.2, released 2016/01/26" LIBXML="2.9.1" LIBJSON="0.12" TOPOLOGY RASTER My question is: Is it normal for cancelling a query to take that long or is it indicative that there are config settings set up badly?

pgAdmin's *Register - Server* dialog for adding new database connections asks for a **"Maintenance database"**. In order to be able to connect, I set it to the database I want to connect (and also, I have the rights to connect). So, why is that field named "Maintenance DB" instead of just "DB" or "Database"?

I'm new to PostgreSQL.I'm using postgreSQL locally. I used it last time without any issues. Now, when I try login with my login credentials it shows the account is locked message all the time.

Is there a way to visualize which users are members of a role in PostgreSQL / pgAdminIII, like role: council_stuff members: Harry Ben Steve Melinda

I'm trying to ENABLE remote client access on my PostgreSQL 12 database (Ubuntu 20.04 LTS). I've changed **

.conf

** on both paths ***/var/lib/postgresql/12/main*** and ***/etc/postgresql/12/main*** this way: listen_addresses = '*' Of course also add my ip in **

.conf

** I've also tried: root@localhost:/# sudo -u postgres psql psql (12.20 (Ubuntu 12.20-0ubuntu0.20.04.1)) Type "help" for help. postgres=# ALTER SYSTEM SET LISTEN_ADDRESSES='*'; ALTER SYSTEM And after many restarts (of postgreSQL and even whole vnc) anyway I'm getting this: root@localhost:/# sudo -u postgres psql -c 'SHOW listen_addresses;' listen_addresses ------------------ localhost (1 row) And **pgAdmin 4** on my PC also tell me: > Unable to connect to server: connection timeout expired I even tried to reinstall postgreSQL - no effect 😭 Why so? What is wrong? Colleagues, please give me an advice how to solve this problem? **UPD:** Also tried with inactive firewall - no effect...

Prostgres db is running in docker on a VPS (Ubuntu). docker ps 4f945e0bf0bc postgres "docker-entrypoint.s…" 2 hours ago Up 2 hours 0.0.0.0:5432->5432/tcp, :::5432->5432/tcp postgres-0 From a Windows PC, I want to connect to the database using pgadmin, but it's not successfull : Unable to connect to server: connection timeout expired. In the "Host name/address" field of pgadmin I've entered the IP address of the Ubuntu server. See output of command "ip a" What else do I need to configure so that pgadmin can access the DB ?

I'm trying to install pgAgent on my device. During the installation using the stackbuilder, the last step requires me to add the operating system username and password as below: However, after entering the password of my postgres superuser account, i'm shown the below dialog box: Every resource available online mentions that the username and password should be the superuser's. I've tried using the Windows account details as well as creating a new user within postgres and using its details. Any help would be greatly appreciated. I'm using PostgreQL v13, and pgAgent v4.2.1

I am having trouble accessing the PGAdmin software. I get a fatal error message "The pgAdmin 4 server could not be contacted:"... what do I need to do to fix this?

A have a TEXT column in which the values contain newlines. When I query the column in pgAdmin, I only see the first line of each value. Can I make pgAdmin show multiple lines in a cell?

I don't know how this has happened (I may have changed something in my PostgreSQL / psql settings) but now everytime I open the psql console I get the following error: "WARNING: Console code page (850) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page "Notes for Windows users" for details." I've ran the suggested fixes in this post (psql shell uses code page 850, windows uses 1252. How to solve change console code page?) but none of them have resolved it for me. The official PostgreSQL documentation for the version I'm running (version 16.3) https://www.postgresql.org/docs/16/app-psql.html says to fix this I need to run the 'cmd.exe /c chcp 1252' command (as in the post above), and set the console font to Lucida Console. How do I set the console font? I can't figure it out and I can't find any pages on the internet that provide a suitable answer for my version of Postgres, version 16.3. I'm on Windows 10. I've looked in File > Preferences (in PGAdmin) but I can't find a setting for fonts. Can someone help me please? I don't want to have to reinstall Postgres if I can avoid it. I've ran the suggested fixes in this post (psql shell uses code page 850, windows uses 1252. How to solve change console code page?) but none of them have resolved it for me. I've looked in File > Preferences (in PGAdmin) but I can't find a setting for fonts.