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
2 answers

How to use \copy in postgresql with pgadmin4

I want to use the \copy command to make csv file with relative path. I used a query to make from test table to csv file named test.csv \copy (SELECT * FROM test) to './test.csv' with csv But in postgresql pgadmin4, it shows that \copy command as a…
윤성필
  • 85
  • 1
  • 1
  • 7
5
votes
5 answers

pgAdmin4 import file error - can't find file

I'm having a problem importing a csv file to pgAdmin4 on a mac - it simply can't find the file. This is so simple that I'm hoping there's just a setting I've failed to set up. In the import/export data function on a table, there is the…
Mike
  • 324
  • 2
  • 3
  • 9
5
votes
1 answer

pgadmin4 execute pgscript option not available

I just switched from pgadmin3 to pgadmin4, just to check it out. I was using the query tool and was not able to find execute as pgscript option at all, this was available in pgadmin3. The documentation for pgadmin4 query tool does not mention…
Vikash Balasubramanian
  • 2,921
  • 3
  • 33
  • 74
4
votes
1 answer

Postgres 'NoneType' object has no attribute 'strip'

'NoneType' object has no attribute 'strip' I deleted FKs and PKs. Pgadmin has stopped working properly. The tables with which FK and PK are related don't work either. Nothing is deleted. And the data is not showing. How can I fix?
İzel Özarslan
  • 41
  • 2
4
votes
1 answer

pgadmin db restriction server property not working

I have a heroku postgres database. On pgadmin i can see over 1,700 databases since they are all on the same host. I have set the server connection settings as provided by heroku and i can see my database highlighted in yellow and can access it…
AhmadBenos
  • 141
  • 1
  • 9
4
votes
1 answer

Why Pgadmin gives me 500 error? _pickle.PicklingError: Can't pickle : attribute lookup Meta on wtforms.form failed

Occasionally, Pgadmin gives me the 500 error in a browser. After reloading the page, the issue disappears for a while and then comes back again. Here's the log I see while getting the error: [2022-01-21 14:35:21 +0000] [93] [ERROR] Error…
Vladimir Tarasov
  • 41
  • 1
4
votes
2 answers

pgAdmin4 error: ModuleNotFoundError: No module named 'email_validator'

I'm trying to install pgadmin4 on Arch Linux. Here is what I did: sudo pacman -S pgadmin4 Then I simply tried running pgadmin4 and got the following error: "An error occurred initialising the pgAdmin 4 server:\n\nFailed to launch the application…
Dimitar Dimitrov
  • 14,868
  • 8
  • 51
  • 79
4
votes
10 answers

Fatal Error The pgAdmin 4 server could not be contacted (already tried solution in other thread)

I get the pgadmin 4 server could not be contacted. This is the first time I installed on my computer. I tried the run as admin solution, remove the app/roaming files, restart the posgresql services, tried to modify the config.py, config_distro.py.…
Leong Chen Onn
  • 71
  • 1
  • 1
  • 6
4
votes
1 answer

PgAdmin 4 cannot connect to the server error in PostgreSQL database in Windows 10

I have installed Postgresql 13.2.2 X64 database server in my Windows 10 computer. After installation, whenever I want to run the PgAdmin 4 tool it shows the below error. I tried a lot to fix the problem. Can anyone help me to solve the…
mnu-nasir
  • 1,642
  • 5
  • 30
  • 62
4
votes
2 answers

importing csv files from local machine to postgresql docker container using pgadmin4

I am learning to use docker. I am setting up a database using postgresql and pgadmin4 using docker. I wrote a docker-compose.yml file as follows, version: '3.8' services: db: container_name: postgres image: postgres restart: always …
Akash Tadwai
  • 100
  • 1
  • 9
4
votes
0 answers

Using pgAdmin 4 behind corporate proxy

I am using pgAdmin 4 (v. 4.2.6). Is there a possibility to let pgAdmin communicate with the corporate proxy? We have no direct internet access, because all traffic is handled by our corporate proxy. I found no possiblity to define our corporate…
denfri.dev
  • 131
  • 2
  • 11
4
votes
3 answers

CREATE DATABASE cannot run inside a transaction block in pgadmin 4

I am triing to run a script in pgAdmin 4, but I get this error: CREATE DATABASE cannot run inside a transaction block And this is the script: CREATE USER ky_auth WITH PASSWORD 'ky_auth'; COMMENT ON ROLE ky_auth IS 'KnowYourself Auth Database…
user12911826
4
votes
4 answers

pgadmin4 connect to postgres in Google Cloud SQL

I am not able to connect through pgAdmin4 to Google Cloud SQL. Following are the credentials I am providing and getting the error messege:
Apu
  • 147
  • 1
  • 4
  • 12
4
votes
3 answers

Getting permission exception when run docker-compose up with dpage/pgadmin4 image

I'm trying to build a ruby rails docker-compose postgreSQL db with pgadmin4, but keep getting permission exception from the container. Even /bin/sh in the container returns the same error. I'm using Ubuntu 18.04.3 LTS Full log db_1 |…
NganCun
  • 155
  • 1
  • 4
  • 13
4
votes
3 answers

How to use psycopg2-binary in Python?

I installed the psycopg2-binary package using pip install psycopg2-binary. But when how can I use it in Python? import psycopg2 as pg2 conn = pg2.connect(database = 'dvdrental', user = 'postgres', password = secret) cur =…
tainangao
  • 121
  • 1
  • 2
  • 9
1 2 3
…
78 79