No graphical explain plan with pgadmin4 3.6.5

2018-12-25 Thread SQL Design
Hello,

But if I do "explain select...", I have a textual explain plan.

In Preferences, all options for explain are set to true.

I installed PostgreSQL and pgadmin4 via Docker (last version) on Ubuntu
16.04.

Please have a look on
https://sqldesign.blog/2018/12/24/how-to-install-pgadmin4-with-docker/

Everything else seems to work fine

Thank you for your attention


No graphical explain plan with pgadmin4 3.6.5 : solved

2018-12-25 Thread SQL Design
I solve the problem :

on the ribbon : explain and explain shift

have a nice day


pgadmin4 in a docker container and pg cluster on local

2018-12-31 Thread SQL Design
Hello,

I installed PostgreSQL 11 in a docker container and pgadmin4 in another one.

See https://sqldesign.blog/2018/12/24/how-to-install-pgadmin4-with-docker/

It works fine.

I installed PostgreSQL 11 in local.

But I cannot access local pg cluster from pgadmin4 in my container.

IP address of local (given by google) : 217.39.18.97
IP address of pgadmin4 container (given by docker inspect) : 172.17.0.3
Port of local pg cluster (given by \conninfo) : 5433

in pg_hba :
hostall all 0.0.0.0/0   md5

What can I do ?

Thank you