I can connect to nhost database from pgAdmin client. I put all the credentials but still throw an error authentication failed. I already reset the password and copy to pgAdmin and still its now working.

You can connect, or the connection is failing?

sorry typo. yeah, its failing. as you can see to may other questions about a permission error when adding postgres extensions. I would like to try if I could add the extension using pgAdmin.

the problem is that i can't also connect

Are you able to connect with another tool than pgAdmin? Or you've never been able to connect to the database using the credentials?

here is the error basically

but ill try other pg client

same with DBeaver

for the password, what i did is i generate a new password then click reset. after that i copied the password to use it

Can you try to use the database defined in the Nhost Dashboard instead of postgres?

shucks by bad. youre right. anyway, i now have postgis extension. 🙂

Glad it worked.

i run CREATE EXTENSION IF NOT EXISTS postgis; through pgadmin client