Questions tagged [pgadmin-4]

pgAdmin is an open source management tool for Postgres. pgAdmin 4 is a completely new client, intended to replace the older pgAdmin III.

Filter by
Sorted by
Tagged with
-4 votes
1 answer
58 views

How can i write a sql statement to get customers who have rented at least one film from each category from dvdrental

How can i write a sql statement to get customers who have rented at least one film from each category, to Return customer_id, first_name and last_name. from dvdrental
DonnyE's user avatar
  • 1
0 votes
0 answers
39 views

Pgadmin4: Export/decrypt saved Passwords

Since we are migrating pgadmin from sqlite to a postgres Database, one of my main problems right now is to export the stored servers with their saved passwords. The passwords are encrypted using the ...
DavidMA2412's user avatar
0 votes
0 answers
73 views

Cannot edit data or delete row in table (pgAdmin)

I am new to pgAdmin and i want to delete a row in a table directly inside pgAdmin. ChatGPT tells me I should be able to do this, either by a query DELETE FROM table_name WHERE column_name = '...
Maja Thuren Jørgensen's user avatar
1 vote
0 answers
126 views

Can not enter a new master password in pgadmin4 v5.7

I am working with two versions of pgAdmin4, v5.7 and v7.4. With v7.4 I don´t have any trouble with connecting to my local or remote servers, however with v5.7 I have encountered problem with logging. ...
odGnol's user avatar
  • 11
-1 votes
1 answer
35 views

What are existing tables on a new PostegreSQL 15.1 installation?

I've just installed PostegreSql 15.1 Previous I installed and uninstalled it several times After this last installation, if I try via PgAdmin to see "default" PostegreSql tables, the list is ...
Marcello D'Ambrosio's user avatar
0 votes
1 answer
248 views

Connecting to AWS RDS succeeds via terminal but fails in pgAdmin 4. Why?

I can establish an SSH tunnel using ssh -L 2222:<RDS-Endpoint>:5432 ec2-user@<EC2-IP> -i ~/.ssh/key.pem and then connect to my RDS using psql "host=localhost port=2222 user=postgres ...
Frikster's user avatar
  • 103
0 votes
0 answers
828 views

PostgreSQL Server Timeout Issue with pgAdmin, pgAdmin Web, and DBeaver

I am using PostgreSQL 15.4 on Ubuntu 22.04. Initially, I used pgAdmin 4 for managing the database. However, I've been facing an issue where pgAdmin stops responding after some time. This issue seems ...
Purushottam Nawale's user avatar
0 votes
2 answers
172 views

PostgresDB - Updating a Table from a different Server

I have a Database on a server (external) that has multiple tables that I have a connection to. I have created a select query that does various joins and that gives me the desired final view of this ...
DataVick's user avatar
0 votes
1 answer
599 views

Error when trying to view data in PGAdmin4, PostgreSQL10, on Ubuntu 22.04

I've installed PGadmin4 on my Ubuntu 22.04 system, with this repository : https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main PGAdmin4 runs, but if I want to see ...
V Damoy's user avatar
  • 103
1 vote
0 answers
383 views

Unable to Install PostGIS Extension for PostgreSQL 15 on Mac Book with M1 Chip and macOS Ventura 13.3.1

Issue: Unable to install PostGIS extension for PostgreSQL 15 on Mac Book with M1 chip and macOS Ventura 13.3.1. Steps I have taken: Installed PostgreSQL 15 using the terminal. Installed PostGIS using ...
Ravers UA's user avatar
-2 votes
1 answer
118 views

Problem :simple query takes too long to complete (over 7 minutes) [closed]

CREATE OR REPLACE FUNCTION public.fn_question_3_3() RETURNS TABLE(name character varying, surname character varying, person_t person_type) AS $$ DECLARE pt person_type; BEGIN RETURN QUERY ...
DilligentSlacker's user avatar
0 votes
1 answer
641 views

How to change query tool font and colors in PgAdmin 4?

In PgAdmin III, it is possible to change the font and colors for the query tool editor window in the options menu: I can't find any similar settings in the preferences window for PgAdmin 4. How and ...
Joe M's user avatar
  • 121
0 votes
0 answers
14 views

Is it possible to change data in 'select' request which contains join comands in pgadmin?

When I'm getting data from a table, pgadmin tools allow me to edit, add and delete data. However, if join command is added to the request, these pgadmin tools become unavailable. Is there any way to ...
Eugene's user avatar
  • 1
0 votes
0 answers
22 views

pgAmin 4 Process Watcher filepath/filename not in plain text

I did some dump and restore processes and would really like to retrace which dump files I used to do that, but the process watcher windows would just say "....\BA54DF~1.SQL", that doesn't ...
planteater's user avatar
0 votes
0 answers
434 views

How to copy many tables from one database to another database using pgAdmin4 on PostgreSQL

I just created a new database. I want to bring existing Tables from old Database to the new one for database clean up purpose. I am looking for a short cut than doing it manually. I'm using pgAdmin4 ...
TmzGOAT's user avatar
  • 21
2 votes
0 answers
450 views

