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
9
votes
1 answer

Failed to launch application server, server thread existing on windows

I used the EnterpriseDB postgresql installer from their website, but when I finished and ran pgadmin (that came installed with postgresql) I get a configuration error that says: An error occurred initializing the application server: Failed to…
sourlemonaid
  • 504
  • 2
  • 6
  • 19
9
votes
1 answer

pgadmin 4 import/export table does not work

I have made sure that the columns match the 'column to export' field in the columns tab, not null columns have data, tried in both csv and txt but all i get is a message saying: import/export job created Nothing else: no errors, no warning, no…
Blue
  • 195
  • 1
  • 4
  • 9
9
votes
1 answer

pgAdmin 4 Migrate server list from pgAdmin III

How to migrate/import Server list with login info in pgAdmin 4 from pgAdmin III. In pgAdmin III installations that was done with migrating pgadmin registry keys with regedit, but as I see new pgAdmin has different registry structure in different…
Sasa Bajic
  • 113
  • 1
  • 6
8
votes
1 answer

"Instance is not persisted"

After a fresh install of postgreSQL15, it seems as if it installed correctly, because I can access the server through psql just fine. But, when I attempt to access it through pgAdmin4, it does not automatically detect the server. Because of this, I…
Zach9224
  • 93
  • 1
  • 1
  • 6
8
votes
3 answers

pgAdmin4 Query Error "not enough values to unpack (expected 5, got 4)"

I can't run queries on pgAdmin4 on Ubuntu 19.04. I can view data through pgAdmin and execute queries through my terminal. However, whenever I try to use the query tool I get the error not enough values to unpack (expected 5, got 4). I've tried…
i0trost01
  • 83
  • 3
8
votes
3 answers

Accessing WSL postgresql server from Windows PGadmin

I am running postgresql in WSL Ubuntu on windows. Everything is up to speed, my data is loaded and I wish to access the database through some graphical interface. I was thinking pgadmin4. Is it possible to accomplish this through a windows install…
LoF10
  • 1,907
  • 1
  • 23
  • 64
8
votes
2 answers

pgAdmin 4 Query Tool not connecting to database

I am trying to query a remote database that I am connected to, however am having issues 'connecting' to the database with the Query Tool. The Query Tool opens, however the 'plug' icon stays red and doesn't seem to connect to the database (see…
bellingc
  • 81
  • 1
  • 3
8
votes
2 answers

PSQL console in PgAdmin IV

Can anyone tell me where I can find it (or what's the workaround) ? In PgAdmin III it is in "Plugins". I need it in order to \copy.
Florian Seliger
  • 421
  • 4
  • 16
8
votes
8 answers

PgAdmin fatal error. The appllication server could not be contacted

A couple of days before I have installed on my PC with Windows 7 Professional new version of PgAdmin (version 4). It worked fine, but today it loads slowly and then information window appears with text: "PgAdmin fatal error. The appllication server…
Dionisius1976
  • 107
  • 1
  • 1
  • 7
8
votes
3 answers

pgadmin4 wont work in specific location behind nginx

I got some trouble: pgadmin working perfect behind nginx in location /, but it wont work behind location /pgadmin Work great: location / { proxy_http_version 1.1; proxy_set_header X-Real-IP $remote_addr; proxy_set_header…
Виталий Коростелёв
  • 83
  • 1
  • 4
7
votes
1 answer

pgAdmin disable login dialog / automatic login

I'm running pgAdmin using docker-compose with the following script: version: "3.9" services: postgres: image: "postgres:13" container_name: "postgres" environment: POSTGRES_PASSWORD: pwd ports: - "5432:5432" …
Marcel Overdijk
  • 11,041
  • 17
  • 71
  • 110
7
votes
1 answer

pgAdmin failed to save password for users

I have pgAdmin (dpage/pgadmin4:4.29) container running in Kubernetes. As a master user I have added Database connections and share the connection. I can disconnect/reconnect to database without password as a master user. But for additional users I…
roy
  • 6,344
  • 24
  • 92
  • 174
7
votes
2 answers

opening PgAdmin 4 in Chrome

I want to open PgAdmin 4 in Chrome. I have right clicked the icon in the Windows System Tray and selected Configure... In the Browser Command input, I have added the following: "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"…
user14251114
7
votes
1 answer

How to import a large csv file(~4GB) to PostreSQL database?

Currently, I am using PostgreSQL 11.2 and I have a ~4GB .csv file. Firstly I am trying to create a temporary table and select the needed columns to fill my current table. create temporary table t (identification varchar, a1 text, a2 text, a3 text,…
eaytan
  • 319
  • 2
  • 3
  • 10
7
votes
1 answer

Start and Stop pgAdmin4 correctly on Ubuntu 16.04

I'm working on a project that involves the creation of a dashboard (SpringBoot + angular.js webapp) for the interrogation of Zabbix. For the purpose of testing I installed Ubuntu 16.04 LTS (VirtualBox), PostgreSQL 9.6 in which I imported by command…
CoderJammer
  • 599
  • 3
  • 8
  • 27
1 2 3
…
78 79