rjuju
commented
2 years ago Hi,
First of all hypopg is a bit of an exception in that list, as it's not a "datasource" extension. It's used when checking for index suggestion, and needs to be installed in the target database and not the dedicated powa database.
That being said, I think that the current code indeed won't try to retrieve hypopg version from the remote server if you have powa 4.1.0 or later, and this version won't try to locally retrieve hypopg version as it does for the one configured when declaring a remote server.
I will double check that and try to fix the situation, however I'm afraid that it will have to be fixed via powa-collector.
MikhailSaynukov
banlex73
Hi!
trying to install Powa in Remote architecture, remote serves successfully initialised and I can see statistics but in Configuration for remote servers hypopg extension showing as is unavailable. HypoPG was installed on remote servers and seen in Postgres:
postgres=# \dx List of installed extensions Name | Version | Schema | Description
----------+---------+------------+------------------------------------- hypopg | 1.2.0 | public | Hypothetical indexes for PostgreSQL pgcrypto | 1.3 | public | cryptographic functions plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language (3 rows)
But in web interface the following data can be seen:
Please advise how to check proper installation and how to fix this in Configuration tab?