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
5
votes
3 answers

How to update the Pgadmin4 docker image?

How to update the Pgadmin4 docker image without losing any the user's information in the folder/var/lib/pgadmin?
Thirumal
  • 8,280
  • 11
  • 53
  • 103
5
votes
0 answers

How to install PgAdmin 4 on Ubuntu 20

I've installed PgAdmin III through "Ubuntu Software" manager but it is crashing. I've tried to "sudo apt-get update" and then, sudo apt-get pgadmin4. I get a message that this package doesn't exist. I've tried all the things I've found related to…
Diego Alves
  • 2,462
  • 3
  • 32
  • 65
5
votes
3 answers

Docker dpage/pgadmin4 error: specified user does not exist

This is the docker-compose.yml file: version: '3' services: ############################ # Setup database container # ############################ postgres_db: image: postgres restart: always ports: -…
Markus Weber
  • 1,059
  • 1
  • 11
  • 24
5
votes
1 answer

"No such database" error on pgAdmin when connecting through pgbouncer

I have configured pgbouncer on server A(port 6432, host addr: 10.XX.XX.92) that will accept the connections for postgres server running on server B(port 5433, host addr:10.XX.XX.90). This postgres server has 2 databases.(postgres and db1) I have 2…
Esha
  • 63
  • 1
  • 3
5
votes
2 answers

Export connections in pgadmin4

How can I export connections in pgadmin4? I intend to us pgadmin in docker and I want to map the servers.json as suggested. So I thought to simply export my connections in a local pgadmin4 and map them. I found an explanation to export servers.…
Alfred Pontiac
  • 83
  • 1
  • 6
5
votes
0 answers

pgAdmin 4 PostgreSQL Query Tool always showed disconnect logo

I have a server in Heroku that run in PostgreSQL. This is my first time deploy to Heroku and try to running in PostgreSQL (actually this also my first time PostgreSQL). I Have a problem with this query tool feature. I NEVER able to write some SQL…
Richie Permana
  • 294
  • 3
  • 15
5
votes
2 answers

pgAdmin 4 how to see current restore jobs?

On pgAdmin 4 v3.1, I right click a database, click Restore, choose a backup file and click go. A little green popup says "Restore job created" which fades away, but no other indicator shows a restore under way. There used to be a window that stayed…
Andrew
  • 18,680
  • 13
  • 103
  • 118
5
votes
5 answers

Postgresql 10.4 with pgadmin 4 v3.0 issue - Query Tools Initialized Error for Windows 10 x64 User

I had been running pgadmin4 v2.0 with no issues. This is happen when i upgraded my postgresql to 10.4 I have encountered a problem where pgadmin 4 v3.0 cannot initialize Query tools I have uninstall and reinstall the postgresql multiple times but it…
Iwan Tantoso
  • 63
  • 1
  • 6
5
votes
3 answers

How to start pgAdmin 4 v3

I upgrade from pgAdmin 4 v2.1 to v3 in my Windows 10 pro machine. There is an option for me to open pgAdmin at the last step of installation. I clicked yes and it automatically open it using my default browser. I notice the url is…
Simon
  • 1,426
  • 3
  • 16
  • 24
5
votes
2 answers

PgAdmin4 download files

Is there any way to download the backup files saved on the server's file system by pgadmin4 server. The best way I thought was to make the files available through Apache, but this solution has problems with authentication, or leaving the files…
Klaifer Garcia
  • 340
  • 1
  • 12
5
votes
4 answers

POSTGRESQL: 'utf8' codec can't decode byte 0xfc in position 36: invalid start byte

I just downloaded and installed PostgreSQL from here https://www.enterprisedb.com/downloads/postgres-postgresql-downloads I wanted to create my first server but I get this error 'utf8' codec can't decode byte 0xfc in position 36: invalid start…
Question3r
  • 2,166
  • 19
  • 100
  • 200
5
votes
2 answers

running pgadmin4 in docker with pre-configured servers

I'd love to run pgadmin4 in our infrastructure in a way, that postgres servers would be preconfigured during docker build/1.st start. I've tried to modify the internaly used /var/lib/pgadmin/pgadmin4.db sqlite DB on the 1.st start, which however…
Peter Butkovic
  • 11,143
  • 10
  • 57
  • 81
5
votes
1 answer

Slow indexing of 300GB Postgis table

I am loading about 300GB of contour line data in to an postgis table. To speed up the process i read that it is fastest to first load the data, and then create an index. Loading the data only took about 2 days, but now I have been waiting for the…
Einar
  • 71
  • 5
5
votes
3 answers

PGAdmin 4 fails to backup database with no errors

I try to backup my university project database. I followed the instruction, everything seems to be inputed: 1: 2: 3: But the only pop-out I get is this one in right-bottom corner of PGAdmin 4: From the Official site, there should be another…
xinaiz
  • 7,744
  • 6
  • 34
  • 78
5
votes
4 answers

PGAdmin III cannot connect AWS RDS

I am trying to connect AWS RDS PostgreSql from PgAdmin 3. I followed the below link http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToPostgreSQLInstance.html In Security Group, I also added PostgreSQL and All traffic as below The…
franco phong
  • 2,219
  • 3
  • 26
  • 43
1 2 3
…
78 79