PostgreSQL in Azure Data Studio has a trouble about pgtoolsservice HOT 4 CLOSED

I have the same issue. The python path is incorrect. I think ADS looks for Python 3.6.12 in the /opt path.

from pgtoolsservice.

I've changed from Ubuntu 20.04 to Fedora 35, to learn some things that is almost same on RHEL and CentOS...
I don't know why, but, I didn't have this trouble ao usar o Fedora 35! I'm asking to myself "what the f**** hell? Ubuntu 20.04 does't works and in Fedora 35, works... holy s***!". Sorry for the profanity and innapropriate words!

I checked that Fedora 35 comes with last python version (3.10) and I've installed PG 14 from official repositorie, got on official postgre website (I've configured to ignore any versions of PG, come from Fedora repositories). I didn't installed another python version. On Ubuntu 20.04, I installed python 3.10 and I did somes changes, to pip work firstly python 3.10 instead of another versions. I don't know if this change that I did on Ubuntu, was cause to got this trouble.

But, before open this issue, I seen these python files, on vim and nano, but I didn't have free time to debug the python script. But, in my case, these files existed...

from pgtoolsservice.

In the message log it says :
ImportError: libffi.so.6: cannot open shared object file: No such file or directory

See #218

and resolution proposed here : #283 (comment)

curl -o libffi6_3.2.1-8_amd64.deb http://mirrors.kernel.org/ubuntu/pool/main/libf/libffi/libffi6_3.2.1-8_amd64.deb

and then

sudo apt install ./libffi6_3.2.1-8_amd64.deb

this issue should be closed ?

from pgtoolsservice.

Bug has been addressed in latest stable release of PostgreSQL extension v0.4.1. Please reopen if issue persists, thank you.

from pgtoolsservice.