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.
144 questions
0
votes
0
answers
88
views
Unable to connect to server connection failed: connection to server at 127.0,0,1 post 5432 failed could not receive data from server
I installed PgAdmin 4 to my MacBook Pro Sonoma version 14.4.x and once it opened I attempted to create a server or register a server and I have host name/address as localhost, port 5432, maintenance ...
- 281
1
vote
1
answer
750
views
How do you open a *.pgerd file and view the database diagram?
I have a *.pgerd file that I want to open an view the database diagram. What free tools can I use? I also have access to IntellJ Ultimate Edition, so if anyone knows of plugins I can use, this would ...
- 443
0
votes
0
answers
35
views
pgAdmin 4: How can I change the default starting value of sequences?
I don't like sequences starting from 1 while vectors, arrays etc. start from 0. Having sequences start from 0 makes it easier to store the rows in a container easier.
Each time I create a table in ...
1
vote
0
answers
57
views
Ubuntu How to change the username PGAdmin tries to use to login
I uninstalled Postgresql and PGAdmin4 from ubuntu and installed them back but, now, when I open PGAdmin and click on servers/local, it requests for the password of a user no longer exists and there's ...
- 151
0
votes
0
answers
30
views
Groups for local users in pgadmin4 (web server mode)
I have a containerized setup of pgAdmin4 V8.5 in server mode running.
Does anyone know if I can create groups for local users in pgadmin4 in web server mode and set privileges for them?
Basic idea
To ...
- 1
-4
votes
1
answer
97
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
- 1
0
votes
0
answers
274
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 ...
0
votes
1
answer
478
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 = '...
1
vote
0
answers
224
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. ...
- 11
-1
votes
1
answer
41
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 ...
0
votes
1
answer
580
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 ...
- 103
0
votes
0
answers
2k
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 ...
0
votes
2
answers
593
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 ...
- 3
0
votes
1
answer
738
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 ...
- 103
3
votes
0
answers
524
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 ...
- 31
-2
votes
1
answer
165
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
...
0
votes
1
answer
2k
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 ...
- 121
0
votes
0
answers
955
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 ...
- 21
2
votes
0
answers
855
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 ...
- 121
1
vote
0
answers
261
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" ...
- 11
1
vote
1
answer
1k
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 ...
- 376
1
vote
1
answer
430
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?
...
- 115
4
votes
1
answer
25k
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....
2
votes
1
answer
2k
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 ...
0
votes
1
answer
831
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 ...
2
votes
1
answer
976
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 ...
- 125
7
votes
2
answers
7k
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 ...
- 1,385
0
votes
0
answers
725
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 ...
- 101
1
vote
0
answers
684
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 ...
- 111
0
votes
0
answers
136
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/...
- 101
2
votes
0
answers
243
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?
0
votes
0
answers
43
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 ...
- 101
0
votes
1
answer
209
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 ...
0
votes
1
answer
902
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 ...
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 ...
- 674
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
--...
- 111
2
votes
1
answer
7k
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 ...
- 265
1
vote
0
answers
95
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:
...
- 111
3
votes
0
answers
479
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 ...
- 131
0
votes
1
answer
474
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 ...
- 384
1
vote
0
answers
291
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:
...
- 175
1
vote
1
answer
9k
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 ...
- 11
3
votes
0
answers
512
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 ...
- 133
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 ...
- 101
16
votes
2
answers
12k
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 ...
- 161
0
votes
0
answers
678
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 ...
6
votes
5
answers
32k
views
How to fix "your account is locked. please contact admin" error in pgAdmin?
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.
gowtham6672
7
votes
1
answer
21k
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 ...
- 2,201
2
votes
1
answer
122
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'...
- 123
2
votes
0
answers
479
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 ...
