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
-1
votes
0answers
7 views

Which web-based viewer for Postgres allows to wrap text in a cell?

Out of several web-based viewers for Postgres, I have tried pgadmin4. However, one thing that I find severely lacking is I didn't find a way to wrap text in a cell containing a long string. If I ...
0
votes
0answers
18 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 ...
0
votes
0answers
4 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 ...
1
vote
3answers
5k 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 ...
0
votes
1answer
35 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 ...
1
vote
0answers
15 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 ...
0
votes
1answer
34 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 ...
0
votes
1answer
83 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 ...
0
votes
1answer
161 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
0answers
26 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:...
0
votes
1answer
23 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 ...
0
votes
0answers
234 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 ...
0
votes
1answer
34 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 ?
0
votes
0answers
26 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? ...
0
votes
0answers
379 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 ...
0
votes
0answers
33 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 ...
0
votes
0answers
71 views

Pgadmin4 : unable to login.Getting error failed to create ssh tunnel

I am using CentOs7, On the command line I login to the unix server via ssh (sshpass -p $PASS ssh linux_user@linux_box_ip ;;) and then give the below command after logging to the linux box. $ psql -h &...
0
votes
0answers
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" ...
6
votes
1answer
700 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 ...
1
vote
1answer
27 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 ...
0
votes
0answers
51 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 ...
0
votes
0answers
21 views

PgAdmin4 shows instances of PostgreSQL 12.4 and PostgreSQL 10 with databases but no v10 artifacts exist on disk for v10 instance

I've installed EDB PostgreSQL v12.4 with the EDB MAC installer/de-installer on my MAC PRO Mojave server as I have done many times before. However, I recently installed PostgreSQL ver 12.4 to support ...
0
votes
1answer
82 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 ...
0
votes
2answers
47 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 ...
1
vote
0answers
342 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 ...
1
vote
1answer
26 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 &...
1
vote
1answer
258 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 ?
1
vote
0answers
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 ...
1
vote
0answers
143 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 ...
0
votes
2answers
199 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 ...
0
votes
1answer
21 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 ...
0
votes
0answers
624 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 ...
1
vote
0answers
355 views

Is it possible to change the browser that pgadmin4 uses?

I have Debian 10, pgadmin4, and KDE. When I open pgadmin4, it opens with Firefox. I have several other browsers installed. If I try to paste the link in any other browser, I get this error message: ...
0
votes
2answers
425 views

Connect to a local PostgreSQL server using peer auth with pgAdmin

Context I have a PostgreSQL server running on a remote machine, but I'm connected locally through VPN. Its pg_hba.conf file is accepting peer auth for local connections; local all ...
0
votes
1answer
402 views

How to create a database or role in pgAdmin4?

I want to create a database in pgAdmin4 but a corresponding item in the menu is grayed out. I also tried to create a role, thinking that I might be lacking permissions to create database in first ...
3
votes
2answers
4k views

pgadmin dashboard is gone

The Dashboard option is gone from the menu. Now I can't see the nice graphs anymore. What do I need to get it back I'm using version 4.17?
0
votes
0answers
1k views

Databases in psql Don't Show up in PgAdmin4

I'm using Ubuntu 18. I have PostgreSQL 11 and PgAdmin4 and I connect to PgAdmin4 from my browser by typing localhost/pgadmin4/. Recently, I found that the url doesn't work and internal server error ...
1
vote
0answers
47 views

Can't reach my servers on pgAdmin4

I have an issue on pgAdmin 4.14: I can't open the servers anymore. Whenever I open it I have this never-ending wheel. Furthermore, I have this weird pop-up that I can't close. I was able to reach my ...
1
vote
2answers
651 views

DBEaver Vs PG Admin

When I ran a query in Postgres database using the Pg Admin tool it took only 2 SECS ( I can see the parallel workers being used in the plan) but when I ran the same query in DBeaver, it took around 3 ...
1
vote
1answer
43 views

Adding condition (Similarity) causes sequence scan

Struggling with this one a little bit, as I would have expected the performance to be better combining the queries that separated. The queries are produced using Django ORM 1.11. With the ...
0
votes
2answers
199 views

How to automate the detection of the column type of a csv file for a table creation script?

I am new to pgAdmin and Azure database. I have a huge csv file with around 220 columns and I want to create a table out of it in pgAdmin4 to push it to Azure. However I don't know how to detect ...
0
votes
2answers
4k views

Edit pg_hba.conf file using pgAdmin 4

This other Question has Answers about viewing and editing settings in postgresql.conf file using pgAdmin 4. But those Answers did not mention editing the pg_hba.conf file used for authentication of ...
2
votes
1answer
1k views

PgAdmin 4.14 connection error in cloudSQL : could not send data to server, socket is not connected, could not send ssl negotiation packet

I am trying to connect cloud sql with pgadmin but it throws error when I try to execute query. "Could not send Data to server, socket is not connected, could not sent SSL negotiation pocket" ...
0
votes
1answer
2k views

pgAdmin IV and PostgreSQL 12.0: ERROR: schema “public” already exists

I have a database backup from pgAdmin III with PostgreSQL 12.0 (Ubuntu 12.0-2.pgdg16.04+1) on Ubuntu 16.04 LTS. I would like to restore this database on my pgAdmin IV with PostgreSQL 12.0 on Docker ...
1
vote
0answers
166 views

Problems with creating new local server

I have a problem with creating a new server in PgAdmin 4. I have server with the port 5432 as standard. Now I am trying to create a new server with port 5433. When I try to create the server I get the ...
5
votes
2answers
2k views

Unable to output data from tables in pgAdmin4 due to missing oid operator

I am currently running Postgresql 10.6 locally which I interface with using PgAdmin 4.12, up until today everything was running fine. However today I ran the following query in the pgAdmin query ...
2
votes
1answer
4k views

pgAdmin4 or pgAdmin3? [closed]

I've seen a lot of hate directed to pgAdmin4, but honestly I can't see why. It worked out of the box from a docker image, connected right away to the database and perfectly managed every maintenance ...
0
votes
2answers
736 views

pgadmin: can't insert jsonb[] values with strings

I have jsonb[] column and it allows me to insert some nested arrays, but only with number values like {{1,2,3}, {4,5,6}, {7,8,9}}. I'm not talking about inserting some nested objects like {{"one": "...
0
votes
2answers
844 views

How to hide the partition child tables in PostgreSQL?

I am creating partition tables in postgreSQL. And the partition is on date column so its nearly high in number to show in schema. I want to show only my parent table for other users. I tried many ...
0
votes
0answers
77 views

Query to reduce column length

I'm new to PostgreSQL so sorry if I haven't explained myself clearly! I've used the below query to find out the max character length of each column in my table. I now want to be able to shorten each ...