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
34
views
pgAdmin4 Web - Query Tool Frozen/Blank
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",...
- 101
0
votes
1
answer
71
views
How do you add server connections on ubuntu version of pgAdmin?
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 ...
- 288
0
votes
1
answer
166
views
Is it possible to use PgAdmin 4 over SSH tunnel and 'sudo su - postgres'?
I want to use GUI, e.g., PgAdmin 4, on a PotsgreSQL on Red Hat Enterprise Linux 9, and my Linux username has SUDO permissions.
With command line, I will login through SSH, and call sudo su - postgres, ...
- 57
0
votes
0
answers
237
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
3k
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 ...
- 463
0
votes
0
answers
82
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
95
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
46
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
135
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
1
answer
1k
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
260
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
55
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
698
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
855
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