Skip to main content

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
0 votes
0 answers
21 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 ...
Ozan Deniz's user avatar
1 vote
0 answers
28 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 ...
HuLu ViCa's user avatar
  • 151
0 votes
0 answers
23 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 ...
krytopes's user avatar
-4 votes
1 answer
73 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
159 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
232 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
190 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
40 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
460 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
1k 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
429 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
697 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
474 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
154 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
1k 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
682 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
654 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
1 vote
0 answers
200 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
930 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
351 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
3 votes
1 answer
23k 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
1k 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
574 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
827 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
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 ...
Cerin's user avatar
  • 1,375
0 votes
0 answers
640 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
626 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
128 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
222 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
37 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
178 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
848 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
6k 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
91 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
459 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
447 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
  • 372
1 vote
0 answers
283 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
  • 175
1 vote
1 answer
8k 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
492 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
15 votes
2 answers
11k 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
  • 151
0 votes
0 answers
627 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
4 votes
4 answers
28k 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
20k 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
113 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
440 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
10 votes
3 answers
45k views

Cannot do a restore using PgAdmin4 after a new install of PostgreSQL - pg_restore.exe file not found

I am new to PostgreSQL. I installed the software. Almost everything works. Then I tried to follow a tutorial for dvdrental. All instructions for using from command line worked. Then there is ...
M. Saleem Yusuf's user avatar