How do I change the timezone of pgadmin?

I have PGAdmin hosted in server mode (container) on my server. In the "server activity" section, the time is being displayed in UTC. How do I make PGAdmin display time in my local time? I ...
berinaniesh's user avatar
0 votes
0 answers
241 views

Drop server pgadmin4

I've just updated to macOS monterey operating system and I haven't used pgadmin since a while on macOS. I look for a method to drop this postgresql9.5 server from my list, I've dropped this server but ...
FranckT's user avatar
  • 17
1 vote
0 answers
175 views

pgadmin 6.20 running in docker on ubuntu, problem with binaries path

I've spent some hours googling and messing around with this but can't figure it out. Running pgadmin 6.20 in docker on Ubuntu 22.04 VM. Postgres installed on same VM, but "bare metal" ...
mvern's user avatar
  • 11
1 vote
1 answer
674 views

pgAdmin4 connects to all databases

When I connect to a server with pgAdmin4 v6.20 and check the connections to the server, I see pgAdmin4 having a connection each to all databases of the server. This makes problems when I want to ...
Daniel's user avatar
  • 368
1 vote
1 answer
260 views

In pgAdmin, when creating a new connection why is the password field for SSH tunnel greyed out?

I'm registering a new server in pgAdmin desktop client for Windows. In the SSH Tunnel tab, the "Save password?" field is greyed out, even when I've filled in all of the fields. Why is this? ...
Kit Johnson's user avatar
0 votes
0 answers
759 views

How to connect PgAdmin4 to postgresql 9.5 database process running on AWS EC2 server

I have a postgres database running on a linux EC2 instance. I want to view the data inside the tables, and currently the only way I can do that is via command line on the host server by: sudo su ...
jabroni's user avatar
2 votes
1 answer
18k views

PostgreSQL FATAL: no pg_hba.conf entry for host "[ipv6]", user "[user]", database "postgres", no encryption

Unable to connect to a postgreSQL database on a LAN. (No problems connecting to the db on the server locally) Error shown in pgAdmin.app: Unable to connect to server: connection to server at "xxx....
WhatsYourFunction's user avatar
2 votes
1 answer
857 views

View the saved passwords in PgAdmin4 for MAC OS

I know the master password of the pgAdmin4. I am able to login to pgAdmin and then login to the database as well using the saved server password. But I did not find any option to view the saved ...
firstpostcommenter's user avatar
0 votes
1 answer
376 views

PG Admin Sessions

I have a frontend written in MS Access that connects to a Postgres backend through ODBC. Sometimes the number of sessions reaches 100 and at that point I get an "ODBC call failed" error. I ...
Christos Arapidis's user avatar
2 votes
1 answer
668 views

How can I browse catalog objects using pgAdmin-4

I'm connected via pgAdmin-4 to a new empty database running locally in a docker image. I can run queries such as the following: select * from pg_tables; select * from pg_user; Is there a way for me ...
crowne's user avatar
  • 125
7 votes
2 answers
5k views

How to turn off autocomplete in PgAdmin4?

How do you turn off the autocomplete/help-tips in PgAdmin4? They're driving me insane. Every cursor movement and keypress causes a "Loading..." overlay to appear, which either displays ...
Cerin's user avatar
  • 1,345
0 votes
0 answers
542 views

How can I keep the connecton to the database alive in pgAdmin 4?

I am constantly seeing this message: ERROR: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. server closed ...
Rokit's user avatar
  • 101
1 vote
0 answers
544 views

Avoid pgAdmin4 timeout that prevents disconnect

Connecting to PostgreSQL servers through pgAdmin4 will time out after some short period of time (2-5 min). When this happens I cannot reset the connection or disconnect from the server. The interface ...
Conor's user avatar
  • 111
0 votes
0 answers
101 views

Cannot launch pgadmin4

I have just installed pgadmin4-desktop on Fedora36. Can anyone provide some suggestions? It was working fine a couple of days ago but now I cannot launch it via Gnome or the command line. $ pwd /usr/...
Bryon's user avatar
  • 101
2 votes
0 answers
197 views

Does pgAdmin4 allow session recovery?

I'm used to HeidiSQL, where your tabs and their states are always remembered and come back when you reopen the program. Can pgAdmin4 automatically reopen the tabs used in its last run?
Federico Matonte's user avatar
0 votes
0 answers
33 views

Postgres execute requests isolatedly

Users submit schema and query. I need to execute them and return the result. But if multiple requests have the same table in the schema mentioned, then I am getting conflicts (which is as expected). I ...
Forece85's user avatar
  • 101
0 votes
1 answer
157 views

pgAdmin4 won't let me drag select in the results grid

I recently upgraded to the latest pgAdmin 4 (version 6.9), and to my surprise, drag-selecting in the results grid doesn't work (it's just not selecting anything). I can move the active cell around ...
Primordial_Hamster's user avatar
0 votes
1 answer
740 views

How to organize postgresql databases in pgadmin4?

