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
11
votes
7 answers

PostgreSQL Binary Path in pgAdmin 4 1.0-rc1

What needs to go in the field PostgreSQL Binary Path under File > Preferences > Path > Binary paths?
Thomas Landauer
  • 7,857
  • 10
  • 47
  • 99
10
votes
2 answers

Postgres and Docker Compose; password authentication fails and role 'postgres' does not exist. Cannot connect from pgAdmin4

I have a docker-compose that brings up the psql database as below, currently I'm trying to connect to it with pgAdmin4 (not in a docker container) and be able to view it. I've been having trouble authenticating with the DB and I don't understand…
OmegaNalphA
  • 610
  • 1
  • 6
  • 17
10
votes
1 answer

pgadmin-4 in docker failed with gunicorn server start error

I am trying to run pgadmin in docker like below and getting exception while starting gunicorn 20.0.4 error. Any pointers to fix this? docker run -p 80:80 -e "PGADMIN_DEFAULT_EMAIL=email@domain.com" -e "PGADMIN_DEFAULT_PASSWORD=postgres" -d…
Minisha
  • 2,117
  • 2
  • 25
  • 56
10
votes
2 answers

PgAdmin 4: Save Server Connection Details

Running pgAdmin 4.2.0 in a Docker container using the image dpage/pgadmin4, I notice that server connections are not being saved. The container is created with the volume mapping: ./data/pgadmin:/root/.pgadmin When the docker container is…
Nyxynyx
  • 61,411
  • 155
  • 482
  • 830
10
votes
4 answers

Make column editiable in pgadmin4

How to unlock the fields in pgadmin4 so I can insert/update column directly threw pgadmin4 Data Output result. Please refer below image displaying lock icon in each field I want result like below which has icon of a pencil which shows that the…
Vishnu S. Divetia
  • 305
  • 1
  • 2
  • 10
10
votes
2 answers

Why does running a query return 'table_oid' under messages and nothing under Data Output

Running any sort of query on pgAdmin 4 just returns a 'table_oid' under messages. I am able to get the necessary data when running the query from the command line, for example SELECT ST_MakePolygon(ST_GeomFromText('LINESTRING(75.15 29.53,77 29,77.6…
Philip Wee
  • 113
  • 7
10
votes
3 answers

PostgreSQL 11 configurations doesn't allow pgAdmin4 to connect

I'm pretty new to PostgreSQL so the question may be simple. So. I have installed PostgreSQL 11 and pgAdmin 4 on Fedora 29. I can connect to the database via terminal or AzureDataStudio, but when I try to connect with pgAdmin, I get this…
amiry jd
  • 27,021
  • 30
  • 116
  • 215
10
votes
2 answers

ERROR: cannot execute SELECT in a read-only transaction when connecting to DB

When trying to connect to my Amazon PostgreSQL DB, I get the above error. With pgAdmin, I get "error saving properties". I don't see why to connect to a server, I would do any write actions?
Gilles Groven
  • 121
  • 1
  • 1
  • 5
10
votes
3 answers

How to rename current database in pgadmin 4?

I'm trying to rename a DB in pgAdmin 4. But I this get error: ERROR: current database cannot be renamed. What's the process for renaming a database in pgAdmin (the docs are USELESS)? And google can't provide a solution.
user9510274
9
votes
1 answer

How to create read-only user in pgAdmin 4?

Creating a read-only user in pgAdmin 4 is a little tricky. Here is a guide on how I did it. First of all a few words about the process. The whole process is based on editing a schema (very simple and safe) for your DB, so this creates limitations…
Arsenii
  • 655
  • 1
  • 8
  • 20
9
votes
1 answer

PgAdmin4 - 'NoneType' object has no attribute 'value'

I used to have a functioning PostgreSQL database, but upon reinstalling due to computer issues, I am now getting this error after launching: File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py", line 98, in app =…
joshiki
  • 167
  • 2
  • 11
9
votes
5 answers

I forgot to configure login Email id and password while install pg admin 4. how i can change after installation

I am new to pgAdmin 4. I have forgot to setup of login Email id and password while install pgAdmin 4. How can I change after installation? Any one can help me?
chandrasekar
  • 334
  • 1
  • 4
  • 9
9
votes
1 answer

How to set dark theme for pgadmin4 in ubuntu

Is there any way to set dark theme in pgadmin4 for ubuntu 18.04 as the default white background is starining.
Nitish awasthi
  • 133
  • 2
  • 10
9
votes
0 answers

How to fix "pgadmin4-apache2" error in Ubuntu 18.04 command line installation

When installing on Ubuntu 18.04 (bionic beaver), majority of packages I encounter an error involving "pgadmin4-apache2" that causes the installation to fail. What is causing this error and if it requires the re-installation of "pgadmin4-apache2" how…
Brent
  • 177
  • 2
  • 9
9
votes
1 answer

PostgresSQL / pgAdmin4 / dump server version mismatch

I tried to make a backup with Postgres 11.1 in pgAdmin4, but it failed. pgadmin displayed a window with Status: Failed (exit code: 1). pg_dump:server version: 11.1; pg_dump: 10.5 pg_dump: aborting because of server mismatch I don't really…
black_hole_sun
  • 908
  • 11
  • 41
1 2 3
…
78 79