PgAdmin4 unable to query or view data

Cardin picture Cardin · Feb 26, 2017 · Viewed 54.9k times · Source

I have a very basic PostgreSql table. Despite the simple table schema, I cannot query it via PgAdmin4.

The View Data option is unresponsive; Query Tool option becomes unresponsive after a few attempts in opening and closing the panel. When the Query Tool is eventually (somehow) launched, a trivial SQL statement like

SELECT * FROM test_table

will spin forever and never display.

View of Database

The diagram above shows the exact same table, which is okay under PgAdmin3.

The table was created empty. Then added with a row. But it threw errors about not having a Primary Key. Which also threw errors when I tried to set a Primary Key. So I used TeamPostgreSql to set a Primary Key. So all is good under PgAdmin3 now. Hence I'm really curious about what's going on with PgAdmin4?

Answer

Fernando Fabreti picture Fernando Fabreti · May 18, 2018

I'm running pgAdmin4 v3.0 and I've put localhost as host name.

I mean, left panel > servers > create > server and then connection tab > host name

I could not query tables, clicking on view/edit data > all rows had no results (nor error log entries).

After I changed server name from localhost to 127.0.0.1, all worked as expected!

I hope it helps, because I've lost so much time on this and could not find a proper answer.