I'm working with postgresql on my local machine with Windows 10, in pgadmin4 I can create new Server Groups and new Servers, if I create 2 new server groups and select localhost for the host, I get ...
DumbMathBoy's user avatar
0 votes
1 answer
2k views

Disable web login in pgAdmin 4

Working in a home LAN, no one else is able to reach this development instance. Still, pgAdmin 4 forces a login through its web interface, which is different from the credentials used to login to the ...
Luís de Sousa's user avatar
1 vote
0 answers
1k views

pgAdmin4-desktop: The pgAdmin 4 server could not be contacted:

'm working here with Linux Mint 19.1 Cinnamon. I just installed pgAdmin4-desktop, but when I try to run it I get this error: The pgAdmin 4 server could not be contacted:. pgAdmin Runtime Environment --...
Andre's user avatar
  • 111
2 votes
1 answer
4k views

Why do I see the timezone offset displayed in PgAdmin, for a timestamp with timezone

I'm using PgAdmin 4 v6, and for some timestamp data with data type of timestamp with time zone, I'm seeing it in PgAdmin like this: 2022-03-06 16:11:33+04 Why is the +04 being displayed? I've looked ...
Chris Halcrow's user avatar
1 vote
0 answers
87 views

How to close connection after doing a "View/Edit" of a table

In pgAdmin 4, after I right-click on a table and choose "View/Edit data", I cannot figure out how to close that new connection. If I try to "Delete/Drop" the database, it says: ...
John Pankowicz's user avatar
3 votes
0 answers
429 views

postgres beginner: pgadmin4 object browser keeps disappearing randomly

For training purposes, I started to create my first postgres database with pgadmin-4 on a windows 10 parallels desktop. During the first days, everything worked as expected. Today, I keep having ...
LGe's user avatar
  • 131
0 votes
1 answer
411 views

pgpass entries for multiple SSH tunnels with randomly assigned local ports using the same credentials but different passwords

Let's say I have 4 SSH tunnels to different remote servers, each having different PostgreSQL databases up and running. Each tunnel is mapped to a specific port on my local machine (localhost) as ...
s.k's user avatar
  • 342
1 vote
0 answers
268 views

How do I copy a table from one database to another? Dump files come out empty

I am trying to "dump" a table to a file, copy that file to a different host and restore the table on a database. My (first) problem is that I cannot dump the table data. I use this command: ...
birgersp's user avatar
  • 163
1 vote
1 answer
7k views

Import large .sql file to pgAdmin4

I have been trying to import a .sql file to my pgAdmin 4 since 2 hours now. I have a Windows and PostgreSQL 14. I realized I approached correctly since I was able to import a small (2KB) file (through ...
josh's user avatar
  • 11
3 votes
0 answers
470 views

How to open pgAdmin 4 v6.0 in browser instead of running as a desktop app

It looks like PgAdmin 4 v5.4+ (I have v6) works as a standalone desktop app and the option to open in a browser window is not there by default. I am using macOS Big Sur. How can I open PgAdmin UI in ...
Eranga Heshan's user avatar
0 votes
0 answers
3k views

Setting binary path in pgAdmin

I am trying to import data for a table from a csv file. Whenever I click on "Import.." after right clicking on the table, I get the following error message: " Please configure the ...
Mayur Ekbote's user avatar
14 votes
2 answers
9k views

What does it mean when a session is highlighted in red in the PgAdmin dashboard?

I've noticed sessions being highlighted in red recently though this never occurred in the past which leads me to believe it is a new feature. It appears to only occur on hanging queries. I looked ...
joepcash's user avatar
  • 141
0 votes
0 answers
526 views

pgAdmin4 Doesn't Start After PostgreSQL Config

I tweaked the hba_conf file to use username and password authentication rather than ident on local and ipv4 local connections and then I noticed that pgAdmin doesn't start up at all. I'm not sure if I ...
StackMatch's user avatar
3 votes
4 answers
24k views

how to fix "your account is locked. please contact admin" issue in postgresql when login

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.
user avatar
7 votes
1 answer
18k views

How can I change the master password of pgAdmin 4 without resetting it?

pgAdmin 4 has a master password which is required to secure and later unlock the saved server passwords. This is applicable only for desktop mode users. I know my current master password, however, I ...
Glorfindel's user avatar
  • 2,201
2 votes
1 answer
105 views

In PgAdmin, what does `[...]` refer to in a result set?

Sometimes my query results include a cell containing the pattern [...]. When I export such results, they render as a blank string. However, when I try to filter on them with where column_b = '', there'...
data princess's user avatar
2 votes
0 answers
357 views

pgAdmin 4 - Can't do anything after connection lost

I'm using pgAdmin 4.5 on Windows 10. When I connect to a database, things going well. Then after some idle time, pgAdmin says "The connection is lost", then refuse to do anything, including ...
Romulus Urakagi Ts'ai's user avatar
1 vote
0 answers
2k views

How do I run pgadmin in a web browser by default?

I'm running pgadmin 5.4 on macOS Big Sur. When I open the application, pgadmin launches in Desktop Mode, as a standalone app. My goal is to force pgadmin to run within a browser instead, but I'm ...
Chris Perry's user avatar