Cannot install dict_xsyn & xml2 extension

PostgreSQL
1

Hi,
I encounter an issue migrating from ElephansSQL to Aiven.

From the doc at this point

“When the service is created, install any extensions you might need. Some ElephantSQL databases use the dict_xsyn and xml2 extensions by default”

Then from your doc :

“Any available extension can be installed by the avnadmin user with the following CREATE EXTENSION command:
CREATE EXTENSION <EXTENSION_NAME> CASCADE;”

or sometimes :
[42501] ERROR: permission denied to create extension “xml2” Indice : Must be superuser to create this extension.
[42501] ERROR: permission denied to create extension “dict_xsyn” Indice : Must be superuser to create this extension.

I’m connected with the avnadmin user of course.

Moreover, theses 2 extensions are listed in “SELECT * FROM pg_available_extensions;”

Can you help on this issue please ?

Regards

2

You might want to refer to this answer as it appears to be the same issue. avnadmin is not the superuser on the instance, as it is a managed service.

3

Thanks for your reply, i saw your reply on this answer before posting here, I hoped there was any evolution on this, since may.
Unfortunately not.