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
1 answer
15 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 ...
user avatar
0 votes
0 answers
11 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 ...
user avatar
0 votes
1 answer
22 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 ...
user avatar
0 votes
1 answer
19 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 ...
user avatar
0 votes
0 answers
29 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 ...
user avatar
0 votes
0 answers
88 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 --...
user avatar
  • 101
0 votes
1 answer
73 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 ...
user avatar
1 vote
0 answers
18 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: ...
user avatar
1 vote
0 answers
48 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 ...
user avatar
0 votes
1 answer
31 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 ...
user avatar
  • 216
1 vote
0 answers
39 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: ...
user avatar
  • 113
0 votes
1 answer
615 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 ...
user avatar
  • 1
0 votes
0 answers
37 views

pgadmin column sorting

I recently installed pgadmin 4.6.1 and I noticed that columns are sorted alphabetcally by name. Sometimes this can be annoying. Does anybody know if it possible to change this behaviour?
user avatar
2 votes
0 answers
149 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 ...
user avatar
0 votes
0 answers
921 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 ...
user avatar
4 votes
1 answer
2k 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 ...
user avatar
0 votes
0 answers
110 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 ...
user avatar
2 votes
2 answers
4k 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
3 votes
1 answer
4k 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 ...
user avatar
  • 2,117
2 votes
1 answer
42 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'...
user avatar
2 votes
0 answers
61 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 ...
user avatar
1 vote
0 answers
672 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 ...
user avatar
0 votes
0 answers
19 views

Nothing happens after backup job is created

I'm running postgreSQL 9.6/Pgadmin4 on a macOS and I'm trying to backup a database in pgadmin4 by : Right click on the DB Backup Once the backup job is created nothing happens afterwards and the ...
user avatar
8 votes
3 answers
17k 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 ...
user avatar
0 votes
1 answer
114 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 ...
user avatar
2 votes
1 answer
190 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 ...
user avatar
  • 121
0 votes
1 answer
113 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 ...
user avatar
  • 1
1 vote
1 answer
641 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 ...
user avatar
  • 233
0 votes
2 answers
929 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 ...
user avatar
0 votes
0 answers
203 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:...
user avatar
  • 216
0 votes
1 answer
33 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 ...
user avatar
  • 103
0 votes
0 answers
1k 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 ...
user avatar
0 votes
1 answer
36 views

How to find givien index by name in PostgreSQL

I know how to find index by name in MS SQL Server just by search for %name% But where I can do the same in PGAdmin4 ?
user avatar
0 votes
0 answers
88 views

How to change the Postgres hostname in pgadmin 4? [duplicate]

By default, the database hostname is localhost after the Postgres has been installed. Can the hostname be changed to something else like localhost\\abc? If yes, how can I do it in Windows/pgadmin? ...
user avatar
  • 117
0 votes
0 answers
1k views

Set up SSH tunnel with PgAdmin 4

I am new to pgAdmin and to SSH tunnels. I am trying to establish a connection to a postgres DB with SSH tunnel. I am on Windows 10. I am given the following instructions (I changed all the names and ...
user avatar
0 votes
0 answers
118 views

Mass Paste Data into Column in pgAdmin4

Using pgAdmin4. I have live client data in columns in my db- the identifying information is first name and last name. I want to replace that with randomly generated names for demo purposes. How can I ...
user avatar
  • 23
0 votes
0 answers
15 views

How do I enable pgadmin4 (PostgreSQL12) to read and write files in directories of other Linux Users on RHEL8/CentOS8 [duplicate]

While trying to export a query result set from PGAdmin4 on PostgreSQL12 to a CSV I am encountering the following error: ERROR: could not open file "/home/linuxusername/Downloads/data.csv" ...
user avatar
8 votes
1 answer
2k views

PgAdmin 4 - How to connect to database using unix socket via ssh tunnel?

Even though it might sound related to this question, it isn't, because I'm intreseted in the use of unix sockets instead of TCP/IP ones. However, I am unable to connect to a remote PostgreSQL database ...
user avatar
  • 83
1 vote
1 answer
36 views

Is the "comments" field in pgAdmin 4 a pgAdmin thing, or is it a PostgreSQL feature?

If I right-click a table (or any object) in pgAdmin 4 and select "Properties", it brings up a GUI window which allows me to change the name of the table and many other things. One of the ...
user avatar
1 vote
1 answer
196 views

Error: Not run migration 1604169742656_add-users-table is preceding already run migration 1604024614269_table-comments

I was trying to run a migration file to create a table of users but I kept getting the following error: Error: Not run migration 1604169742656_add-users-table is preceding already run migration ...
user avatar
  • 261
0 votes
1 answer
130 views

Is there a native(none-web) GUI client of pgadmin4?

I don't like web-based GUI, so I only installed the pgadmin4-desktop package for my Kubuntu 20.04, instead of pgadmin4-web and pgadmin4. According to the offical web page of pgAdmin4, A desktop ...
user avatar
  • 157
0 votes
2 answers
175 views

Error querying postgresql table created in pgAdmin

I have successfully created a table in pgAdmin which generated the code: CREATE TABLE public."Test3" ( "PID" integer, "Name" character varying(20), PRIMARY ...
user avatar
  • 115
1 vote
0 answers
426 views

pgAdmin 4, force "The application has lost the database connection:"

Whenever I put my computer in sleep mode pgAdmin 4 loses the connection to the remote Postgresql database (and that's fine). When I start up the computer again I have two options. Either restart ...
user avatar
  • 111
1 vote
1 answer
58 views

Administrator can't view tables ("server refused to connect")

I'm quite experienced with MSSQL and MySQL/MariaDB, but I'm a newbie re PostgreSQL. I got everything to work, except for the odd detail that the admin user which I set up during installation can't &...
user avatar
1 vote
1 answer
2k views

How to take backup of schema postgresql?

Hi I am currently using postgresql and deleting some of the tables for testing purpose and I want to take backup of schema. can any one let me know how to do that ?
user avatar
1 vote
0 answers
3k views

Persistent problems importing CSV files via pgAdmin 4 to PostgreSQL 12 on Mac OS - Failing with Exit Code -6

I've been trying for several days to import CSV files into a PostgreSQL 12 database hosted on Mac OS 10.15.5, using the Import/Export tool in pgAdmin 4. I am consistently getting an error message ...
user avatar
1 vote
0 answers
356 views

pgAdmin 4 restore ignores "Clean before restore"

I am using pgadmin v4.22 to backup and restore a database. This works fine the first time, but when I want to restore it again to a backup with deleting the old data, pgAdmin seems to ignore the Clean ...
user avatar
  • 111
0 votes
2 answers
382 views

A Remote GUI for PostgreSQL [closed]

I've installed PostgreSQL 12 server onto an Ubuntu 20.04 server, but I want to access it using a GUI from my Kubuntu 20.04 laptop. I'd be interested to know any options for GUI administration. I have ...
user avatar
0 votes
1 answer
25 views

Why do I have 2 connections when im using 1 client?

The command: select * from pg_stat_activity shows all currently active connections. The database is hosted by AWS RDS and I am accessing the database with pgAdmin 4, thus I expect one other ...
user avatar
0 votes
0 answers
719 views

AutoFK index disabled during foreign key creation in pgadmin

Trying to create a foreign key, but doesn't allow me to save the changes as it shows the error "Please specify covering index name." Cant specify the covering index unless i toggle the auto fk index ...
user avatar
  • 1