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.
136
questions
0
votes
0
answers
8
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 ...
0
votes
0
answers
25
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 ...
- 23
2
votes
0
answers
19
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 ...
- 21
0
votes
0
answers
12
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 ...
- 17
1
vote
0
answers
11
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
35
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 ...
- 368
0
votes
0
answers
38
views
somthing wrong when using PgAdmin connect a remote server
I want to connect a remote server which a site db is running on it, the IT manager gave me the databasename,databaseuser,password,IP address.I fill the blank by fllowing the Pgadmin tutorial.
But ...
- 1
1
vote
0
answers
54
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?
...
- 111
0
votes
0
answers
194
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 ...
- 1
0
votes
1
answer
836
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....
0
votes
0
answers
12
views
Hide or group functions in pgAdmin4?
If you have lots of installed functions in your database, browsing for functions you wrote yourself can be tedious. For example, in image below there are a ton of _int_ functions you have to scroll ...
- 111
0
votes
0
answers
154
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
56
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 ...
1
vote
1
answer
164
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 ...
- 115
5
votes
2
answers
3k
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,176
0
votes
0
answers
230
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
191
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
25
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
0
votes
0
answers
63
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
25
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
49
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
0
answers
47
views
pgAdmin - how to show only non-empty nodes/categories/groups?
In the IntelliJ Idea's Database View, you can hide all the empty categories/nodes/groups by unchecking the Show Empty Groups switch.
In the following example, in my database the only existing objects ...
- 101
0
votes
1
answer
369
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
763
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 ...
- 571
0
votes
0
answers
343
views
Scheduling a pgagent job for every alternate friday
I am unable to find a way to schedule a pgagent job for every alternate Friday. Can anybody help me with that?
Below is the code for the shell script that I include in pgagent job:
#!/bin/bash
#backup ...
1
vote
0
answers
921
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
0
votes
1
answer
2k
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 ...
- 245
1
vote
0
answers
74
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
2
votes
0
answers
247
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 ...
- 121
0
votes
1
answer
195
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 ...
- 300
1
vote
0
answers
200
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:
...
- 123
1
vote
1
answer
3k
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
2
votes
0
answers
257
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 ...
- 113
0
votes
0
answers
2k
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
10
votes
2
answers
5k
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 ...
- 101
0
votes
0
answers
260
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 ...
3
votes
3
answers
13k
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.
gowtham6672
7
votes
1
answer
10k
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,171
2
votes
1
answer
65
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
183
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 ...
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 ...
- 111
8
votes
3
answers
29k
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 ...
- 121
0
votes
1
answer
315
views
Why does querying a PostgreSQL database have an overhead of a few dozens of milliseconds?
Everything is in the same place, same local computer.
Whenever my Go application as well as pgAdmin 4 queries the PostgreSQL database, it takes at least a few dozens of milliseconds, however short the ...
- 101
3
votes
1
answer
458
views
How to get rid of PGAdmin 'Notifications' panel
I pushed some key combination by mistake that made this panel pop up:
Now I can't find how to make it disappear. The solution is not evident at all, and it is really bothering because it covers a big ...
- 131
0
votes
1
answer
322
views
Determining primary key columns in PGAdmin, if the constraint name is generated by system
I am trying to learn a new schema of a PostgreSQL database, but it's unclear from looking at pgAdmin which columns per the tables constitute the primary keys. It appears that when the tables were ...
- 101
1
vote
1
answer
1k
views
Equivalent of PGAdmin III Server Status Activity Window in PGAdmin 4 v5
I'm in the process of upgrading to Postgres 13.2 from a much older version. This entails an upgrade from PGAdmin III to PGAdmin 4.
PGAdmin III has a brilliantly designed feature called Server Status ...
- 233
0
votes
2
answers
1k
views
SQLAlchemy: table version already exists. pgAdmin4 fails on Linux Mint 20 and 20.1
I already found the solution, I just want to share it in case someone has the same problem.
Situation
Install pgAdmin4 version 4.30 on Linux Mint 20 (Ulyana) and Linux Mint 20.1 (Ulyssa) inside ...
0
votes
0
answers
310
views
Understanding how to set up the port value in pgadmin4 docker from the GUI and in the servers.json config file when using an SSH tunnel
This is extraordinary tricky but I just discovered that, when you first open an SSH tunnel manually in bash (and somehow, I hope that I'm wrong somewhere...);
user@localhost:~$ ssh -N -f -L 2345:...
- 300
0
votes
1
answer
63
views
SQL query: insert values into polygon where features of the polygon intersects another polygon [closed]
I'm very new to sql so I apologize in advance for my very dummy question...
I'm looking for a way to insert into a table A some values stored in another table B only for the features of table A that ...
- 103
0
votes
0
answers
2k
views
Failed (exit code: 1) when trying to restore DB from a .tar file in pgAdmin4
I'm been trying to restore my database and I'm getting an Exit error code 1. The database I'm trying to restore is SuperMart_DB.tar, but every time I get the same error message.
I have seen previous ...
