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
1answer
14 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
30 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
8 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
26 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
26 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
87 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
19 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
19 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
105 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
33 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
14 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
145 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
25 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
36 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
12 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" ...
5
votes
1answer
489 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
21 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
19 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
0answers
61 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
35 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
287 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
22 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 &...
0
votes
1answer
149 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
2k 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
103 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
161 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
587 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 ...
0
votes
0answers
74 views

How can you see PostgreSQL procedures in Azure Data Studio?

If I use pgAdmin 4 to query PostgreSQL, I can see procedures section under materialized views. But, If I use Azure Data Studio I cannot see the procedures section. Any idea how to get to see the ...
0
votes
0answers
12 views

Losing connection to the server when using PG Routing function pgr_alphaShapes

I am running PG Routing v. 3.0 on Postgresql 12.2 and the pgr_alphaShapes function is giving me a lot of trouble. Following the documentation here, I passed a geometry and a spoon radius. SELECT * ...
1
vote
0answers
318 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
337 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
285 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
3k 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
46 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
592 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
42 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
152 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
3k 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
130 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
3k 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
614 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
724 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
71 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 ...
1
vote
0answers
87 views

Remove white box overlaying PGAdmin [closed]

I'm using PGAdmin4, and ever since updating to version 4.10 I've had a random white box on the screen. I've discovered that I can minimise this box, but there doesn't seem to be any way to close it. ...