Missing extensions in configuration tab --PoWA Web

[r-chauhan16]

Hi,

In PoWA remote server, I have hypopg and pg_track_settings installed.

But when I check in powa web -> configuration -> server name. I see these 2 extensions are not installed, available and enabled, as seen in the screenshot below. Also these are not collecting any data.

In the POWA repository, I have powa and pg_stat_statements extensions.

Did I miss any configuration for these 2 extensions?

[rjuju]

First of all, it's unfortunately not very well documented but pg_track_settings is an "external" extension that provides its own infrastructure for powa compatibility. Therefore it needs to be installed on the repository server too.

This may not fix the problem, but in any case that will be required if you want to gather this extension data for your remote server(s).

Then, I'm wondering if you did specify pg_track_setting extension when registering the remote server? Can you show the content of powa_extensions and powa_functions for the given server? Something like:

SELECT * FROM powa_extensions WHERE srvid = $mysrvid;
SELECT * FROM powa_functions WHERE srvid = $mysrvid;

Finally, for hypopg this is expected. It's not a stat extension and is needed if you want powa to automatically check if suggested indexes would be used. Therefore even if hypopg is installed in the remote server on the powa database, it's likely that you will need it in your application database instead.

[r-chauhan16]

Hi

So yes, pg_track_settings was not activated in the powa repository database.

So I have activated it using powa_activate_extension as seen above.

I have to install and create pg_track_settings extension in a remote server inside the database - powa or actually database (prod/test) or in both databases.

Hypopg I have installed in remote server powa DB and application DB both. so that looks good?

[r-chauhan16]

After activating the extension for srvid 3 using powa_activate_extension and restarting the collector process I am getting the below errors. Do I have to install pg_track_settings in powa repository as well.

[rjuju]

Yes, I mentioned that first in my previous answer:

First of all, it's unfortunately not very well documented but pg_track_settings is an "external" extension that provides its own infrastructure for powa compatibility. Therefore it needs to be installed on the repository server too.

This may not fix the problem, but in any case that will be required if you want to gather this extension data for your remote server(s).

Everything should work fine automatically as soon as the extension is installed on the repository server, without needed to restart anything.

Hypopg I have installed in remote server powa DB and application DB both. so that looks good?

Yes it should. If there's any problem you will have an explicit message saying that hypopg isn't available on the needed database.

[rjuju]

Did the errors eventually cleaned up at the next snapshot, or could you otherwise fix the problem?

[r-chauhan16]

After couple next snapshots ... error was still there. So I have removed for now. I'll try again.

[rjuju]

That's strange. Was the extension installed in both remote and repository server in the powa-dedicated database?

Anyway, feel free to reopen the issue or create another one if you come back to it.