Stack Overflow
Stack Overflow

Questions tagged [pgadmin-4]

pgAdmin 4 is an Open Source administration and development GUI for PostgreSQL.

pgAdmin 4 is a complete rewrite of pgAdmin 3.

pgAdmin4 is cross platform (i.e., Linux, FreeBSD, Solaris, macOS and Windows) and supports PostgreSQL v9.2 and above.

It is available as separate download https://www.pgadmin.org/, but also included in PostgreSQL https://www.postgresql.org/.

1180 questions
7
votes
5 answers

Can't connect to postgres when using docker-compose

I am new to docker and still learning how to use it, I am trying to use docker-compose to run Django and Postgres together and they run perfectly and the migrate done and everything, but i have a problem i cant connect into the database using…
Snowflake
  • 191
  • 1
  • 2
  • 13
7
votes
2 answers

Docker Pgadmin 4

EDIT Turned out to a problem with the image, I tried another one and it works fine I'm trying to run Pgadmin 4 as server mode using Docker on Debian 9. I have followed the instructions on https://hub.docker.com/r/dpage/pgadmin4/ I start it by the…
Arya
  • 8,473
  • 27
  • 105
  • 175
7
votes
2 answers

pgAdmin4 import/export option greyed out

so I recently configured and started using Pgadmin 4, managed to set up my localhost database, and my querys work properly, but for some reason I can't use the import/export dialog when I want to export my data as CSV, as it shows as greyed out.…
Omaruchan
  • 403
  • 1
  • 5
  • 12
7
votes
4 answers

Can't execute pgAdmin4

I installed Postgres9.6 ver And pgAdmin4 was installed together. But It is return message "The application server could not be contacted" When i execute pgadmin. I tried to download and install pgAdmin4 from web. But have not changed anything. I…
Gs.
  • 540
  • 1
  • 3
  • 21
7
votes
5 answers

Import shape file into postgis?

I can find multiple tutorials that show how to import shapefiles to postgis via pgAdmin-3. But pgAdmin-3 is no longer supported. How to do this with pgAdmin-4?
Henrik K
  • 157
  • 1
  • 1
  • 6
6
votes
6 answers

installing pgadmin4-web on ubuntu desktop 22.04

I have followed this tutorial for installing pgadmin4-web: pgAdmin 4 (APT) . When I run the following command sudo /usr/pgadmin4/bin/setup-web.sh I get the following error: Setting up pgAdmin 4 in web mode on a Debian based platform……
Byron2017
  • 871
  • 2
  • 11
  • 23
6
votes
4 answers

How to setup PostgreSQL Binary path for PostgreSQL 14

I am reading up on this tutorial: PostgreSQL: https://dba.stackexchange.com/questions/149169/binary-path-in-the-pgadmin-preferences To setup PostgreSQL Binary path, I looked at my Preferences on PgAdmin and I see all versions of PostgreSQL to update…
truthsayer
  • 397
  • 2
  • 8
  • 22
6
votes
4 answers

pgAdmin and terminal: FATAL: password authentication failed for user

sup guys! I'm trying to create a server local in pdAdmin 4, but everytime i'm trying to create i get this error: [Error in pgAdmin] in case 'veterano' its my username... my tries to make this run (but doesnt work) Checking if Postgres Service is…
Jesse Marques
  • 73
  • 1
  • 1
  • 4
6
votes
8 answers

Where is the pgpass file in pgadmin4 docker container when this file is mounted as a volume

I'm using the following image https://hub.docker.com/r/dpage/pgadmin4/ to set up pgAdmin4 on Ubuntu 18-04. I have mounted a volume containing a pgpass file (which was also chmod for the pgadmin user inside the container) as you can see in my Compose…
swiss_knight
  • 5,787
  • 8
  • 50
  • 92
6
votes
1 answer

PgAdmin for Windows in the latest version (4.28) doesn't start anymore, hangs in the loading screen and shows JavaScript errors in the browser console

PgAdmin in the latest version (4.28) doesn't start anymore, hangs in the loading screen and shows JavaScript errors in the browser console. What can I do?
FranzHuber23
  • 3,311
  • 5
  • 24
  • 63
6
votes
4 answers

postgresql pgadmin keep loading forever

I have tried to install postgresql+ pgadmin multiple times. My environment is Window 10 and the postgresql version is 10.15 (postgresql-10.15-1-windows-x64.exe). The installation completed but when I run pgadmin, it just keep loading as…
Steve
  • 2,963
  • 15
  • 61
  • 133
6
votes
1 answer

ERROR: COPY quote must be a single one-byte character

COPY public.performance (fl_date, mkt_carrier, mkt_carrier_fl_num, origin, origin_city_name, origin_state_abr, dest, dest_city_name, dest_state_abr, dep_delay_new, arr_delay_new, cancelled, cancellation_code, diverted, carrier_delay, weather_delay,…
Akindele matin
  • 61
  • 1
  • 3
6
votes
1 answer

Remove Query History window from PGadmin

I am not sure how I activated this option in pgAdmin, but I got no idea on how to remove it. Every time I open pgAdmin it goes through every single query which means I have to wait a couple of minutes before I can start querying again. Does anybody…
Sergi
  • 471
  • 3
  • 13
6
votes
2 answers

Fatal: password authentication failed for user "postgres" macos

I'm using PostgreSQL for the first time and I am not familiar with it. When I start pgadmin and enter master password and when I want to connect to postresql and again enter same password following error pops up: could not connect to server: could…
Severin Stillhard
  • 61
  • 1
  • 1
  • 4
6
votes
2 answers

pgadmin 4.9 'int' object has no attribute 'replace' with editing text fields

I have just installed pgadmin 4.9 and am trying to edit several fields in my existing database. I right-click the table, select "View/Edit data" -> "All rows". Then in my table I change the data in a field of type "Text". When I then press the…
NicolasR
  • 2,222
  • 3
  • 23
  • 38
1 2 3
…
78 79