PGAdmin: Not connected to the server or the connection to the server has been closed

database postgresql pgadmin pgadmin-4
Jorge picture Jorge · Dec 21, 2016 · Viewed 29.4k times · Source

i got this problem with postgreSQL, when i do a simple query of anything (CRUD), sometimes it works and almost always shows this message:

Not connected to the server or the connection to the server has been closed.

I don't know how to solve it and it started to irritate me, anyone know how to fix it?

UPDATE 1

I have been searching and it seems the pgadmin4 the problem (it seems because it's not 100% developed yet), i have been using pgadmin3 and that error doesn't show up.

Answer

lucidbrot picture lucidbrot · Mar 10, 2017

The reason this happened for me was a syntax error in the query. Check your syntax and try again, maybe this suffices

Related questions

Export Postgresql table data using pgAdmin

I am using pgAdmin version 1.14.3. PostgreSQL database version is 9.1. I got all Db script for table creation but unable to export all data inside tables. Could not find any option to export data in db script form.

Read More
PostgreSQL how to see which queries have run

I have a PostgreSQL DB at my computer and I have an application that runs queries on it. How can I see which queries has run on my DB? I use a Linux computer and pgadmin.

Read More
How to visualize database tables in postgresql using pgAdmin?

I am trying to visualize tables and their relations using pgAdmin. I have understood that there is a query visualizer tool available for pgAdmin. However, that only is useful if you are dealing with queries. My main goal is to …

Read More